I am working on a standard tap that pulls from Snowflake and standard loader into Bigquery. I am able to get it working locally just fine. I am using Github Actions to put it into production. I put the Snowflake password into Github Secrets. In production, I keep getting errors that my Snowflake username and password combo is incorrect. I've checked the Github Action secrets. I've even tried changing

${{ secrets.SNOWFLAKE_PASSWORD }}

to

${{secrets.SNOWFLAKE_PASSWORD}}

(trimming out the spaces), but I'm still getting the error. Any troubleshooting suggestions?

${{ secrets.TAP_SNOWFLAKE_PASSWORD }}

?

What are you mapping to

${{secrets.SNOWFLAKE_PASSWORD}}

in your workflow yaml?

This is what ended up working: Having something like this in my `meltano.yml`:

password: $SNOWFLAKE_PASSWORD

and moving the

env

config up higher in the

workflow.yml

to say it like so:

Good that you got it working, although you shouldn't need to define that

password: $SNOWFLAKE_PASSWORD

mapping in your config, since Meltano will allow you to configure

password

via

TAP_SNOWFLAKE_PASSWORD

, without you having to do anything extra. Probably you just needed to add

env:
      TAP_SNOWFLAKE_PASSWORD: ${{secrets.SNOWFLAKE_PASSWORD}}

without any change in your

meltano.yml

(I assumed you were mapping the secret key

SNOWFLAKE_PASSWORD

to an environment variable of the same name before).

tap-spotify

test

workflow does this: https://github.com/Matatika/tap-spotify/blob/d98485c6e1c2c1f3f0d4fd24b1c9a195a54bcc28/.github/workflows/test.yml#L16-L18