Snowflake

Setup Snowflake Integration To Mitzu

Overview

To connect Mitzu to Snowflake, you’ll need the following:

• Account ID

• Database

• Username

• Password

• Warehouse

• Role

Mitzu will encrypt these credentials and will never store them as plain text.

Snowflake connection setup in Mitzu

1. Account ID

Enter your Account ID with the region that your Snowflake cluster is running on. E.g., xxxxxxxxx.us-east-1.aws.

Enter your Snowflake Account Identifier. For example, if you’re running Snowflake on AWS and your account URL is https://IVMDAAM-DH09820.snowflakecomputing.com:

• <account_identifier>: IVMDAAM-DH09820

You’d enter IVMDAAM-DH09820 as the account name in Mitzu.

Some regions require the cloud platform identifier. For the requirements per region, see the official Snowflake’s documentation.

For more information, please visit the official documentation of Snowflake.

2. Username

The database username for the account that you want to use to connect to your database. You can set up multiple connections to the same database using different user accounts to connect to the same database, each with different sets of privileges.

3. Password

The password for the username that you use to connect to the database.

4. Warehouse

Snowflake warehouse. If the user lacks a default warehouse, you’ll need to enter the warehouse to connect to.

5. Database name (case sensitive)

The name of the database you want to connect to in Snowflake.

6. Role

The name of the role you want to connect with to Snowflake.

Whats next?

Add tables from Snowflake. Follow here.