https://linen.dev logo
#plugins-general
Title
# plugins-general
n

nicholas_van_kuren

10/07/2022, 4:12 PM
I am setting up a tap-postgres that will load data from tables created as part of my inline dbt project. I am trying to figure out how to use environment variables for DBT schema environment variables in the tap
select
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?