Amazon Athena support

Applies to: Dataedo 23.x versions, Article available also for: 24.x (current), 10.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

Dataedo introduces native connector to Amazon Athena. Amazon Athena is a query engine on Amazon Web Services. It is unique in a way that it provides access to AWS Glue Data Catalog, which holds metadata from various AWS services.

Connector features

Data catalog

Dataedo documents metadata of following objects:

  • Tables
  • Views

Using Athena connector you can extract metadata from:

Image title

Data lineage

Dataedo does not support data lineage for Amazon Athena.

Data profiling

Dataedo does not support profiling for Amazon Athena.

How to connect

Provide connection details:

  1. AWS Region - AWS region in which Athena reside.
  2. Access Token - IAM user access key ID.
  3. Secret Token - IAM user secret key.
  4. Data Catalog - Data catalog (athena data source) you want to connect to.
  5. Workgroup - Athena workgroup
  6. Database - Athena database.

connection details

To configure AWS services check detailed connection instruction.

Connector specification

Supported versions

Dataedo Athena connector was tested with Athena Engine version 2. Athena Engine version 1 is not officially supported.

Tested data catalogs

  • S3 - Aws Glue Data Catalog
  • Amazon DynamoDB
  • Amazon DocumentDB
  • Amazon CloudWatch
  • Amazon CloudWatch Metrics

Imported objects

Object Imported as
Table Table
View View

Tables metadata

Metadata Imported as
Name Name
Columns Name
   Name Name
   Data type Data type
   Position Position
   Nullable Nullable
   Description Description
   Default value Default value

Views metadata

Metadata Imported as
Name Name
Script Script
Columns Name
   Name Name
   Data type Data type
   Position Position
   Nullable Nullable