This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 12-11-201703:02 PM - edited on 03-11-201910:15 AM by SydneyF
As many of you know, Snowflake is a admin free cloud data warehouse used for data analytics! In this article, I am going to show you how to load data into snowflake using Alteryx Database Connections! The first step is to have your snowflake instance up and running with the warehouse and database created. The next step is to create the database table you want to load into Snowflake. You can either do this manually:
Or use the power of Alteryx to load the data!
If you are using Alteryx to load the data, read on! The first step is to download the Snowflake ODBC driver. After installing the driver, go to the dropdown > Other Databases > ODBC within the Output Tool. This will open the ODBC Connection:
Click on the ODBC admin > System DSN > Add… > Scroll down to the Snowflake DSIIDriver and click Finish.
Populate the Snowflake Configuration Dialog correct credentials and click OK!
Note: The Role specifies the default role to the user for sessions initiated by the driver. The specified role should be a role that has been assigned to the user for the driver. If the role does not match any of the roles assigned to the user, sessions initiated by the driver will have no role initially. A role can always be specified from within the session.
Tracing is how detailed the logs in the driver should be. I like to use 6 for detailed tracing.
0 = Disable tracing
1 = Fatal only error tracing
2 = Error tracing
3 = Warning tracing
4 = Info tracing
5 = Debug tracing
6 = Detailed tracing
Snowflake Test now should be under System DSN. Go to your ODBC Connection screen, pick the correct Data Source Name (DSN) and Enter User Name and Password, enter the table name you want to append to or create and you should be good to go.
You can now bring in data from various data sources, make various changes using the power of Alteryx and output to the snowflake database!
If you ever encounter the error “expecting TIMESTAMP_NTZ(9) but got TIMESTAMP_LTZ(9)” error when trying to write to a Snowflake data warehouse, the solution is to insert ALTER SESSION SET CLIENT_TIMESTAMP_TYPE_MAPPING = TIMESTAMP_NTZ; to the Pre-Create SQL Statement.