MySQL - Automatic Data Lineage

Wojtek Bialek - Dataedo Team Wojtek Bialek 11th April, 2024
Applies to: Dataedo 23.x (current) versions, Article available also for: 24.x

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
Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.