Snowflake Connector Setup

Version 22.0.8473


Snowflake Connector Setup


The Snowflake connector allows you to integrate Snowflake into your data flow by pushing or pulling data from Snowflake. Follow the steps below to connect CData Arc to Snowflake.

Establish a Connection

To allow Arc to use data from Snowflake, you must first establish a connection to Snowflake. There are two ways to establish this connection:

  • Add a Snowflake connector to your flow. Then, in the settings pane, click Create next to the Connection drop-down list.
  • Open the Arc Settings page, then open the Connections tab. Click Add, select Snowflake, and click Next.

Note:

  • The login process is required only the first time that the connection is created.
  • Connections to Snowflake can be re-used across multiple Snowflake connectors.

Enter Connection Settings

After you open a new connection dialogue, follow these steps:

  1. Enter the connection information:
    • Name—the static name of the connection. Set this as desired.
    • Type—this is always set to Snowflake.
    • Auth Scheme—the authentication scheme to use for the connection. Options are Password, OAuth, Okta, PrivateKey, Azure AD, and PingFederate.
  2. Create the connection according to your selected Auth scheme:
    • Password-enter the password for your account.
    • OAuth—enter the OAuth client Id and OAuth client secret for your account.
    • Okta-enter the username and password for your account.
    • PrivateKey-enter the private key and the private-key type for your account.
    • Azure AD-enter the username for your account.
    • PingFederate-enter the username for your account.
  3. If necessary, click Advanced to open the drop-down menu of advanced connection settings. You should not need these settings in most cases.

  4. Click Test Connection to ensure that Arc can connect to Snowflake with the provided information. If an error occurs, check all fields and try again.

  5. Click Add Connection to finalize the connection.

  6. In the Connection drop-down list of the connector configuration pane, select the newly-created connection.

  7. Click Save Changes.

Select an Action

After establishing a connection to Snowflake, you must choose the action that the Snowflake connector will perform. The table below outlines each action and where it belongs in an Arc flow.

Action Description Position in Flow
Upsert Inserts or updates Snowflake data. By default, if a record already exists in Snowflake, an update is performed on the existing data in Snowflake using the values provided from the input. End
Lookup Retrieves a value from Snowflake and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from Snowflake. It should be formatted as a SQL query against the Snowflake tables.
Middle
Select Retrieves data from Snowflake and brings it into Arc.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
Beginning
Execute Stored Procedures Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.
Middle