SSIS Components for Amazon Athena

Build 24.0.9060

EncryptionType

Specifies the encryption option for query results in Athena.

Possible Values

None, SSE_S3, SSE_KMS, CSE_KMS

Data Type

string

Default Value

"None"

Remarks

Specifies the encryption option for query results in Athena. This option is required if you have configured Amazon Athena to encrypt query results; Set EncryptionType and EncryptionKey if you would like to encrypt the result set stored in S3 after query execution. Note that setting these properties does not encrypt the result set in S3StagingDirectory.

To encrypt Amazon Athena query results, follow the following steps:

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060