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 |
---|---|---|
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 |
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. |
Table Name | Yes | Required. Name of the database table to write to. |
Credentials
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 |
---|---|---|
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 |
---|---|---|
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 |
---|---|---|
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.