Amazon Athena to Amazon S3 Express One Zone

Amazon Athena → AWS Glue → Amazon S3

How to query Amazon S3 Express One Zone directory bucket using Amazon Athena.

Catalog the Amazon S3 Express One Zone directory bucket using AWS Glue Data Catalog.
Upload your data to Amzon S3 Express One Zone storage.
Query the data using Amazon Athena.

< Back to all patterns

GitHub icon Download this pattern (.zip)

GitHub icon View this pattern on GitHub


Clone repo

git clone https://github.com/aws-samples/serverless-patterns/cd serverless-patterns/athena-glue-s3-sam

Deploy

sam deploy --guided


Testing

See the GitHub repo for detailed testing instructions.

Cleanup

Delete the Amazon S3 Input Express One Zone bucket content: aws s3 rm s3://{MyInputBucketExpressOneZone} --recursive --region {my-region}
Delete the Amazon S3 Output Express One Zone bucket content: aws s3 rm s3://{MyOutputBucketExpressOneZone} --recursive --region {my-region}
Delete the stack: sam delete.

Created by:

Biswanath Mukherjee

Biswanath Mukherjee

Sr. Solutions Architect working at AWS India.

Follow on LinkedIn