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
See CONTRIBUTING for more information.
This library is licensed under the MIT-0 License. See the LICENSE file.