Alteryx and Snowflake

Question

Hi! My company is starting to move its data from local SQL servers to Snowflake. Since more and more information is now on Snowflake I’m struggling with the connection between both tools. The log in to Snowflake is with AzureAD, this is not supported with Alteryx? The only way I found is with externalbrowser but it is useless on scheduled processes.

Any good experience connecting these two tools as easy as is to bring data from a SQL server?

Thanks for sharing!

sharonschmidt · Answer

We schedule everything using ODBC.  We haven't setup SnowFlake SSO yet.  I'm just researching what needs to be done to accomplish that.  I did find this article and wondering if this is the direction I need to go for service users.  
https://docs.snowflake.com/en/user-guide/key-pair-auth

apathetichell · Answer

@sharonschmidt ---> How are you connecting normally? you cannot connect via scheduler if you are using SSO. SSO says -> let me open a window and wait for a user response to connect. Scheduler says -> let me run as is. If you need a consultant and need this rearchitected -> reach out and I can design it for you. but you cannot go scheduler to externalbrowser.

sharonschmidt · Answer

Hi, were you able to find a solution to this authentication issue with desktop scheduler?