My account Book a demo

MySQL - Automatic Data Lineage

Wojtek Bialek - Dataedo Team Wojtek Bialek 11th April, 2024
Applies to: Dataedo 23.x versions, Article available also for: 24.x (current)
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

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.

Column-level lineage

Kown Limitations

  1. Check the limitations for views lineage from MySQL parser

Troubleshooting

I don't see data lineage for views

  1. Make sure you have selected right SQL dialect - in this case MySQL
  2. Rerun import of the source - maybe schema was imported in older version or configuration was incorrect

Cross database lineage is not built

  1. Make sure the source object has Linked Source with correctly assigned database
  2. Rerun import of the source - maybe schema was imported in older version or configuration was incorrect
Contact support Report issue