Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Column level lineage has limitations due to the variety and complexity of SQL dialects. See Known limitations below for currently known limitationspage currently gaps with Column level lineage.

...

Enabling column level lineage

...

To trigger this column lineage job, go to Settings → Batch Manager and select QUERY_LINEAGE

...

Known limitations

...

Limitation

...

Fixed in Release

SQL code that is not wrapped in a CREATE… statement.

This is common in DBT code used on Redshift

...

Under investigation

...

Create statements that use a CTE (WITH) inside the create statement

...

Under investigation

...

Lineage from subsequent table in a union where select * is used.

For example, the table A’s column level lineage is processed however table B’s columns are not.

e.g (SELECT * FROM A UNION SELECT * FROM B)

...

...