Connecting to Snowflake using Azure AD SSO (Single Sign-On) from the Alteryx ODBC driver can be a bit tricky, but with the right steps, it is definitely doable. In this blog post, we will walk through the process of setting up SSO with Snowflake and Alteryx, so that you can easily connect to your Snowflake data without having to manually enter your login credentials each time.
Step 1: Set up Azure AD SSO for Snowflake
The first step in setting up SSO for Snowflake is to configure your Azure AD tenant. This can be done by following the instructions provided by Snowflake in their documentation.
- If you are connecting from your Snowflake account with a URL, format should be like: <account>.<region>.snowflakecomputing.com
For more documentation: Azure Active Directory integration with Snowflake
- If you are connecting from your Snowflake account with a URL, format should be like: <organization>-<account>.snowflakecomputing.com and/or <account>.<region>.privatelink.snowflakecomputing.com
For more documentation: HOW TO: Setup SSO with Azure AD and the Snowflake new URL format.
Once you have set up your Azure AD tenant, you will need to create an Azure AD application for Snowflake.
Step 2: Set up Alteryx to use Azure AD SSO
Once you have set up Azure AD SSO for Snowflake, the next step is to set up Alteryx to use SSO when connecting to Snowflake. To do this, you will need to install the Alteryx ODBC driver and configure it to use the Azure AD application that you created in step 1.
To download ODBC, in your Snowflake account open the Web UI, go to the Help link and navigate to Download. Pick ODBC drivers from the menu and select one that fits your system.
Step 3: Install the ODBC driver you have downloaded
Step 4: Create the ODBC DSN
Open ODBC Data Source Manager (32-bit or 64-bit – depending on your situation) and create a System DSN for Snowflake.
Fill in the DNS details relevant to your Snowflake account and click OK.
Step 5: Test your connection
Once you have set up Alteryx to use Azure AD SSO, you can test your connection by opening Alteryx and creating a new workflow. In the workflow, add a new input tool and select the Snowflake connection that you configured in step 4. If everything is set up correctly, you should be able to connect to Snowflake without having to enter your login credentials manually.
And then, authenticate to Azure AD in the browser window that pops up.
Connecting to Snowflake using Azure AD SSO from the Alteryx ODBC driver is a bit tricky, but with the right steps, it is definitely doable. By following the steps outlined in this blog post, you should be able to set up SSO with Snowflake and Alteryx in no time and easily connect to your Snowflake data without having to manually enter your login credentials each time.
If you are unsure how to compare your data in Snowflake or would like to speak with an expert to learn more, Anyon Consulting – BI group can help! Our database experts and consultants that can answer any questions on customize dashboards, help with your database implementation, optimize your database platform, and much more. Contact us today to learn more about our Custom Database Development.