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
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);
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);
Configure Key Pair Authentication (optional)
If you would like to setup key pair authentication instead of using a password, follow Snowflake's documentation
Enrollment
To enroll your Snowflake instance:
Navigate to settings-> Connector Settings -> Snowflake -> + Enroll New Account
Enter your account information and click Next
Choose your Authentication Type.
Enter your user credentials or keypair and click Enroll
Last updated
Was this helpful?