Label*

Default value: None
Example: Snowflake GCS Account

JDBC Driver*

Default value: N/A
Example: snowflake-jdbc-3.12.3.jar

Specify the driver to use for your application. 

Hostname*

Default value: N/A
Example: demo.snowflake.net

Specify the hostname of the Snowflake server to which you want to connect. 

Port Number*

Default value: 443
Example: 443

Specify the port number associated with the Snowflake Google Storage Database server that you want to use for this account.

Authentication Type

Default Value: Password
Example: Key Pair

Choose an authentication type to connect to the database. The available options are:

• Password: Authenticates with Username and Password credentials.

• Key Pair: Authenticates using Private Key and Encrypted Private Key Passphrase.

Username*

Default value: N/A
Example: admin

Specify the username that you want to use to connect to the Snowflake Google Storage database server.

Password*

Default value: N/A
Example: P@$$w0rd!

Specify the password for the username.

Encrypted Private Key*

DefaultValue: N/A
Example: -----BEGIN PRIVATE KEY-----

MIIE6TAbBgkqhkiG9w0BBQMwDgQILYPyennlX2bd8yX8x
OxGSGfvB+99+PmSlex0FmY9ov1J8H1H9Y3lJXXb

-----END PRIVATE KEY-----

Encrypted Private Key Passphrase*

Default Value: N/A
Example: Nki62lmWfFO75Xg04W+Fnlt9ejiMn4zPbkf/me Aq1R3X7CM/ORLuLms4vU70NjzNYo09SO
UXhQmoqpEkQBvrrYuzdaQt5hvwh7vZQh WZ5L8+lTRoAneFtmd6LZ94AssA==

Specify the passphrase for the encrypted private key. Leave this field blank if the specified private key is not encrypted. However, we recommend that you use an encrypted private key only.

Database name*

Default value: N/A
Example: SWDB

Specify the name of the Snowflake database to which you want to connect.

Warehouse name*

Default value: N/A
Example: Snowflake_cdw

Specify the name of the warehouse to which you want to connect.

JDBC Driver Class

Default value: net.snowflake.client.jdbc.SnowflakeDriver
Example: net.snowflake.client.jdbc.SnowflakeDriver

Specify the fully-qualified/domain name of the JDBC driver class to be used for connecting to the Snowflake Google Database Storage server.

Google Cloud Storage (GCS) Bucket

Default value: N/A
Example: sw_gcs_bucket_1

Specify the name of the GCS bucket from which to load the staged data to your Snowflake database.

Google Cloud Storage (GCS) Folder

Default value: N/A
Example: sw_gcs_bucket_1_Files

Specify the relative path to the folder in the GCS bucket where the source files are located. This is used as a root folder for staging data.

Storage Integration

Default value: N/A
Example: GCS_Storage_Integration

Specify the predefined storage integration that is used to authenticate the Google
Cloud Storage bucket hosting as the external stage.

Specify the name of the parameter for the URL property.

Specify the value for the URL property parameter.

Batch size*

Default value: 50
Example: 9

Specify the number of Snowflake queries that you want to execute at a time.

Fetch size*

Default value: 100
Example: 90

Specify the number of rows a query must fetch for each execution.

Min pool size*

Default value: 3
Example: 4

Specify the minimum number of idle connections that you want the pool to maintain at a time. 

Max pool size*

Default Value: 15
Example: 10

Specify the maximum number of connections that you want the pool to maintain at a time.

Max life time*

Default Value: 60
Example: 90

Specify the maximum lifetime of a connection in the pool, in seconds.  

Minimum value: 0

Maximum value: No limit

Idle Timeout*

Default Value: 5
Example: 6

Specify the maximum amount of time in seconds that a connection is allowed to sit idle in the pool.

Minimum value: 0
Maximum value: No limit

Checkout timeout*

Default Value: 10000
Example: 9000

Specify the maximum time in milliseconds you want the system to wait for a connection to become available when the pool is exhausted.

Minimum value: 0
Maximum value: No limit