This guide will walk you through setting up a data connection to Snowflake Data Warehouse
You should already have a Snowflake account and server URL
1. Creating the Connection String/Database URL
In this section we'll be building the connection string to be used later when setting up the data source connection.
Locate the Snowflake driver cdata.jdbc.snowflake.jar here:
Double click the driver and it should open the drivers connection properties. If clicking doesn't work for you, you can do this via command line.
Navigate to the drivers folder and run command "java -jar cdata.jdbc.snowflake.jar"
Under Authentication fill in your Snowflake URL, Database name. Schema, and Warehouse.
Select the PASSWORD Auth Scheme and enter your username and password.
2. Creating the data source connection.
- Log into the admin console or datahub and click on Data Sources -> New
- Give the data source a name "Snowflake" for example.
- Select Generic JDBC as the Data Source Type
- Copy the Database URL you Created in Step 1 to the Database URL field.
- The password is obscured in the URL "******" you'll need to replace the asterisk with your actual password
- Copy the driver class below into the JDBC Driver Class field.
JDBC Driver Class : cdata.jdbc.snowflake.SnowflakeDriver
Now you can begin using Snowflake as a data source.
If you have any questions or would like to use an alternate form of authentication, that information can be found in the user guide.