variable to point multiple meltano projects at the same (PostgresSQL) system database, and then send each project into a specific target schema?
a
aaron_phethean
12/07/2022, 5:01 PM
Yes. We do this for each of our customers - creating databases on the fly in postgres, but same database. Using 'public' for meltano state and 'analytics' for the models. (other schemas for staged data in some cases)