JDBC Driver for Amazon Athena

Build 21.0.7930

Data Model

The driver 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 driver is also capable of breaking down 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 driver 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930