Skip to main content
All CollectionsSystem Setup Guides
Snowflake Connector Setup
Snowflake Connector Setup
Updated over a week ago

Welcome to the Snowflake Connector Setup guide!

In this article, we will cover the following:

  • Authenticating Snowflake in Savant


Authenticating Snowflake in Savant

Connectivity

Savant accesses your Snowflake from two IP addresses:

  • 35.188.163.165

  • 34.122.126.216

If your network is configured to only allow access from certain IPs, include these in your whitelist.

Snowflake Setup

We recommend creating a specific user and role for Savant with permission to access the required objects in your Snowflake. If you already have a user and role created with appropriate permissions, you can skip this step.

Create Snowflake User

Run these commands to create a Savant user and role:

CREATE ROLE IF NOT EXISTS savant_role COMMENT = "Access to selected tables for Savant";

CREATE USER savant_user password = '<secure_password>' first_name = 'Savant' last_name = 'User' default_warehouse = '<warehouse>' default_namespace = '<database.schema>' default_role = '<savant_role>' comment = 'Used for Savantd integrations';

GRANT ROLE savant_role TO ROLE SYSADMIN;

GRANT ROLE savant_role TO USER savant_user;

Grant Permissions

The role will need access to the warehouse, database, schema, and tables. For input data, it needs read access to the desired data objects. For writing data from Savant to Snowflake, it needs write access to the desired data objects.

Run these commands to grant permissions to the Savant role:

GRANT USAGE ON WAREHOUSE "<warehouse>" TO ROLE savant_role;

GRANT USAGE ON DATABASE "<database>" TO ROLE savant_role;

GRANT USAGE ON SCHEMA "<database>"."<schema>" TO ROLE savant_role;

GRANT SELECT ON ALL TABLES IN SCHEMA "<database>"."<schema>" TO ROLE savant_role;

GRANT SELECT ON FUTURE TABLES IN SCHEMA "<database>"."<schema>" TO ROLE savant_role;

GRANT SELECT ON ALL VIEWS IN SCHEMA "<database>"."<schema>" TO ROLE savant_role;

GRANT SELECT ON FUTURE VIEWS IN SCHEMA "<database>"."<schema>" TO ROLE savant_role;

Getting Started in Savant

Once you’ve completed the steps above, follow these steps in Savant:

  1. Go to the Systems page and click Add System

  2. Select the Snowflake connector and click Next

  3. Enter your system information and credentials from above

  4. Click Authenticate and then Confirm

You can now create Snowflake datasets in Savant!


Did this answer your question?