IBM Db2 LUW - Automatic Data Lineage

Wojtek Bialek - Dataedo Team Wojtek Bialek 17th July, 2024

What to Expect

Views

Dataedo analyzes SQL of database views with built in SQL Parser and builds column-level lineage from tables/views queried by view to the view.

View lineage

Learn more about Transact-SQL SQL parser

Known Limitations

Check the limitations for views lineage from SQL parser

Troubleshooting

I don't see data lineage for views

  1. Make sure you have selected right SQL dialect - in this case Transact-SQL (SQL Dialect field at Data Source level).
  2. Rerun import of the source - maybe schema was imported in older version or configuration was incorrect.