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

This is a beta feature .

A public beta is an upcoming feature or product that is made available to all customers before it is fully ready for general availability so it can be tested and evaluated early. Learn more

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.

SQL-API mode Snowflake ingestion supports the Data Manipulation Language (DML) statements from the following sources:

  • Using a driver
  • Direct login
  • Stored procedures
  • Streams
  • The COPY INTO DML command

SQL-API mode Snowflake ingestion does not support Snowpipes and Data Definition Language (DDL) queries.

Use the mode property in the lineage harvester configuration file to indicate which ingestion method you want to use.

For more information about technical lineage beta programs, go to Lineage harvester integrations available in beta.

For more information about Snowflake, go to Snowflake Documentation.