Use this connector to have Foundational scan and determine lineage and downstream impact for Snowflake.
This setup should take about 7 minutes.
Permissions: You need to be a Snowflake admin for some parts of this setup.
Create a role in Snowflake for Foundational, and assign it to Foundational user
This can be done by downloading the permissions script from our connector page
Click on Add new Snowflake account
Fill the connector form and click on Download Snowflake Script
Account URL: This is the URL you use to access Snowflake. It follows this format:
https://<Snowflake-Account-Id>.snowflakecomputing.comWarehouse Name: The name of the warehouse you used in the script
Ingestion Role: The name of the role that was created in the script
User name: The name of the user that was created in the script
Include Data Observability permissions: Should data observability permissions be included in the script. This will add data access to the relevant databases
Include Iceberg tables lineage tracking: Should upstream ingestion permissions for Iceberg tables be included in the script. This will give data access to Iceberg tables (however, we'll only ingest metadata from it)
Why do we ask for these permissions?
DB level
OBJECT_VIEWER,USAGE_VIEWERandGOVERNANCE_VIEWERare required to extract lineage from your snowflake database.DB level
usageand table/schema levelreferencespermissions allow us to extract more detailed schema definitionsWarehouse
operateandusageare needed for us to run queries that extract these pieces of information
After done - run the configuration script in your Snowflake account - and you're set!