Snowflake Sink

The Snowflake sink plugin is available in the Hub.

Plugin version: 1.1.0

This sink writes to a Snowflake table.

Configuration

Basic

Property

Macro Enabled?

Description

Property

Macro Enabled?

Description

Reference Name

No

Required. Name used to uniquely identify this sink for lineage, annotating metadata, etc.

Account Name

Yes

Required. Snowflake account name and region and possibly a cloud specifier. Part of the URL you use to log in to Snowflake, minus the snowflakecomputing.com. For example, myaccount.us-central1.gcp.

Database

Yes

Required. Database that contains the target table.

Schema

Yes

Required. Schema that contains the target table.

Warehouse

Yes

Optional. Warehouse to use to write to the sink (i.e. the compute resource).

Role

Yes

Optional. Role to use (e.g. ACCOUNTADMIN).

Table Name

Yes

Required. Name of the database table to write to.

Credentials

Property

Macro Enabled?

Description

Property

Macro Enabled?

Description

Username

Yes

Optional. Username to use to connect to your Snowflake account.

Password

Yes

Optional. Password to use to connect to your Snowflake account. Not necessary for key pair or OAuth2 authentication.

Key Pair Authentication

Property

Macro Enabled?

Description

Property

Macro Enabled?

Description

Key Pair Authentication Enabled

No

Optional. If true, the plugin will perform key pair authentication.

Default is False.

Private Key

Yes

Optional. Private key contents.

Key File Passphrase

Yes

Optional. Passphrase for the private key file.

OAuth2

To use OAuth2, you must create a snowflake security integration for it. For more information, see Introduction to OAuth in Snowflake.

Property

Macro Enabled?

Description

Property

Macro Enabled?

Description

OAuth2 Enabled

No

Optional. If true, the plugin will perform OAuth2 authentication.

Default is False.

Client ID

Yes

Optional. Client ID obtained via system function SYSTEM$SHOW_OAUTH_CLIENT_SECRETS.

Client Secret

Yes

Optional. Client secret obtained via system function SYSTEM$SHOW_OAUTH_CLIENT_SECRETS.

Refresh Token

Yes

Optional. Token used to receive accessToken, which is end product of OAuth2. Must be generated by user.

Advanced

Property

Macro Enabled?

Description

Property

Macro Enabled?

Description

Maximum File Size

Yes

Required. Maximum size in bytes of temporary file in stage used by plugin as temporary location, before populating the data to a table. If 0 files are not limited by size.

Default is 0.

Copy Options

Yes

Optional. List of copy options. Find them here.

Connection Arguments

Yes

Optional. List of arbitrary string tag/value pairs as connection arguments. See JDBC Driver Connection String.

Created in 2020 by Google Inc.