Snowflake connection guide for Jitterbit App Builder

Introduction

This guide shows you how to connect an App Builder app to a Snowflake account.

Prerequisites

• An active Snowflake account, configured for OAuth.

Connection instructions

To set up a Snowflake connection, follow the steps below.

1. Set up a security provider

1. Select IDE > Security Providers.

2. Click the + User Authentication button.

3. Set values for the following fields:

   • In the Settings section:

     • Name: Enter a name for the security provider.
     • Type: Select OAuth.
     • Enabled: Selected.

   • In the Authentication section:

     • OAuth Grant: Select Authorization Code.
     • OAuth Client Authentication: Select Basic.
     • OAuth Resource Authentication: Select Bearer.

   • In the Tokens section:

     • Owner: Select User.

   • In the Sign In section:

     • Redirect On Challenge: Selected.

4. Click the Save button. Additional panels appear.

5. In the Endpoints section, click the + Endpoint button, then add the following endpoints:

   Endpoint Type	URL
   Authorization Endpoint	https://{Snowflake account URL}/oauth/authorize
   Token Endpoint	https://{Snowflake account URL}/oauth/token-request

6. In the Credentials section, click the + Credential button, then add the following credential:

   Type	User Name	Password
   Client	OAUTH_CLIENT_ID	OAUTH_CLIENT_SECRET

   Note

   OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET are outputs of the SYSTEM$SHOW_OAUTH_CLIENT_SECRETS command.

7. In the Properties section, click the + Property, then add the following property:

   Parameter	Value
   Scopes	session:role:SYSADMIN

2. Set up a data server

1. Select IDE > Data Servers.
2. Click the + Server button.

3. In the Server popup, set values for the following:

   • In the Server Settings section:

     • Server Name: Enter a name for this Snowflake server.
     • Type: Select Snowflake. Additional fields appear. Set values for the following:
       • URL: The URL.
       • Warehouse: Your Snowflake warehouse name.
       • Database Name: Your Snowflake database name.
       • Schema Name: Your Snowflake schema name.

   • In the Security section:

     • Security Provider: Select the OAuth security provider created earlier.
     • User Name: Leave blank.
     • Password: Leave blank.

   • Description: (Optional) Enter a description for this data server.

4. Click the Save button.

5. In the Server Settings section, click the Advanced Settings button. The Server (Advanced Settings) popup opens.
6. Click the Edit button.
7. In the Advanced field, enter AuthScheme=OAuth.
8. Click the Save button, then close the Server (Advanced Settings) and Server popups.

You can now use the data server in your apps.

Troubleshooting

If you experience issues with Snowflake, these troubleshooting steps are recommended:

1. Enable data logging to generate log files and data, which you can download and inspect.

2. Refer to the CData ADO.NET Provider for Snowflake documentation for detailed information.