Hey there I m having trouble setting up target snowflake bas Meltano #getting-started

Hey there, I’m having trouble setting up target-sn...

jozef_reginac

02/23/2022, 3:07 PM

Hey there, I’m having trouble setting up target-snowflake based on the dbt suggestion. I have these setting: •

SF_DATABASE=analytics

•

TARGET_SNOWFLAKE_DBNAME=raw

meltano config target-snowflake list

i see following list of envs:

Copy code

dbname [env: TARGET_SNOWFLAKE_DBNAME, TARGET_SNOWFLAKE_DATABASE, SF_DATABASE] current value: 'analytics' (from the environment)
        DB Name: Snowflake Database name

I want to see current value ‘raw’ but that’s not what I’m getting. Does the order matter? How to overcome this?

jozef_reginac

02/23/2022, 3:18 PM

running

meltano config target-snowflake set --store=meltano_yml dbname raw

gave me only this:

Copy code

Loader 'target-snowflake' setting 'dbname' was set in `meltano.yml`: 'raw'
Current value is still: 'analytics' (from the environment)

edgar_ramirez_mondragon

02/24/2022, 6:03 PM

Hi @jozef_reginac. The environment takes precedence over

meltano.yml

as a settings store. Is one of the following in your environment:

TARGET_SNOWFLAKE_DBNAME

TARGET_SNOWFLAKE_DATABASE

SF_DATABASE

jozef_reginac

02/24/2022, 6:17 PM

Hi Edgar, I see. I have both

TARGET_SNOWFLAKE_DATABASE

SF_DATABASE

set. How to ensure that sf_database is ignored?

jozef_reginac

02/25/2022, 7:48 AM

Oh, I checked once again and you are right. I had just

SF_DATABASE

in env, that’s why it was overriding it. Including

TARGET_SNOWFLAKE_DATABASE

helped. Thanks a lot! 🙏

Open in Slack

Previous Next