nicholas_van_kuren
10/07/2022, 4:12 PMselect
configuration. I have the following environment variables:
DBT_POSTGRES_SCHEMA - this is the environment schema prefix for dbt (dev, prod, etc)
DBT_TARGET_SCHEMA - I see this in my profiles.yml for dbt and see that it corresponds to what I set in the schema config for a given model.
So my full schema + table select for a given environment is in theory: ${DBT_POSTGRES_SCHEMA}${DBT_TARGET_SCHEMA}-some_table
However this doesn't work and I am not finding an example of how to specify this the right way. Any ideas?Sven Balnojan
10/10/2022, 9:06 AMken_payne
10/11/2022, 1:57 PMDBT_POSTGRES_SCHEMA
and DBT_TARGET_SCHEMA
are static per environment, you can use the existing selection statements along with Meltano Environments. This works best if there is a table or schema naming pattern with a prefix or suffix that you can easily filter on. e.g.