How to Connect to Snowflake
When you have completed the prerequisite requirements, use the following section to proceed with the Data IQ® Warehouse Connector setup.
Client Versions and Support Policy
Operating Systems supported from Snowflake are found on their requirements page, minimum and recommended client versions, and Snowflake support policies.
Connecting Directly Using Drivers and Connectors
Detailed instructions for installing, configuring, and using the Snowflake-provided drivers and connectors for JDBC, ODBC, Python, Spark, Go, and other clients are available on their drivers page.
JDBC Driver
Sample JDBC Connection String:
jdbc:snowflake://<account_name>.snowflakecomputing.com/
?user=<username>&password=<password>
&warehouse=<warehouse_name>&db=<database_name>
&schema=<schema_name>
# For example:
jdbc:snowflake://xy12345.us-east-1.snowflakecomputing.com
/?user=<username>&password<password>
&warehouse=BI_DWC_WH&db=BI_DWC_DB&schema=DWC
Reference – Connect to Snowflake via JDBC
ODBC Driver
Installation and Configuration
Sample ODBC Connection String:
Driver={SnowflakeDSIIDriver};Server<account_name>
.snowflakecomputing.com;Database=<database_name>;
uid=<username>;pwd=<password>;Schema=<schema_name>;
Warehouse=<warehouse_name>
# For example:
Driver={SnowflakeDSIIDriver};Server=xy12345.us-east1.snowflakecomputing.com;
Database=BI_DWC_DB;uid=<username>;
pwd=<password>;Schema=DWC;Warehouse=BI_DWC_WH
.Net Driver
Sample .Net Connection String:
account=<account_name>;user=<username>;
password=<password>;db=<database_name>;
schema=<schema_name>;warehouse=<warehouse_name>
# For example:
account=xy12345.us-east-1;user=<xxxxxx>;
password=<xxxxxx>;db=BI_DWC_DB;
schema=DWC;warehouse=BI_DWC_WH
Other Drivers and Connectors
Snowflake Web UI
Popular IDEs to Connect to Snowflake
Data Integration/ETL Tools
Talend
Matillion
Amazon Glue
Fivetran
Connect to Snowflake Using TablePlus
Install TablePlus from: TablePlus | Modern, Native Tool for Database Management.
Open TablePlus and follow the steps to Create a new connection.
Select Snowflake, and then click Create.
Configure the Snowflake connection as shown in the following images:
Click Test to ensure the connection is successful.
View the data by doing one of the following:
Click the views on the left pane.
Open the SQL Editor and run a query (remember to user the 'BYOX' schema).
