Snowflake Connector

Snowflake is a cloud data platform. Use the Snowflake component to access and update data in a Snowflake Database.

Connections

Use this connection if you want to connect to Snowflake via their Key Pair Authentication.

Input	Comments	Default
Private Key	The private key for the Snowflake Key Pair Authentication.
Snowflake Username	Your Snowflake username.
Account Identifier	You can find the account identifier in the organization's account panel https://docs.snowflake.com/en/user-guide/admin-account-identifier
Passphrase	The passphrase for the provided private key (Required).

Snowflake OAuth 2.0 Authentication.

This connection uses OAuth 2.0, a common authentication mechanism for integrations. Read about how OAuth 2.0 works here.

Input	Comments	Default
Authorize URL	The OAuth 2.0 Authorization URL for the API
Token URL	The OAuth 2.0 Token URL for the API
Scopes	Space separated OAuth 2.0 permission scopes for the API
Client ID	Client Identifier of your app for the API
Client Secret	Client Secret of your app for the API
Headers	Additional header to supply to authorization requests

Executes one or more SQL statements in your Snowflake DB.

Input	Comments	Default
Connection
SQL statements to run
Snowflake Identifier URL	The Snowflake URL for you account. Has to have the format: https://.snowflakecomputing.com
Account Locator	You can find the account locator in the organization's account panel or https://docs.snowflake.com/en/user-guide/admin-account-identifier#finding-the-region-and-locator-for-an-account
Number of statements to execute	0 Indicates that a variable number of statements can be included in the request.
Timeout	Timeout in seconds for statement execution. If the execution of a statement takes longer than the specified timeout, the execution is automatically canceled.
Database	Database in which the statement should be executed.
Schema	Schema in which the statement should be executed.
Warehouse	Warehouse to use when executing the statement.
Role	Role to use when executing the statement.
Bindings	Values of bind variables in the SQL statement. Bindings should have this format:
Parameters	Session parameters that you want to set for this request. Parameters should have this format:
Poll for asynchronous results	If true, action will handle polling for results on queries that take > 45 seconds to execute, If false, action will return immediately after executing the query.	false
Debug Request	Enabling this flag will log out the current request.	false

Retrieve the current status of a executed statement from Snowflake.

Input	Comments	Default
Connection
Snowflake Identifier URL	The Snowflake URL for you account. Has to have the format: https://.snowflakecomputing.com
Account Locator	You can find the account locator in the organization's account panel or https://docs.snowflake.com/en/user-guide/admin-account-identifier#finding-the-region-and-locator-for-an-account
Statement Handle ID	The ID of the statement handle.
Partition	The partition number to retrieve.
Debug Request	Enabling this flag will log out the current request.	false