Alteryx and Snowflake

[imaran_669]

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! 

[apathetichell]

Can you walk me through how you'd want this to work?

I'm not sure about how it would be possible on any system to use SSO/Browser based authentication with a scheduled process. Snowflake has independently scheduled processes (tasks& the like) but those would be independent of Alteryx. If you want to schedule something between the two,  I'd expect you need a service account with  a username/password.

[sharonschmidt]

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

[apathetichell]

@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]

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