hi everyone, starting out with meltano and trying to configure snowflake as my target destination. Currently have this setup in my

meltano.yml

file but keep receiving a "loader failed" error. Using key-pair auth with private key in

.env

file - any thoughts? Tried debugging but logs are unclear to me. Thanks!

loaders:
  - name: target-snowflake
    variant: meltanolabs
    pip_url: meltanolabs-target-snowflake
    config:
      account: xxxx
      add_record_metadata: false
      database: production
      default_target_schema: public
      role: xxxx
      schema: xxxx
      user: xxxx
      warehouse: default

What output do you get from

meltano invoke <tap> > tap.out

# this command
cat tap.out | meltano invoke target-snowflake

?

yeah, no output when running that command

Since you're referencing a

.env

, I'm assuming you have

TARGET_SNOWFLAKE_PRIVATE_KEY

set then (rather than

TARGET_SNOWFLAKE_PRIVATE_KEY

)? If it's encrypted you will also need to set `TARGET_SNOWFLAKE_PRIVATE_KEY_PASSPHRASE`: https://hub.meltano.com/loaders/target-snowflake--meltanolabs/#private_key_passphrase-setting Relevant private key code is here: https://github.com/MeltanoLabs/target-snowflake/blob/08bed1a3064b4152d37d21a23a712945c1020c42/target_snowflake/connector.py#L118-L138 Unfortunately, it might be a case of trial and error with that as a reference.

Hey @Reuben (Matatika) - it seems like I'm able to connect to Snowflake now, though for some reason the CLI returns this error

Exception: Database 'production' does not exist or the user/role doesn't have access to it.

- despite the fact that the database exists + user/role has access to it. I've tried this with multiple users and the sysadmin role and I still get the same error.

Snowflake is funny about casing in my experience, so maybe check your config values match Snowflake's representation.

that was it, thanks !

Awesome 😎 no problem