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