MySQL - Automatic Data Lineage

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.

(/data-sources/sql-parser/mysql-parsing)

Known 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 the right SQL dialect - in this case MySQL

2. Rerun import of the source - maybe the schema was imported in an older version or the 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 the schema was imported in an older version or the configuration was incorrect