Fine-Tuning Data Access
Customizing Amazon Athena Behavior
Follow the steps below to configure the adapter defaults for querying Amazon Athena.
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:
- 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.