In this article

Overview

You can use this account type to connect to a Snowflake Instance instance hosted on Google Cloud Platforms. 

Prerequisites

A valid Snowflake database account.

Limitations and Known Issues

None.

Account Settings

Image Removed

...

...

Info

Asterisk ( * ): Indicates a mandatory field. Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration. Expression icon ( ): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic. Add icon ( ): Indicates that you can add fields in the field set. Remove icon ( ): Indicates that you can remove fields from the field set.

Field Name		Field Type		Field Dependency	Description
Label* Default Value: None Example: Snowflake Google Storage Database Account		String		N/A	Specify a unique label for the account.

JDBC JARs

Account properties*
JDBC JARs	Use this field set to

upload the JDBC driver and other

add a list of JDBC JAR files

that you want to use into SLDB.Click Image Removed to

to be loaded. The Snowflake account has been tested with the JDBC driver version 3.14.0. Click + to add a new row

. Add each JDBC

for each JDBC JAR file. Add each JAR file in a separate row.

See 

See Downloading the JDBC Driver

 for

for more information about JDBC drivers and downloading the appropriate driver for your account.

 JDBC Driver*

This field set contains the JDBC Driver field.

JDBC Driver* Default value: None Example: snowflake-jdbc-3.14.0.jar

String

N/A

Specify the driver to use for your application. 

Specify the fully-qualified name of the JDBC driver class to be used for connecting to the server. The Snowflake Snap Pack is bundled with the default Snowflake JDBC JAR v3.14 file. Therefore, even if you do not provide a JDBC Driver, the account does not fail.

Hostname* Default value:

 N/AHostname*

None Example:

 snowflake-jdbc-3.12.3.jar

demo.snowflake.net

String

N/A

Specify the hostname

 of

of the Snowflake server to which you want to connect

. 

the new account.

Port Number* Default value:

 N/A

443  Example:

 demo.snowflake.netPort Number*

332

Integer

N/A

Specify

the

the port number associated with the Snowflake

Google Storage Database

database server that you

want to

must use for this account.

Authentication Type* Default

value

Value:

 443Authentication Type

Password Example:

 443

Key Pair		Dropdown list		N/A	Choose an authentication type to connect to the database. The available options are: Password: Authenticates with the Username and Password credentials. Key Pair: Authenticates using the Private Key and Encrypted Private Key Passphrase.
Username* Default

 

Value:

 Password

N/A Example:

Key PairUsername*

SW_User

String

N/A

Specify

the username that you want to use

the username to connect to the

Snowflake Google Storage database

Snowflake database server.

Password* Default

value

Value:

 NPassword*

N/A Example:

admin

ll@98#*00w

String

Appears when you select Password for Authentication Type.

Specify the password

for

associated with the username specified above. This will be used as the default password while retrieving connections.

Encrypted Private Key* Default

value

Value:

 N

N/A Example:

 P@$$w0rd!Private Key

-----BEGIN PRIVATE KEY-----MIIE6TAbBgkqhkiG9w0BBQMwDgQILYPyennlX2bd8yX8 xOxGSGfvB+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

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

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:

-----BEGIN PRIVATE KEY-----MIIE6TAbBgkqhkiG9w0BBQMwDgQILYPyennlX2bd8yX8xOxGSGfvB+99+PmSlex0FmY9ov1J8H1H9Y3lJXXb

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

Encrypted Private Key Passphrase

Nki62lmWfFO75Xg04W+Fnlt9ejiMn4zPbkf/me Aq1R3X7CM/ORLuLms4vU70NjzNYo09SO UXhQmoqpEkQBvrrYuzdaQt5hvwh7vZQh WZ5L8+lTRoA neFtmd6LZ94AssA==

String

Appears when you select

 

Key Pair

 

for

 

Authentication Type.

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 encrypted private key only.

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

Database name*

passphrase for authentication.
Database name* Default value: None Example: SWDB		String		N/A	Specify

the 

the name of the

Snowflake

database to which you want to connect.

Warehouse name* Default value:

 N/A

None Example:

 SWDBWarehouse name*

Snowflake_cdw

String

N/A

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

Default value: N/A
Example: Snowflake_cdwDefault value

JDBC Driver Class

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.

Default Value: net.snowflake.client.jdbc.SnowflakeDriver Example: net.snowflake.client.jdbc.SnowflakeDriver		String		N/A	Specify the JDBC driver class to use.
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

N/A Example: sw_gcs_bucket_1

Google Cloud Storage (GCS) Folder

_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

N/A Example:

sw

GCS_

gcs_bucket_1_FilesStorage Integration

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.

Default value: N/A
Example: GCS_Storage_Integration

Advanced properties

URL

properties

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. This field consists of the following fields:

• URL Property name
• URL Property value

URL Property name

additional URL properties to use, if any.
URL property name Default value: None Example: : MAX_CONCURR ENCY_LEVEL		String		N/A	Specify the name of

the parameter for

the URL property.

URL property value Default

value: N/AURL Property value

value: None Example:

 MAX_CONCURRENCY_LEVEL

4

String

N/A

Specify the URL property value

for

associated with the URL property

parameter

name.

Batch size* Default value:

N/A

50 Example:

4

9

Batch size*

Integer

N/A

Specify

the number

the number of Snowflake

queries that

queries that you want to execute at a time

.

Fetch size* Default value:

 50

100 Example:

9

90

Fetch size*

Integer

N/A

Specify

the

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

Min pool size* Default value:

100

3 Example:

90Min pool size*

4

Integer

N/A

Specify

the

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

Max pool size* Default value:

3

15 Example:

4Max pool size*

10

Integer

N/A

Specify

the

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

Max life time* Default

Value

value:

15

60 Example:

10Max life time*

90

Integer

N/A

Specify

the

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

  Default Value: 60
Example: 90

Minimum value: 0 Maximum value: No limit
Idle Timeout* Default value: 5 Example: 6			Integer	N/A	Specify

the

the maximum amount of time

in seconds that

a connection is allowed to sit idle in the pool. A value of 0 indicates that idle connections are never removed from the pool. Minimum value: 0 Maximum value: No limit

Checkout timeout* Default

Value

value:

5Checkout timeout*

10000 Example:

 6

9000

Integer

N/A

Specify

the maximum time in milliseconds

the number of 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

Generating a Valid Key Pair

Snap Pack History

...

Related Links

• Configuring Snowflake Accounts

• Configuring an Integration for Google Cloud Storage

  SnapLogic Product Glossary

• Getting started with SnapLogic