Snowflake

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
   

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 | OPERATE
      SQL

      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.