Supported SQL statements

This topic provides an overview of Collibra Data Lineage-supported SQL statements and the expected lineage results, per data source type. Be sure to check back from time to time, as we continue to add documentation for more data source types.

Note The example images are from the classic Technical lineage viewer UI. The latest viewer UI displays elements differently. For more information about the latest and classic Technical lineage viewer UI, go to Technical lineage viewer.

Things to keep in mind

When creating technical lineage for JDBC data sources via a "JDBC connection", lineage is not generated for tables created with CREATE TABLE AS SELECT statements. With JDBC connection method, SQL statements that create tables are not harvested; therefore, lineage can't be generated. If, however, you connect via one of the following methods, the SQL statements are analyzed and lineage can be generated:

  • Folder connection (CLI lineage harvester (deprecated))
  • Shared Storage connection (Edge)
  • Cloud Storage connection (Edge)

When working with stored procedures and user-defined functions, we create several instances of the objects involved to avoid incorrect lineage. This is required to separate the lineage between different invocations. To identify these unique instances, we add an ID to the end of the objects.