Sled
HomeBlogStart for free
Search…
Welcome to Sled
Get Started
Connect with Snowflake
Enabling SSO on Snowflake
Background Tasks for Snowflake
Configure Paths for Snowflake Background Tasks
Lineage and Data Flows
Tableau Integration
Powered By GitBook
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!
Previous
Get Started
Next
Enabling SSO on Snowflake
Last modified 7mo ago
Copy link
Contents
Create a Role and a User
Create the Snowboard Database
Grants Read Access to Data
Grants Read Access to Account Information
Grant right to enable Single-Sign-On