Page Comparison

In this article

...

Field Name

Field Type

Field Dependency

Description

Label*

Default value: None
Example: Snowflake GCS Account

String

N/A

Specify a unique label for the account.

JDBC JARs

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

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

This field set contains the JDBC Driver field.

JDBC Driver*

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

String

N/A

Specify the driver to use for your application.

Hostname*

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

String

N/A

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

Port Number*

Default value: 443
Example: 443

Integer

N/A

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

Authentication Type

Default Value: Password
Example: Key Pair

String

N/A

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

String

N/A

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!

String

Appears when you select Password for Authentication Type.

Specify the password for the username.

Encrypted Private Key*

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

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

String

Appears when you select Key Pair for Authentication Type.

Specify the key that you have generated for authentication. The key must include the generated header and footer.

Info
The private key is read, decrypted if necessary, and included with properties to connect to Snowflake, where it is validated against with its paired public key to authenticate the connection.

Learn more about configuring and generating a valid key pair.

Encrypted Private Key Passphrase*

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

String

Appears when you select Key Pair for Authentication Type.

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

Database name*

Default value: N/A
Example: SWDB

String

N/A

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

Warehouse name*

Default value: N/A
Example: Snowflake_cdw

String

N/A

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

String

N/A

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

String/Expression

N/A

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

String/Expression

N/A

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

String/Expression

N/A

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

URL properties

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.

URL Property name

Default value: N/A
Example: MAX_CONCURRENCY_LEVEL

String

N/A

Specify the name of the parameter for the URL property.

URL Property value

Default value: N/A
Example: 4

Integer

N/A

Specify the value for the URL property parameter.

Batch size*

Default value: 50
Example: 9

Integer

N/A

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

Fetch size*

Default value: 100
Example: 90

Integer

N/A

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

Min pool size*

Default value: 3
Example: 4

Integer

N/A

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

Integer

N/A

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

Max life time*

Default Value: 60
Example: 90

Integer

N/A

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

Integer

N/A

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

Integer

N/A

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

Multiexcerpt include macro

name	Generating a valid key pair
templateData	[]
page	Snowflake S3 Dynamic Account
addpanel	false

...

Versions Compared

Old Version 20

New Version 21

Key