Using Key Pair 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.
Go to Data Sources in Select Star
Navigate to Settings > Data.
Click + Add to create a new data source.
Select Snowflake as the Source Type
In the Source Type dropdown, choose Snowflake.
Fill in the Connection Details Provide the following information:
Display Name:
Default is Snowflake
. You can customize it if desired.
Account:
Your Snowflake account name (the part before .snowflakecomputing.com
in your Snowflake URL).
Role:
The role you will grant to the service account user.
Warehouse:
The name of the data warehouse you will give us access to.
Choose Key Pair Authentication
Select Key Pair as the authentication method.
Copy the Public Key
Select Star generates a pair of keys: a public key and a private key.
The public key will be displayed on the screen along with a copy button. Use this button to copy the public key.
This public key is required for creating a user in Snowflake.
You can leave the form open, as you’ll return to it to complete the connection details after creating the Snowflake user.
Use the ACCOUNTADMIN
role and run the following SQL in your Snowflake instance. Replace <PUBLIC_KEY>
with the copied public key from Select Star.
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.
Complete the Setup in Select Star Once the role has been created in Snowflake, return to Select Star to complete the setup.
Fill in the Authentication Details Provide the following information:
Authentication:
You already selected Key Pair authentication.
Username:
The name of the service account user you created earlier. In the example above, it is selectstar
Test the Connection and Proceed
Once all fields are filled, click Next to proceed.
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.