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.
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.
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 hereauthentication 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
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
Was this helpful?