Skip to main content

Snowflake

Integrate via Direct Connect

Updated over a year ago

Steps

  1. Create a role, name it KUBIT.sql

    CREATE ROLE KUBIT;

  2. Create a user and name it KUBIT.
    Kubit team will generate and share a password, which you should use to create the user.SQL

    CREATE USER KUBIT PASSWORD='*****' DEFAULT_ROLE = KUBIT;
    GRANT ROLE KUBIT TO USER KUBIT;

  3. Share your Snowflake account locator with the Kubit team.

  4. Create a database called KUBIT.SQL

    CREATE DATABASE KUBIT;

  5. Make the KUBIT role owner of the KUBIT database. This will allow us to create and execute tasks that are only available to an owner role.SQL

    GRANT OWNERSHIP ON DATABASE KUBIT TO ROLE KUBIT;

  6. Create a Data Warehouse called KUBIT (size depends on your data volume)

    1. Grant the KUBIT role the following privileges: MONITOR | USAGE | OPERATESQL

      CREATE OR REPLACE WAREHOUSE KUBIT WAREHOUSE_SIZE=... INITIALLY_SUSPENDED=TRUE; 
      GRANT MONITOR ON WAREHOUSE KUBIT TO ROLE KUBIT; 
      GRANT USAGE ON WAREHOUSE KUBIT TO ROLE KUBIT; 
      GRANT OPERATE ON WAREHOUSE KUBIT TO ROLE KUBIT;

  7. Add read-only (SELECT) permissions to the KUBIT role to your intended data tables/views.

👍 Best Practice

Create one more user, role and warehouse for development purposes in order to isolate the impact on the production environment and avoid accidents.

Did this answer your question?