Using Password Authentication
Last updated
Was this helpful?
Last updated
Was this helpful?
To connect Snowflake to Select Star, you will need:
Admin access to your Snowflake instance via the ACCOUNTADMIN role.
Complete the following steps to enable metadata, lineage, and popularity for your Snowflake data in Select Star.
Log in to Snowflake. Using the ACCOUNTADMIN role, execute the following SQL:
To enable Select Star’s Preview feature and access additional metadata—such as Primary Keys (PK) and Foreign Keys (FK) —you’ll need to grant the following permissions.
Using the ACCOUNTADMIN role, execute the following SQL for each database you want to ingest (example uses DWH as the database name):
To see lineage for dynamic tables, we recommend granting permission to read dynamic table definitions. Without this, lineage can only be inferred from query logs, which may not be fully reliable.
Using the ACCOUNTADMIN role, execute the following SQL for each database you want to ingest (example uses DWH as the database name):
If you're granting these permissions after your Snowflake metadata has already been synced, you'll need to re-sync it.
Go to Settings > Data
Click on Sync metadata on your Snowflake Data source.
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 Snowflake by default, but you can override it if desired.
Account: The account name is the name to the left of snowflakecomputing.com when you log in to Snowflake.
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
Click Save and fill in the Authentication Details:
Authentication: Select Password.
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
After you fill in the information, you'll be asked to select the databases you'd like to load into Select Star.
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.
If the latency of updates in ACCOUNT_USAGE is too high for your needs (see ), you can switch to INFORMATION_SCHEMA instead, providing faster updates in the UI.
You can you have loaded if needed.
