Modeling Objects
CData Tableau Connector for Amazon Athena Data Model
The connector 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 connector 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 connector 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.