Skip to content

SnowflakeRunSQL-action.md

Latest commit

 

History

History
59 lines (33 loc) · 2.05 KB

SnowflakeRunSQL-action.md

File metadata and controls

59 lines (33 loc) · 2.05 KB

Snowflake Run SQL Action

Description

Runs a specified SQL query in Snowflake.

Configuration

Basic

Label: Label for UI.

Account Name: 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"). E.g. "myaccount.us-central1.gcp".

Database: Database that contains the table to query.

Schema: Schema that contains the table to query.

Warehouse: Warehouse that provides the compute resources.

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

Query: SQL query to run.

Credentials

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

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

Key Pair Authentication

Key Pair Authentication Enabled: If true, plugin will perform key pair authentication.

Private Key: Private key contents.

Key File Passphrase: Passphrase for the private key file.

OAuth2

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

OAuth2 Enabled: If true, plugin will perform OAuth2 authentication.

Client ID: Client id obtained via system function SYSTEM$SHOW_OAUTH_CLIENT_SECRETS

Client Secret: Client id obtained via system function SYSTEM$SHOW_OAUTH_CLIENT_SECRETS

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

Advanced

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