Amazon Athena Connector

Back Next

Mappings and mapping tasks with Amazon Athena Connector

Mappings and
mapping
tasks with Amazon Athena Connector

Use the

Data Integration

Mapping Designer to create a mapping. When you create a mapping, you can configure a source to represent the object.

Amazon Athena source features

When you configure the advanced source properties, configure properties specific to Amazon Athena.

The following list shows the Amazon Athena source features that you can use in mappings:

Server-side encryption

Server-side encryption with KMS

Client-side encryption with KMS

Filter

Sort

Data Preview

Table name override

Schema name override

Data encryption in Amazon Athena sources

You can run queries in Amazon Athena on encrypted data in Amazon S3. You must run the Amazon Athena queries in the region where Amazon S3 is hosted. You can also encrypt the query results in Amazon S3.

Select the type of the encryption in the

Encryption Type

field under the Amazon Athena advanced source properties.

Use the customer master key ID generated by AWS Key Management Service for server-side encryption.

You can configure the following types of encryption:

None: The data is not encrypted.
SSE-S3: If you select the
SSE-S3
encryption type, Amazon Athena encrypts the file using the Amazon S3-managed key for server-side encryption.
SSE-KMS: If you select the
SSE-KMS
encryption type, Amazon Athena encrypts the file using the AWS KMS-managed key or Amazon Resource Name (ARN) for server-side encryption.
CSE-KMS: If you select the
CSE-KMS
encryption type, Amazon Athena encrypts the file using the AWS KMS-managed key for client-side encryption.