A Snowflake connection is configured via the Snowflake connector to establish access to an account on the Snowflake server. Once a connection is established, you can configure one or more Snowflake activities associated with that connection to use as a source or target within an operation.
When configuring a Snowflake connection, you should be aware of this current known issue:
- Snowflake: A connection says an incorrect schema is a valid connection when tested
- Summary: When you create a connection to a Snowflake instance and pass the wrong schema name, testing returns Connection Success. However, any activities you create will fail.
- Additional Information: The Snowflake activity returns the error message Unable to fetch data. An error occurred: Cannot read property 'errorDesc' of undefined" for the failed activity.
- Workaround: Change the schema name to the correct name and the activity is successful.
Creating or Editing a Snowflake Connection
From the design canvas, open the Connectivity tab of the design component palette:
To configure a new Snowflake connection, within the Connectors filter, click the Snowflake connector block:
To configure an existing Snowflake connection, within the Endpoints filter, double-click the Snowflake connection block:
This will open a configuration screen for the Snowflake connection, covered next.
Configuring a Snowflake Connection
Configuration of a Snowflake connection includes these fields:
Endpoint Name: Enter a name to use to identify the Snowflake connection. The name must be unique for each Snowflake connection and must not contain forward slashes (
/) or colons (
Host Name: Enter the Snowflake host name. This is the Snowflake account name (such as
rb68341.us-east-1) and the Snowflake domain name of
snowflakecomputing.comconcatenated together, such as
User Name: Enter the Snowflake user name.
Password: Enter the Snowflake password.
Account: Enter the Snowflake account.
Database Name: Enter the Snowflake database name.
Schema Name: Enter the Snowflake schema name.
Warehouse Name: Enter the Snowflake warehouse name.
Test: Click this button to verify the connection. The server will check only that the specified user can make a connection.
Save Changes: Click this button to save and close the connection configuration.
Discard Changes: After making changes to a new or existing configuration, click Discard Changes to close the configuration without saving. A message will ask you to confirm that you want to discard changes.
Delete: After opening an existing connection configuration, click Delete to permanently delete the connection from the project and close the configuration (see Component Dependencies, Deletion, and Removal). A message asks you to confirm that you want to delete the connection.
NOTE: For more information on using database and schema names with Snowflake, see the Snowflake Database, Schema, & Share DDL documentation.
After configuring a Snowflake connection, you can configure one or more Snowflake activities associated with that connection to use as a source or target within an operation. For more information, see these pages:
Query Activity: Retrieves an existing record on a Snowflake connection and is intended to be used as a source in an operation.
Get Activity: Retrieves table or view data from a Snowflake connection and is intended to be used as a source in an operation.
Put Activity: Puts data into a table (either as a CSV file or directly mapped to columns of a table) on a Snowflake connection and is intended to be used as a target in an operation.
Invoke Stored Procedure Activity: Provides the ability to use stored procedures created in Snowflake and is intended to be used as a target in an operation.
Delete Activity: Deletes table data on a Snowflake connection and and is intended to be used as a target in an operation.
Last updated: Jan 15, 2020
- No labels