SSIS Components for Amazon Athena

Build 20.0.7656

Data Model

The component 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 component is also capable of breaking down object types into the following types from the Amazon Athena API :

  • TABLE
  • 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 component 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656