Alteryx Scheduler + Snowflake Oauth / Key Pair

Question

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 Answer

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).