Amazon Athena can now query encrypted data on Amazon S3; adds support for LZO-compression, and performance improvements to JDBC driver
You can now use Amazon Athena to query encrypted data stored in Amazon S3. You can query data that’s encrypted using Server-Side Encryption with Amazon S3-Managed Encryption Keys, Server-Side Encryption with AWS Key Management Service (KMS) – Managed Keys, and Client-Side Encryption with keys managed by KMS. Amazon Athena also integrates with KMS and provides you an option to encrypt your result sets. To use this feature via the JDBC driver, you will need to download the latest version of the driver. The new JDBC driver has improved performance, support for cancelling queries and several bug fixes.
You can now use Amazon Athena to query encrypted data stored in Amazon S3. You can query data that’s encrypted using Server-Side Encryption with Amazon S3-Managed Encryption Keys, Server-Side Encryption with AWS Key Management Service (KMS) – Managed Keys, and Client-Side Encryption with keys managed by KMS. Amazon Athena also integrates with KMS and provides you an option to encrypt your result sets. To use this feature via the JDBC driver, you will need to download the latest version of the driver. The new JDBC driver has improved performance, support for cancelling queries and several bug fixes.
Amazon Athena also added support for querying data in Amazon S3 that has been LZO-compressed. In addition, you can now add, replace, and rename columns via Alter Table commands.
Please visit the Amazon Athena release notes to learn more.