Fine-Tuning Data Access
Customizing Amazon Athena Behavior
Follow the steps below to configure the add-in 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.
Flattening Nested Objects and Arrays
The add-in is capable of flattening array elements and object properties into columns. See the pages for FlattenArrays and FlattenObjects for more information.
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:
- Navigate to Amazon Athena Console.
- Click Settings.
- Enable the Encrypt Query Results option.
- Select the Encryption type and set EncryptionType when you connect.
- 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.