Issue with Key-Pair Authentication in Snowflake Destination

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

User reports an error encountered while setting up key-pair authentication for a Snowflake destination connector, referencing documentation.


Question

Hey! Is anyone having trouble setting up key-pair authentication with Snowflake destination? I get a strange error while I am following the doc


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['key-pair-authentication', 'snowflake-destination', 'setup-error', 'documentation']
2

Are you trying to upload the file or paste the content from the clipboard?
Not ideal, but did you try to connect using user/password?

3

I tried both by uploading and copy/past but it’s still not working. An yeah, username/password works but the goal is to use key pair…

4

Can you check your key has the breaking line \n ?

  "host": "host.us-east-2.aws.snowflakecomputing.com",
  "role": "INTEGRATION_TESTER_DESTINATION",
  "warehouse": "INTEGRATION_TEST_WAREHOUSE_DESTINATION",
  "database": "INTEGRATION_TEST_DESTINATION",
  "schema": "TEXT_SCHEMA",
  "username": "INTEGRATION_TEST_USER_DESTINATION",
  "credentials": {
    "private_key": "-----BEGIN PRIVATE KEY-----\n{ALOTOFSTUFFGOINGHERE}u\n-----END PRIVATE KEY-----"
  },
  "loading_method": {
    "method": "Internal Staging"
  }
}```
There isn’t any issue reporting this problem in Github.
5

Should it explicitly contain ‘\n’? Because it does not seem to work and I have the new line in the code I upload

6

Give a try… The config I shared is the one used by Airbyte integration tests.

7

Yeah still not working, I wrote to the support but no answer so far

8

Are you using Airbyte cloud or open-source?

9

For encrypted private key file there are differences in instructions
https://docs.airbyte.com/integrations/destinations/snowflake#key-pair-authentication
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -v1 PBE-SHA1-RC4-128 -out rsa_key.p8

while in Snowflake docs
https://docs.snowflake.com/en/user-guide/key-pair-auth#configuring-key-pair-authentication
openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out rsa_key.p8