CData Python Connector for Amazon Athena

Build 21.0.7929

Fine-Tuning Data Access

Customizing Amazon Athena Behavior

Follow the steps below to configure the provider 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7929