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

Question

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 ?

Sergiu · Accepted Answer · 2022-03-30 15:30:55Z

0

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.

answered Mar 30, 2022 at 15:30

Sergiu

4,7661 gold badge16 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jay Over a year ago

it worked fine .. Thanks

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related