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?