Snowflake Connector Guide

Snowflake Connector Guide

Snowflake connection properties

Snowflake connection properties

When you set up a Snowflake connection, you must configure the connection properties.
The following table describes the Snowflake connection properties:
Connection property Description
Runtime Environment The name of the runtime environment where you want to run the tasks.
Username The user name to connect to Snowflake account.
Password The password to connect to Snowflake account.
Account The name of the Snowflake account. In the Snowflake URL, your account name is the first segment in the domain. For example, 123abc is your account name in https://123abc.snowflakecomputing.com.
Warehouse The Snowflake warehouse name. You must specify the warehouse name.
Role The Snowflake role assigned to user.
Additional JDBC URL Parameters The additional connection parameters. You can specify one or more parameters in the following format:
<param1>=<value>&<param2>=<value>&<param3>=<value>....
For example:
user=jon&warehouse=mywh&db=mydb&schema=public
To override the database and schema name used to create temporary tables in Snowflake, enter the database and schema name in the following format:
ProcessConnDB=<DB name>&ProcessConnSchema=<schema_name>
To access Snowflake through Okta SSO authentication, enter the web-based IdP implementing SAML 2.0 protocol in the following format:
authenticator=https://<Your_Okta_Account_Name>.okta.com 
Microsoft ADFS is not supported.
Database/Schema The Snowflake database and schema name. Specify the parameters in the following format:
<database name>/<schema name>
You must specify both database and schema name. If you specify only database name, source objects do not appear in the Select Source Object window. If you specify only schema name, you get an Invalid Schema exception when you read data.


Updated September 05, 2019


Explore Informatica Network