Skip to Content

Supported connectors

Connect Snowflake

Connect Snowflake with a user, role and warehouse that can read your data.

Before you start

  • You are an Admin or a Developer, or your role has the datasource Connect permission.
  • Your firewall allows Databrain’s outbound IP on the database port. The form shows the IP under Setup guide > Allow the outbound IP. See Allow Databrain’s IP.
  • You have a Snowflake user and a role that can use the warehouse, database and schema.

Connect

  1. Go to Data Studio > Datasources and select Connect data source.

    Datasources page with the Connect data source button outlined
    Connect data source is at the top right of the Datasources page.
  2. Select Snowflake. You can type the name in Search connectors.

    Add datasource page with the Snowflake tile outlined
    The Snowflake tile on the Add datasource page.
  3. Fill in the form:

    FieldWhat to enter
    Datasource nameHow this datasource appears in lists and pickers, for example Production warehouse.
    HostYour account in <account_locator>.<region>.<cloud> format, for example xy12345.us-east-1.aws. Do not add https:// or .snowflakecomputing.com.
    RoleThe role Databrain uses.
    WarehouseThe warehouse that runs the queries.
    DatabaseThe database you want to read from.
    Default SchemaThe schema Databrain queries unless a model says otherwise.
    UsernameThe Snowflake user.
    Credentialsusername/password (then Password) or Key-pair authentication (then Private Key and, for an encrypted key, Private Key Pass).
  4. Select Connect datasource.

Connect Snowflake form with the connect button outlined and the Setup guide on the right
Fill in the form, then select the button at the bottom. The Setup guide on the right lists the grants and where each value comes from.

Databrain checks the connection and reads your schema. You see Step 3 of 3 with Model your data. Next, create a datamart.

Grant read access

The user needs SELECT on the tables you want to model, and read access to information_schema so Databrain can read the schema. Replace the placeholders:

GRANT USAGE ON DATABASE <db> TO ROLE <role>;
GRANT USAGE ON SCHEMA <db>.<schema> TO ROLE <role>;
GRANT SELECT ON ALL TABLES IN SCHEMA <db>.<schema> TO ROLE <role>;
GRANT USAGE ON WAREHOUSE <warehouse> TO ROLE <role>;

Where to find the values

  • Role: the role menu at the top right of the Snowflake UI.
  • Warehouse: the Warehouses tab.
  • Database and schema: the Databases tab.

If something goes wrong

If the check fails, the datasource stays on the form with Needs credentials. Fix the field the message names and select Connect datasource again.

  • The database did not answer in time. A firewall blocks Databrain. Allow the outbound IP on the database port.
  • The database rejected these credentials. Check the username and password, and that the user can sign in from a remote host.
  • The credentials worked, but the user cannot read the catalogue. Run the grants above.

On this page