Connecting to Snowflake with keypair authentication

Question

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.

RClavero · Accepted Answer

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-pair-authentication-and-key-pair-rotation