Using boto3 and paginators to query an AWS Athena table and return the results as a list of tuples as specified by .fetchall in PEP 249 - fetchall_athena.py
What is AWS Athena? AWS Athena is a code-free, fully automated, zero-admin, data pipeline that performs database automation, Parquet file conversion, table creation, Snappy compression, partitioning, and more. It is an interactive query service to analyze Amazon S3 data using standard SQL.
Aws athena example
Name of the S3 staging directory, for example, s3://aws-athena-query-results-123456785678-us-eastexample-2/ Amazon Web Services (AWS) access keys (access key ID and secret access key). For more information, see Access keys on the AWS website. (Optional) Initial SQL statement to run every time Tableau connects
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.
SELECT os, COUNT (*) count FROM cloudfront_logs WHERE date BETWEEN date '2014-07-05' AND date '2014-08-05' GROUP BY os; For more examples, see Querying Data in Amazon Athena Tables. Escaping Single Quotes. To escape a single quote, precede it with another single quote, as in the following example.