Connect with Snowflake
~ 20 min to complete
You need an
ACCOUNTADMIN user to follow this guide.Create a Role and a User
This creates a dedicated role and technical user. Replace
example_wh with your preferred warehouse. XS is enough for most installations. It is ok to share this warehouse with other workloads to save costs. Set a secure password.1
create role snowboard_role;
2
create user snowboard_user
3
--specify your own password and remember it for later
4
password = '<something secret>'
5
--specify your warehouse
6
default_warehouse = example_wh
7
default_role = snowboard_role
8
default_namespace = snowboard
9
comment = 'Technical User for Snowboard Data Catalog 🏂';
10
grant role snowboard_role to user snowboard_user;
11
12
--allow usage of your warehouse
13
grant usage on warehouse example_wh to role snowboard_role;
Copied!
Create the Snowboard Database
This database will be used to store profiling results and the parsed query log. You can easily access it for your own analytics. Data ownership is great.
1
create database snowboard;
2
grant ownership on database snowboard to role snowboard_role;
Copied!
Grants Read Access to Data
For each database that should be added to the data catalog execute these statements. Replace
example_db with the correct name. You can add more databases later, have at least one to get started.1
set db_name = 'example_db';
2
grant usage on database identifier($db_name) to role snowboard_role;
3
grant usage on all schemas in database identifier($db_name) to role snowboard_role;
4
grant usage on future schemas in database identifier($db_name) to role snowboard_role;
5
grant select, references on all tables in database identifier($db_name) to role snowboard_role;
6
grant select, references on future tables in database identifier($db_name) to role snowboard_role;
7
grant select, references on all views in database identifier($db_name) to role snowboard_role;
8
grant select, references on future views in database identifier($db_name) to role snowboard_role;
9
grant select, references on all materialized views in database identifier($db_name) to role snowboard_role;
10
grant select, references on future materialized views in database identifier($db_name) to role snowboard_role;
Copied!
For shared databases the following statement is enough. Replace
external_db with the correct name.1
grant imported privileges on database external_db to role snowboard_role;
Copied!
Grants Read Access to Account Information
Grant access to the query log and further meta data from Snowflake.
1
grant imported privileges on database snowflake to role snowboard_role;
Copied!
Grant right to enable Single-Sign-On
Allow the technical user to create a single-sign-on integration.
1
GRANT CREATE INTEGRATION ON ACCOUNT TO ROLE snowboard_role;
Copied!
Last modified 5mo ago