Snowflake: Connecting to iPaaS

Overview

Before iPaaS can interact with and take actions in any application, you must connect the application to iPaaS by following our standard four-step process: (1) obtain an authorization identifier (API key, token, OAuth app, etc) in the application; (2) identify the authentication method to use in iPaaS; (3) create an iPaaS credential using your identifier and auth method; (4) create a connector definition in iPaaS using that credential.

For each Snowflake instance you have (Prod, Dev, Test, QA, Sandbox, etc), follow the steps below to connect it to iPaaS. Note that you must have both the Connector Definitions and Connector Credentials roles in iPaaS.

Step 1: Create a User in Snowflake

Use Snowflake's documentation to create a user. Make sure to grant the user access to any tables or databases you want iPaaS to be able to interact with. You may want to create separate users with different permission sets.

For more information, see User Management at Snowflake's knowledge base.

Step 2: Identify the Auth Method in iPaaS

Snowflake uses Generic Username and Password as its Auth Method.

Step 3: Create a Credential in iPaaS

iPaaS credentials can be created as shared credentials or application-specific credentials. For more information see Setting up iPaaS Connector Credentials.
  1. Navigate to where you will create the credential.
    • To create a shared credential:
      1. From the top menu bar go to Administration > Shared Credentials.
    • To create an application-specific credential:
      1. Navigate to the application you want to create the credential for.
      2. In the left navigation pane click Credentials.
  2. In the top right corner click Add.
  3. Enter or set the following values. Note that some variables have a dropdown menu from which you can choose a value.
    • Name: the Snowflake database this credential is for (Prod, Dev, Test, QA, Sandbox, etc)
      • E.g., Snowflake Production
    • Description: [System] credential created by [Who]
      • Where [System] is the Snowflake instance and [Who] is the name of the individual who created the credential. If your team has multiple people creating credentials, this allows you to easily identify who created which credential.
      • E.g., Snowflake Production credential created by Bryan N
    • Authentication Method:
    • Under Fields enter or modify only the following values, and leave all other fields blank. Click inside the box under the Field Value column to edit it.
      • Username: the username of the Snowflake user you created
      • Password: the password of the Snowflake user you created
  4. Click Add New.

Step 4: Create a Connector Definition in iPaaS

  1. From the top menu bar go to Administration > Connector Definitions.
  2. In the top right corner click Add.
  3. For Connector Type select Standard and click Next.
  4. In the Add Standard Connector search box enter Snowflake. The predictive search will display available options.
  5. Select the Snowflake connector and click Next.
  6. Click Add Connector.

Using the Snowflake Connector

For more information on using the Snowflake connector, see our article on working with SQL connectors in iPaaS.

Print Article