Configuring Query Result Encryption

You can configure the Simba Athena ODBC Driver to encrypt your query results using any of the encryption protocols that Athena supports.

You can set the connection properties described below in a connection string or in a DSN (in the odbc.ini file). Settings in the connection string take precedence over settings in the DSN.

To configure query result encryption:

  1. Set the S3OutputEncOption property to one of the following values.

    2. Note:

    For detailed information about these encryption options, see "Configuring Encryption Options" in the Amazon Athena User Guide: http://docs.aws.amazon.com/athena/latest/ug/encryption.html.

    Option Name Description

    NOT_SET

    The connector does not encrypt the data.

    SSE_S3

    The connector uses server-side encryption with an Amazon S3-managed key.

    SSE_KMS

    The connector uses server-side encryption with an AWS KMS-managed key.

    CSE_KMS

    The connector uses client-side encryption with an AWS KMS-managed key.
  2. If you specified SSE_KMS or CSE_KMS in the previous step, then set the S3OutputEncKMSKey property to the KMS customer key to use for encrypting data.

Related topics