Select to view content in your preferred language

Connecting to Snowflake with keypair authentication

142
2
Jump to solution
2 weeks ago
AliciaMcMurchie1
Regular Contributor

I'm interested in completing a workflow like that described in this Esri Community blog article (Continuous Integration With Internet Data Sources), but I'm unsure how to write the script to connect with keypair authentication, which my agency uses because Snowflake is deprecating user authentication in a few months. Does anyone have experience with this? I know using Data Pipelines is always there are an alternative, but a lower-cost solution is preferable. 

0 Kudos
1 Solution

Accepted Solutions
rcGIS
by
Frequent Contributor

Hello @AliciaMcMurchie1, from what I see, it should be possible with key-pair authentication too. I read this in the Snowflake documentation: "The Python connector supports key pair authentication and key rotation."

https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-connect#using-key-pa...

View solution in original post

0 Kudos
2 Replies
rcGIS
by
Frequent Contributor

Hello @AliciaMcMurchie1, from what I see, it should be possible with key-pair authentication too. I read this in the Snowflake documentation: "The Python connector supports key pair authentication and key rotation."

https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-connect#using-key-pa...

0 Kudos
AliciaMcMurchie1
Regular Contributor

Just confirming this is true, it's possible. I was able to load a table with Snowflake data using keypair auth.