Overview

You must create Snowflake accounts to connect to data sources that you want to use in your pipelines. You can configure your Snowflake accounts in SnapLogic using either the Designer or the Manager.

The Snowflake Snap Pack is now bundled with the default Snowflake JDBC JAR v3.14.
As of November 1, 2023, Snowflake instances hosted on Google Cloud must use Snowflake JDBC JARs v3.13.25 or higher. If you are using the default drivers bundled with Snowflake or ELT Snaps, your pipelines are not affected. If your Snowflake instances hosted on Google Cloud use older JARs, you must update the client drivers. Learn more.

Snap-Account Compatibility

Snap	Snowflake Azure Database Account	Snowflake Azure OAuth2 Account	Snowflake Google Storage Database Account	Snowflake Google Storage OAuth2 Account	Snowflake S3 Database Account	Snowflake S3 Dynamic Account	Snowflake S3 OAuth2 Account

Snap	Snowflake Azure Database Account	Snowflake Azure OAuth2 Account	Snowflake Google Storage Database Account	Snowflake Google Storage OAuth2 Account	Snowflake S3 Database Account	Snowflake S3 Dynamic Account	Snowflake S3 OAuth2 Account
Snowflake - Bulk Load	✔	✔	✔	✔	✔	✔	✔
Snowflake - Bulk Upsert	✔	✔	✔	✔	✔	✔	✔
Snowflake - Delete	✔	✔	✔	✔	✔	✔	✔
Snowflake - Execute	✔	✔	✔	✔	✔	✔	✔
Snowflake - Insert	✔	✔	✔	✔	✔	✔	✔
Snowflake - Lookup	✔	✔	✔	✔	✔	✔	✔
Snowflake - Select	✔	✔	✔	✔	✔	✔	✔
Snowflake - Snowpipe Streaming	✔	✔	✔	✔	✔	✔	✔
Snowflake - Table List	✔	✔	✔	✔	✔	✔	✔
Snowflake - Unload	✔	✔	✔	✔	✔	✔	✔
Snowflake - Update	✔	✔	✔	✔	✔	✔	✔
Snowflake SCD2	✔	✔	✔	✔	✔	✔	✔
Snowflake Vector Search	✔	✔	✔	✔	✔	✔	✔

Account Encryption

Standard Encryption

If you are using Standard Encryption, the High sensitivity settings under Enhanced Encryption are followed.

Enhanced Encryption

If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected per each account.

Account

High: Password
Medium + High: Username, password
Low + Medium + High: Username, password

Using Pipeline Parameters in Account Configuration

You can use Pipeline parameters when configuring dynamic Snowflake accounts. See Pipeline Parameters in Pipeline Properties for more information.

Example

Define the following two Pipeline parameters in the Pipeline with which you want to associate the new account:

User_name
Pass_word

You will use these values in the Dynamic account.

In the Snowflake pipeline, create a Snowflake Dynamic Account

Set the expression toggle on for both Username and Password
Set Username to _user_name and Password to _password
Click Apply and fill the Snap Settings for the desired function.

You cannot Validate an account connection when creating a Snowflake Dynamic Account, because the account properties of a dynamic account are provided dynamically as Pipeline parameters.

Apply the changes. Your dynamic account is now configured, and your username and password details should change as you update them in your Pipeline parameters.

Configuring Snowflake Accounts

Overview

Snap-Account Compatibility

Account Encryption

Using Pipeline Parameters in Account Configuration

Snap Pack History

Related Content