Running queries and work with query results and output files in Amazon Athena - DevOps Monitoring Dashboard on AWS

Running queries and work with query results and output files in Amazon Athena

You can run SQL queries using Amazon Athena to directly query the table and views created by the solution. For details about these table and views, refer to Database schema information and Build visualizations with Amazon Athena and Tableau. Query results are stored as CSV files in the metrics S3 bucket under the prefix, athena_query_output. You can also download query result files directly from the Amazon Athena console.

Note

This solution implements data partition and parquet data storage for performance optimization and cost reduction. When running your own queries, we recommend that you use the created_at (timestamp) partition key. For more information, refer to Performance tuning in Athena in the Amazon Athena User Guide.