Label*

N/A

Use this field set to

upload the JDBC driver and other JAR files that you want to use into SLDB.

Click Image Modified to add a new row. Add each JDBC JAR file in a separate row. See Downloading the JDBC Driver for more information about JDBC drivers and downloading the appropriate driver for your account. 

This field set contains the JDBC Driver field.

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 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: Passwordvalue: N/A
Example: Key Pairadmin

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.

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

Encrypted Private Key*

DefaultValue: N/A
Example: -----BEGIN PRIVATE KEY-----MIIE6TAbBgkqhkiG9w0BBQMwDgQILYPyennlX2bd8yX8xOxGSGfvB+99+PmSlex0FmY9ov1J8H1H9Y3lJXXb

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

Encrypted Private Key Passphrase*

Default Value: N/A
Example:

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

 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 the fully-qualified/domain name of the JDBC driver class to be used for connecting to the Snowflake Google Database Storage server.Default value: net.snowflake.client.jdbc.SnowflakeDriver
Example: net.snowflake.client.jdbc.SnowflakeDriverSnowflake 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.Default value: N

Use this field set to define

the account parameter's name and its corresponding value. Click + to add the parameters and the corresponding values. Add each URL property-value pair in a separate row. This field consists of the following fields:

• URL Property name

• URL Property value

URL Property name

Default value: N/A
Example: MAX_CONCURRENCY_LEVEL

Specify the name of the parameter for the URL property.

URL Property value

Default value: N/A
Example:  MAX_CONCURRENCY_LEVEL

4

Specify the value for the URL property parameter.

Batch size*

Default value:N/A 50
Example:4

 9

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

Fetch size*

Default value:

100
Example:

90

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

Min pool size*

Default value:

3
Example:

4

Specify the 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 the maximum number of connections that you want the pool to maintain at a time.

Max life time*

Default Value:

60
Example

: 90

Minimum value: 0

Maximum value: No limit

Specify the the maximum lifetime of a connection in the pool, in seconds.  Default Value: 60
Example: 90.  

Idle Timeout*

Minimum value: 0
Maximum value: No limit

Default Value: 5
Example: 6

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

Checkout timeout*

Minimum value: 0
Maximum value: No limit

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

Default Value: 10000
Example: 9000