Skip to main content

Amazon Athena - Automatic Data Lineage

What to expect​

Views​

Dataedo uses the built-in PostgresSQL Parser to analyze script of Amazon Athena views, and build column-level lineage from objects queried on a table to view basis.

Athena view lineage

File to Table​

Dataedo builds object-level lineage between S3 files and Athena tables.

Athena file lineage

Known Limitations​

  1. Check the limitations for views lineage from PostgreSQL parser

Troubleshooting​

I can't see data lineage for views​

  1. Make sure you have selected the right SQL dialect - in this case, PostgreSQL (SQL Dialect field at Data Source level).
  2. Rerun import of the source - maybe the schema was imported in an older version or the configuration was incorrect.

I can't see data lineage from file to tables​

  1. Make sure you have imported right files for lineage
  2. Check if path used in table creation script is same as path in imported file
Last updated on
On this page
Questions?
If you have any questions or need assistance, feel free to reach out to the Dataedo support team.
Dataedo support
Dataedo is an end-to-end data governance solution for mid-sized organizations.
Data Lineage • Data Quality • Data Catalog
Release notesArchiveRoadmapSupport
LinkedInYouTube