To define a new connection from the Connection parameter in a Snowflake Non-Spatial format:
- Select Add Database Connection. See database-specific parameters below, as well as the section Adding a Database Connection in a Workspace in Using Database Connections The new connection can be made visible only to the current user, or can be shared among multiple users.
Note: To select an existing, previously defined connection, see the section Reusing a Database Connection in Using Database Connections
Database Connection
Snowflake
Name
Enter a name for the new connection.
Connection Parameters
Account Name
The full name of your Snowflake account.
For example, if you access your Snowflake System in a web browser using a URL like this:
https://mycompanyinc.snowflakecomputing.com/
then your full account name is mycompanyinc.
Warehouse
The virtual warehouse to use once connected. The specified warehouse should be an existing warehouse. This parameter is case-sensitive.
Database
Specifies the default database to use once connected. The specified database should be an existing database. This parameter is case-sensitive.
Schema
Specifies the default schema to use once connected. The specified schema should be an existing schema. This parameter is case-sensitive.
Username and Password
The username and password to connect to the specified account, warehouse, database, and schema.
Advanced – Specify JDBC Connection
When enabled, this parameter will allow JDBC connection string and properties to be specified directly. The specified connection string and properties will be used to connect to the database.
|
Option |
Description |
|---|---|
|
Connection String |
The connection string for the database to which you are connecting. |
|
Mask Connection String |
When this option is checked (set to Yes), connection strings for database connections are masked in translation and error logs. Connection strings may contain sensitive information (for example, passwords). A masked connection string appears as: jdbc:<subprotocol>:************ When this option is unchecked (set to No), connection strings are logged in plain text. |
|
Connection Property and Value |
Name/value pairs entered here will be set in the order specified, then passed on in a Properties object when connecting to the database. They do not require manual encoding of characters that are not safe in Connection Strings. |