Athena

Introduction

• Serverless SQL queries on top of your data in S3, pay per query, output to S3.

• Supports CSV, JSON, Parquet, ORC

• Queries are logged in CloudTrail (which can be chained with CloudWatch logs)

• Great for sporadic queries

  • If need to "Join", use Redshift Spectrum.

• Ready-to-use queries for VPC Flow logs, CloudTrail, ALB Access Logs, cost and usage reports (billing), etc.

Quicksight + Athena architecture example

Quicksight + Athena architecture example