Snowflake Run SQL Action
The Snowflake Run SQL action plugin is available in the Hub.
Plugin version: 1.1.0
Runs a specified SQL query in Snowflake.
Configuration
Basic
Property | Macro Enabled? | Description |
---|---|---|
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 table to query. |
Schema | Yes | Required. Schema that contains the table to query. |
Warehouse | Yes | Optional. Warehouse that provides the compute resources. |
Role | Yes | Optional. Role to use (e.g. |
Query | Yes | Required. SQL query to run. |
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 |
---|---|---|
Connection Argument | Yes | Optional. List of arbitrary string tag/value pairs as connection arguments. See JDBC Driver Connection String. |
Created in 2020 by Google Inc.