Improve reusability and security using Amazon Athena parameterized queries

This is a repository for Improve reusability and security using Amazon Athena parameterized queries blog. It contains a CloudFormation template for provisioning accompanying resources and a Python command line script to list all available Athena prepared statements across AWS Regions using AWS SDK.

athena-prepared-statements.yaml creates the following resources:

• AWS Glue Data Catalog Database for storing metadata tables
• AWS Glue Data Catalog Table definition with Amazon.com customer reviews
• Amazon Athena Workgroup

list-prepared-statements.py script requires the following:

• AWS SDK for Python (Boto3)
• AWS CLI credentials with the following IAM permissions:
  • ec2:DescribeRegions
  • athena:ListWorkGroups
  • athena:ListPreparedStatements

Security

See CONTRIBUTING for more information.

License

This library is licensed under the MIT-0 License. See the LICENSE file.