Skip to end of metadata
Go to start of metadata

Introduction

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.

Known Issue

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:

Connectivity tab

To configure a new Snowflake connection, within the Connectors filter, click the Snowflake connector block:

Snowflake connection new

To configure an existing Snowflake connection, within the Endpoints filter, double-click the Snowflake connection block:

Snowflake connection existing

This will open a configuration screen for the Snowflake connection, covered next.

Configuring a Snowflake Connection

Configuration of a Snowflake connection includes these fields:

Snowflake connection configuration

TIP: Fields with a variable icon Variable icon support using global variables, project variables, and Jitterbit variables. Begin by either typing an open square bracket [ into the field or by clicking the variable icon to display a list of the existing variables to choose from.

  • 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.com concatenated together, such as rb68341.us-east-1.snowflakecomputing.com.

  • 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.

Next Steps

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.

On This Page

Last updated:  Jan 15, 2020

  • No labels