Skip to end of metadata
Go to start of metadata

Snowflake Connector

Overview

The Jitterbit Harmony Snowflake Connector is accessed from the Connectivity tab of the design component palette:

Connectivity tab

This connector is used to first configure a Snowflake connection, establishing access to an account on the Snowflake server, and then used to configure one or more Snowflake activities associated with that connection as either a source or target within an operation:

  • Query Activity: Retrieves an existing record on a Snowflake connection and is used as a source in an operation.

  • Get Activity: Retrieves table or view data from a Snowflake connection and is 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 used as a target in an operation.

    Delete Activity: Deletes table data on a Snowflake connection and is used as a target in an operation.

  • Invoke Stored Procedure Activity: Provides the ability to use stored procedures created in Snowflake as a target in an operation.

The Snowflake connector uses the Snowflake JDBC Driver and the Snowflake SQL commands. Only Comparison Operators are supported in this version in the query activity. For additional information on the Snowflake Query activity, see the Snowflake documentation.

The Snowflake connector is restricted to using CSV files as input and output for its activities. The Snowflake connector requires the use of an agent version 10.1 or higher.

Together, a specific Snowflake connection and its activities are referred to as a Snowflake endpoint. Once a connection is configured, activities associated with the endpoint are available from the Endpoints filter:

Connectivity tab

  • No labels