Multi DB Environments


I have a question regarding the use of liquibase for multi DB environments where each DB represents a different layer or stage of data in an operational data store. For example:


  • Landing Zone
  • Staging (Type 2)
  • HUB (Normalized Data Model)
  • Data Marts (Reporting Layer)

These DBs must be consistent across dev → test → prod environments.

My question is, would it be best practice to have a master change log per DB instance? One for the HUB, one for the data marts, etc… or would it be better to utilize the context tags or preconditions in a singular master change log to deploy scripts to all databases?