Snowflake Data Cloud Connector

Back Next

Standard authentication

Standard authentication is the default type which requires at a minimum your Snowflake account name and password.

The following table describes the

basic

connection properties for standard authentication:

Property	Description
Username	The user name to connect to the Snowflake account.
Password	The password to connect to the Snowflake account.
Account	The name of the Snowflake account. For example, if the Snowflake URL is https://<123abc>.us-east-2.aws.snowflakecomputing.com/console/login#/, your account name is the first segment in the URL before snowflakecomputing.com. Here, 123abc.us-east-2.aws is your account name. If you use the Snowsight URL, for example, https://app.snowflake.com/us-east-2.aws/<123abc>/dashboard, your account name is 123abc.us-east-2.aws. Ensure that the account name doesn't contain underscores. If the account name contains underscores, you need to use the alias name. To use an alias name, contact Snowflake Customer Support.
Warehouse	The Snowflake warehouse name.

The following table describes the advanced connection properties for standard authentication:

Property	Description
Role	The Snowflake role assigned to the user.
Additional JDBC URL Parameters	The additional JDBC connection parameters. You can specify multiple JDBC connection parameters, separated by ampersand (&), in the following format: <param1>=<value>&<param2>=<value>&<param3>=<value>.... For example, you can pass the following database and schema values when you connect to Snowflake: db=mydb&schema=public When you add parameters, ensure that there is no space before and after the equal sign (=). For the list of additional JDBC parameters that you can configure, see JDBC URL parameters.

Property

Description

Role

The Snowflake role assigned to the user.

Additional JDBC URL Parameters

The additional JDBC connection parameters.

You can specify multiple JDBC connection parameters, separated by ampersand (&), in the following format:

<param1>=<value>&<param2>=<value>&<param3>=<value>....

For example, you can pass the following database and schema values when you connect to Snowflake:

db=mydb&schema=public

When you add parameters, ensure that there is no space before and after the equal sign (=).

For the list of additional JDBC parameters that you can configure, see JDBC URL parameters.