Alteryx supports connecting to data from different sources, including databases stored in Snowflake. I will cover the entire connection process step by step in this blog. I hope it will be helpful for those trying to set up this connection but encountering difficulties.
Step 1: Download and Install the ODBC Driver for Snowflake
To connect to Snowflake databases, you will need the ODBC Driver for Snowflake. This driver provides a uniform method for connecting to different types of databases using the same interface. Different versions of the ODBC driver for various operating systems can be found at here.
Step 2: Set Up a Connection Using the Input Data Tool in Alteryx.
Step 3: Select “Input Data” and set up a connection, then go to “Data Sources” and find “Snowflake.”
Step 4: Click the gear icon to access the configuration page for ODBC DSN.
Step 5: A pop-up window will appear. Select “Add” on the right-hand side.
Step 6: Choose the “SnowflakeDSIIDriver,” which is the ODBC driver you just installed, and click “Finish.”
Step 7: Several items need to be addressed in the configuration dialog box.
- Data Source: You can name it as you wish
- User: The username you used to sign in to Snowflake
- Password: The password you used to sign in to Snowflake
- Server: Click your name located in the left bottom corner of the home page of Snowflake, go to the Account section, hover over the section where address located until the far right information box appears. Copy your account URL from there and it should be ended with snowflakecomputing.com. Note: exclude https:// from your URL, use the rest as your server input.
