Amazon Redshift - Automatic Data Lineage

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

1. Check the limitations for views lineage from PostgreSQL parser

Troubleshooting

I don't see data lineage for views

1. Make sure you have selected right SQL dialect - in this case PostgreSQL (SQL Dialect field at Data Source level).
2. 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

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.