@nayan_wylde : I can absolutely relate and we also use a metadata database for our control tables. But how do you handle the content of the tables? Until now we just wrote insert scripts in a similar way that flyway uses migrations. The problem ist this gets messy overtime. We have a hard time finding any good solutions for handling the content of the metadata tables.

Right now we want to try out a more state-based setup, where we have the whole database defined as SQL or JSON and a tool like flyway or self-written that handles the actual inserting and historizing (SCD-2). But any larger schema change would result in us having to adjust every single SQL/JSON file (e.g. adding a column).