TDV Adapter for Amazon Athena

Build 21.0.8160

Fine-Tuning Data Access

Customizing Amazon Athena Behavior

Follow the steps below to configure the adapter defaults for querying Amazon Athena.

Using QueryPassthrough

Amazon Athena supports a set of queries that are not specified in the regular SQL-92 standard; to execute these queries simply set QueryPassthrough to true. This will pass the query directly to Amazon Athena without parsing it internally.

Encrypting Query Results to S3

Set EncryptionKey and EncryptionType if you would like to encrypt the result set stored in S3 after query execution.

To encrypt results stored in S3, follow the steps below:

  1. Navigate to Amazon Athena Console.
  2. Click Settings.
  3. Enable the Encrypt Query Results option.
  4. Select the Encryption type and set EncryptionType when you connect.
  5. If you selected SSE-KMS or CSE-KMS, set both EncryptionType and EncryptionKey: select an encryption key in the menu or click Create KMS Key.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8160