Snowflake

How to connect using the Snowflake system integration

Introduction

Connecting Couchdrop to a Snowflake database is straight-forward

Requirements

To connect to Snowflake in Couchdrop you will need:

• A Snowflake account, with a table created that you want to upload data into

• Access credentials, such as your account ID, table name and access key

  • To generate an access key, your Snowflake user must be able to authenticate according to your authentication and network policies

    • The network policy setup for your user in Snowflake can block us from authenticating and connecting to your Snowflake account. The authentication policy setup for your user in Snowflake can prevent the network policy from blocking us, if it is an issue, by running

      CREATE|ALTER AUTHENTICATION POLICY <my_policy_name>
        PAT_POLICY=(
          NETWORK_POLICY_EVALUATION = NOT_REQUIRED
        );

    • The authentication policy can also block us from connecting if the authentication methods have been configured, and do not include PROGRAMMATIC_ACCESS_TOKEN in the available authentication methods. To see if this is the case you can run

      DESCRIBE AUTHENTICATION POLICY <authentication_policy_name>;

      To add the authentication method to your authentication policy, you can run

      ALTER AUTHENTICATION POLICY <authentication_policy_name>
        SET AUTHENTICATION_METHODS = ('PROGRAMMATIC_ACCESS_TOKEN');

  • To generate the programmatic access token

    ALTER USER IF EXISTS <example_user> ADD PROGRAMMATIC ACCESS TOKEN example_token;

  • For a comprehensive guide on generating an access token, see https://docs.snowflake.com/en/user-guide/programmatic-access-tokens

Configuration Steps

1. Log in to Couchdrop and add a new system integration

2. Select Snowflake from the list of available integrations

3. Provide the details above

4. Click Add System Integration