Setting up a Snowflake Connector
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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 if you're missing something.
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"
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
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
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
.
After selecting data from your connector you will be able to create a dataset thanks to using the selection as "source step".