TDV Adapter for Amazon Athena

Build 22.0.8462

Modeling Objects

Amazon Athena Adapter Data Model

The adapter dynamically extracts all relevant schema information from Amazon Athena via the REST API.

Discovering Schemas

By default, all Amazon Athena entities will be exposed as views. However, the adapter is also capable of dividing object types into the following types from the Amazon Athena API :

  • TABLE
  • VIEW
  • EXTERNAL_TABLE
  • MANAGED_TABLE
  • VIRTUAL_VIEW

You can enable this functionality by setting MetadataDiscoveryMethod to Glue. This method will require you to also add the necessary IAM profiles for the user.

Alternatively, you can use the Athena discovery method, though this method is slower.

  • MetadataDiscoveryMethod: Set this to Athena.
  • IncludeTableTypes: Set this to True.

Note that while the adapter can break Amazon Athena objects into these types, they are all considered to be read-only. Reconnect to load any changes in the metadata, such as added or removed columns or changes in data type.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462