What to expect
Views
Dataedo analyzes SQL of Redshift views with built in PostgreSQL Parser and builds column-level lineage from tables/views queried by view to the view.
Learn more about PostgreSQL parser
External Tables
Dataedo build object-level lineage between Redshift External Tables and objects from other databases based on LinkedSources. Dataedo will automatically assign linked source to appropriate objects, however user also can pick it manually.
Known Limitations
Troubleshooting
I don't see data lineage for views
- Make sure you have selected right SQL dialect - in this case PostgreSQL (SQL Dialect field at Data Source level).
- Rerun import of the source - maybe schema was imported in older version or configuration was incorrect.
I don't see data lineage for external tables
- Make sure the source object has Linked Source with correctly assigned database
- Rerun import of the source - maybe schema was imported in older version or configuration was incorrect.