Connect action in Snowflake package

The Connect action establishes a secure connection to Snowflake and creates an automation session.

Overview

The Connect action uses an existing OAuth connection along with Snowflake username to authenticate the connection. The action creates a reusable session that serves as the authentication context for downstream actions. You can also create a global session variable to pass the authentication context from a parent automation to a child automation.

Settings

The following settings are available in the Connect action:

OAuth2 connection
Specifies the Control Room managed OAuth connection that the action uses for authentication. Use the Pick option and follow the prompts in the Pick an OAuth connection modal to select an available OAuth connection.
Account
Specifies the Snowflake account username to use along with the OAuth connection for authentication.
Snowflake session
Specifies the session name that the Connect action creates after successful authentication. This session name serves as the authentication context for downstream actions. The action sets Default as the session name in Local session when you add the action. You can either retain the default name or specify a new session name using one of the following:
  • Local session: Specify the new name directly or create a string variable for the name and select it using the Insert a value option. This new name applies only to the current automation.
  • Global session: Specify the new name directly or create a string variable for the name and select it using the Insert a value option. This new name applies to both parent and child automations.
  • Variable: Select an existing Snowflake session variable or create one using the Insert a value option and select the variable.