hey hey, I have env variable substitution in my meltano.yml

select:
    - ${SNOWFLAKE_DBNAME}-RECOS-*.*

but it doesn't seem to substitute that value . I am 100% sure that the value exists in evn variable. I have

dbname: ${SNOWFLAKE_DBNAME}

which does seem to get subsituted

Known issue, I'm afraid: https://gitlab.com/meltano/meltano/-/issues/2481

I also noticed something strange, maybe. Those variables only work if they match

TAPNAME_CONFIGNAME

format. For example it won't work if in dbname if the env variable name was

SNOWFLAKE_DATABASE

Would it be an option to use

*-RECOS-*.*

, or would that end up matching different tables?

select:
    - *-RECOS-*.*

gives me

expected alphabetic or numeric character, but found '*'

Ah, try wrapping it in quotes

that works but I also have this

metadata:
      ${SNOWFLAKE_DBNAME}-RECOS-RECOMMENDATIONS:
        table_name: RECOMMENDATIONS 
        replication-method: FULL_TABLE

You should be able to use

*

there as well

oh nice. Let me try that

Those variables only work if they match 

TAPNAME_CONFIGNAME

 format. For example it won't work if in dbname if the env variable name was 

SNOWFLAKE_DATABASE

Can you share exactly what works and what doesn't, and how you're setting the env var? Is it one you set yourself or one coming from the target-snowflake config?

Sure thing. Maybe i am doing something wrong here but 1. works

.env file 
TAP_SNOWFLAKE_USER=AIRFLOW

meltano.yml 
  extractors:
  - name: tap-snowflake
    namespace: smart_recommendations 
    pip_url: pipelinewise-tap-snowflake
    executable: tap-snowflake
    capabilities:
    - properties
    - catalog
    - discover
    config:
      account: <redacted>
      user: $SNOWFLAKE_USER

@surya_g When you're setting

TAP_SNOWFLAKE_USER

, you're directly setting the

user

setting using the "native" env var that will show up in `meltano config tap-snowflake list`: https://meltano.com/docs/configuration.html#configuring-settings When you set

user: $SNOWFLAKE_USER

or

user: $SNOWFLAKE_USER1

, you should additionally be able to configure that setting through

SNOWFLAKE_USER

or

SNOWFLAKE_USER1

since you're using env var expansion: https://meltano.com/docs/configuration.html#expansion-in-setting-values

oops sorry missed your last question. Yes I am 99% sure it doesn't work.

@surya_g in the second scenario, what does “meltano config tap-snowflake list” say about the user setting?