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 Enter the user name to connect to Snowflake account.
Password Enter the password to connect to Snowflake account.
Account Enter 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 Optional. Enter the Snowflake warehouse name.
Role Specify the Snowflake role assigned to user.
Additional JDBC URL Parameters Enter one or more JDBC connection 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 Enter the database and schema name 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 March 07, 2019


Explore Informatica Network