Technical lineage for Snowflake ingestion methods

Collibra Data Lineage creates a technical lineage for Snowflake by using SQL mode Snowflake ingestion or SQL-API mode Snowflake ingestion.

Ingestion method	Details
SQL mode Snowflake ingestion	The lineage harvester creates a column-level technical lineage based on columns and views.
SQL-API mode Snowflake ingestion	The lineage harvester creates a column-level technical lineage based on Snowflake schemas and the access history. With this ingestion method, the technical lineage can provide insights on sensitive data flow, including the lineage of stored procedures.

If you use the lineage harvester to create technical lineage, use the mode property in the lineage harvester configuration file to indicate which ingestion method you want to use.

For more information about the supported queries and transformation, go to Supported transformation details.

For more information about Snowflake, go to Snowflake Documentation.