๐Ÿ”ŒSetting up a Snowflake Connector

Overview

The Snowflake connector allows you to connect your Snowflake cloud database to Toucan.

In this guide, you'll learn how to connect Toucan Toco to your Snowflake data.

If youโ€™re looking for more advanced guides on how to configure rights and access in Snowflake for Toucan, you can check our other docs:

Configuring the Snowflake connector in Toucan

In this part, we assume you already have:

  • a user (and its password). We'll use TOUCAN_USER

  • that user has a role configured. We'll use TOUCAN_ROLE

  • that role can access the database you need. We'll call it TOUCAN_TEST

  • that role can use a warehouse. We'll call it TOUCAN_WH

Go to this detailed guide on setting up Snowflake if you're missing something.

As a security best practice, we recommend you create a specific user and role to connect to Toucan; check out our guide on granting access if you need to do this.

Choice of type of Snowflake connector

In Toucan, you have the choice of 2 connectors: "Snowflake" and "SnowflakeOauth2".

The "Snowflake" connector is usually simpler to configure: you just need a Snowflake user with a login and password. -> Use this connector to quickly try out our connection or for small personal apps.

The "SnowflakeOauth2" connector implements the OAuth2 protocol, a standard and secure way to authorize a connection between Toucan and Snowflake. -> We recommend you use this for production apps. The detailed documentation is here

Configuring the Snowflake with login/password connector

  • Click "Add connector" in the Toucan connector interface.

  • Fill out the form with the following info:

  • name: give a name, for example, "my_snowflake_connector"

  • account: usually of the form account_id.region_id.cloud_platform. When you connect to your snowflake UI, it is the first part of the url <account_identifier>.snowflakecomputing.com. You can read more about it here

  • authentication method: leave it as "Snowflake (ID+Password)"

  • User: TOUCAN_USER

  • Password: The password for TOUCAN_USER

  • Token endpoint: leave empty

  • Token endpoint content type: leave unchanged ('application/json')

  • Role: TOUCAN_ROLE

  • Default Warehouse: TOUCAN_WH

  • Retry policy: leave unchecked

  • Click save. You should see the following check succeeding:

  • Once the check has succeeded, you can close the popup window and save the form.

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Selecting data from Snowflake

To create a dataset from Snowflake, click on the "create from" icon, you will then be able to:

  • Select the Database

  • Select the Data warehouse

  • Select the Schema

  • Select Table or Views

  • Only keep the columns you need

For more info, see the dedicated section Creating datasets

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".

Last updated