snowflake to SSIS connection using ssh auth c (external browser auth working fine)

user_10411161 0
Viewed 61

Need help on connecting SSIS to snowflake using ssh key pair authentication method.

Create a DSN with the required values for: User: Your Snowflake User Server: Your Tenant URL Database: YourDatabase Schema: Your Schema Warehouse: YourWarehouse Role: YourRole Authenticator: ???

what to mention in the authenticator field when i use ssh key pair auth

any help on this ?

snowflake-connector snowflake-cloud-data-platform
1 Answers

When using key/pair authentication with ODBC you need to set:

AUTHENTICATOR = SNOWFLAKE_JWT

Specifies to authenticate the Snowflake connection using key pair authentication with JSON Web Token (JWT).

For more information have a look here.

user_77985480
Related