Alteryx Scheduler + Snowflake Oauth / Key Pair

[melissa_m]

Hi All,

We use Snowflake as our primary data source for most of our workflows.  These workflows run on schedule using Alteryx Desktop Scheduler.  With Snowflake removing username / password authentication, it seems like the only way to connect Alteryx to Snowflake will be thru Oauth or Key/Pair which has to be setup in DCM.  However, DCM does not seem to work with Alteryx Scheduler.  

Anyone else encountering this scenario and how did you go about making this work?  thanks for any input!

Regards,

Melissa

[apathetichell · Accepted solution]

three choices:

1) don't use desktop scheduler.

2) totally re-architect how you connect to Snowflake and use Alteryx.

3) connect via odbc using JWT. For In-DB/named connections -  Alteryx dosn't care how your Snowflake ODBC auths it just cares IF your Snowflake ODBC auths.

Personally - I'd go with choice 3).

[melissa_m]

Option 3 Worked!  For those in similar scenario , here's the step by step guide on how to implement the JWT in your ODBC connections shared by @apathetichell .   https://community.snowflake.com/s/article/How-to-set-up-ODBC-Driver-with-key-pair-authentication-to-...

Thank again!