Snowflake
Follow these steps to connect your Snowflake instance to Select Star.
Before you start
To connect Snowflake to Select Star, you will need...
- Admin access to your Snowflake instance via the
ACCOUNT_ADMINrole.
Complete all of the following steps to see Snowflake metadata, lineage, and popularity in Select Star.
1. Create Select Star user in Snowflake
Log in to Snowflake. Using the
ACCOUNT_ADMIN role, execute the following SQL:1
-- Required for basic metadata & query history access
2
create role selectstar_role;
3
grant imported privileges on database snowflake to role selectstar_role;
4
create user selectstar password='s313ctst8r' default_role='selectstar_role';
5
grant role selectstar_role to user selectstar;
6
grant usage on warehouse MED to selectstar_role;
Copied!
These are the minimum permissions required for Select Star to collect basic metadata and query history. Query history is also used to generate lineage.
2. Grant additional permissions for faster metadata and preview access.
This step is optional, but highly recommended to provide faster metadata access, especially for customers with large quantities of data.
If you choose not to grant these permissions, your metadata syncs may take longer to complete.
This step is required if you wish to see previews of your data values in the table page of Select Star.
Using the
ACCOUNT_ADMIN role, execute the following SQL:1
-- Required for faster metadata access & data preview feature
2
grant usage on database DWH to role selectstar_role;
3
grant usage on all schemas in database DWH to role selectstar_role;
4
grant select on all tables in database DWH to role selectstar_role;
5
grant usage on future schemas in database DWH to role selectstar_role;
6
grant select on future tables in database DWH to role selectstar_role;
Copied!
3. Connect Snowflake to Select Star
Go to the Select Star Settings. **** Click Data in the sidebar, then + Add to create a new Data Source.
Choose Snowflake in the Source Type dropdown and provide the following information:
- Display Name: This value is
Snowflakeby default, but you can override it if desired. - Account: The account name is the name to the left of
snowflakecomputing.comwhen you log in to Snowflake. - Username: The name of the service account user you created. In the example above, it is
selectstar - Password: The password for the service account user you created. In the example above, it is
s313ctst8r - Role: The role you granted the service account user. In the example above, it is
selectstar_role - Warehouse: The name of the data warehouse you've given us access to. In the example above it is
MED
4. Choose databases and schemas
After you fill in the information, you'll be asked to select the databases you'd like to load into Select Star.
Select Star will not read queries or metadata or generate lineage for databases, schemas, or tables that are not loaded. Please load all data for which you expect to see lineage.
Select the database and click Next.
For each database you selected, you'll be able to select the schemas.
Your metadata should start loading automatically. Please allow 24-48 hours to completely generate popularity and lineage.
When the sync is complete, you'll be able to explore Snowflake in Select Star. See the link below for more information on Snowflake in Select Star.
Last modified 4mo ago