Snowflake

Integrate Teleskope with Snowflake

Requirements

In order to integrate Teleskope with Snowflake, you must make sure the following prerequisites are met:

• Within Snowflake: You must have a Snowflake user with the ACCOUNTADMIN role

• Within Teleskope: A Teleskope admin account to complete the setup process.

Integration

1

Create a Teleskope Snowflake Role

For each

use role ACCOUNTADMIN;

set role = teleskope_role;

create role if not exists identifier($role);
          

2

Grant read access to the Teleskope Role

For each snowflake database, execute the following command to grant the teleskope role access to it

set database ='{database}';

grant usage on warehouse identifier($warehouse) to role identifier($role);
grant usage on database identifier($database) to role identifier($role);    
grant usage on all schemas in database identifier($database) to role identifier($role);
grant usage on future schemas in database identifier($database) to role identifier($role);
grant select on future tables in database identifier($database) to role identifier($role);
grant select on all tables in database identifier($database) to role identifier($role);                           
grant select on future views in database identifier($database) to role identifier($role);         
grant select on all views in database identifier($database) to role identifier($role); 

3

Grant write access to the Teleskope Role (optional)

grant delete on future tables in database identifier($database) to role identifier($role);
grant delete on all tables in database identifier($database) to role identifier($role);                           
grant delete on future views in database identifier($database) to role identifier($role);         
grant delete on all views in database identifier($database) to role identifier($role); 

4

Create a Teleskope Snowflake User

set user =teleskope;
set password ='{password}';

create user identifier($user) 
  password = $password
  default_warehouse = $warehouse
  default_role = $role
  comment ='Teleskope read only user';

grant role identifier($role) to user identifier($user);

Enrollment

To enroll your Snowflake instance:

1. Navigate to settings-> Connector Settings -> Snowflake -> + Enroll New Account

2. Enter your account information and click Next

3. Choose your Authentication Type.

4. Enter your user credentials or keypair and click Enroll