{"repo":"aws-samples/amazon-athena-queries-via-aws-lambda-cdk","free":true,"listed":false,"github":"https://github.com/aws-samples/amazon-athena-queries-via-aws-lambda-cdk","clone":"git clone https://github.com/aws-samples/amazon-athena-queries-via-aws-lambda-cdk.git","description":null,"language":"TypeScript","stars":13,"topics":["amazon-athena","analytics","aws-cdk","aws-lambda","query","serverless"],"license":"MIT-0","category":"analytics","readme_excerpt":"Amazon Athena Queries via AWS Lambda CDK This architecture showcases how Amazon Athena SQL queries can be executed via AWS Lambda using the Boto3 API. Additionally, this architecture can be fully deployed using AWS CDK and is designed to fit into a larger serverless architecture. The CDK stack configures and deploys a Lambda function with the appropriate IAM permissions to make Athena SQL queries on an S3 bucket. The query results can then be found in an S3 output bucket specified by the user. This architecture can be used if Athena queries need to be run on a regular, scheduled basis. Prerequistes and limitations Prerequistes - An active AWS account - An Amazon Simple Storage Service (Amazon S3) with pre-existing data - Data to be queried by Athena should be available in an S3 bucket. - Amazon S3 data is cataloged via AWS Glue - This can be done using a Glue crawler. For more information regarding this, refer to Using AWS Glue to connect to data sources in Amazon S3 from the Amazon Athena documentation. - Default output S3 bucket for Amazon Athena has been set - Before running any queries in Athena, an output S3 bucket location in the same region must be set in Athena settings. For more information regarding this, refer to Specifying a query result location from the Amazon Athena documentation. - Amazon Athena workgroup - If you do not have an existing Athena workgroup to use for querying, follow Setting up workgroups from the Amazon Athena documentation. We recommend using ","default_branch":null,"files":null,"tree":[],"storefront":"/r/aws-samples","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/aws-samples/amazon-athena-queries-via-aws-lambda-cdk/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}