Athena.md

Amazon Athena

• Return to table of contents

• Useful Links:

  • Querying AWS Service Logs
  • Sample OSM Athena queries
  • Planet OSM
  • OpenStreetMap's planet dataset

• Exam Tips:

  • Uses schema on read technology.
  • Totally serverless.
  • Pay for what you read.
  • Doesn't alter source data.
  • Supported data formats:
    • XML
    • JSON
    • CSV
    • TSV
    • AVRO
    • ORC
    • PARQUET
  • Use cases:
    • Queries where loading/transformation isn't desired.
    • Occasional / Ad-hoc queries on data in S3.
    • Serverless querying scenarios - cost conscious.
    • Querying AWS logs - VPC flow logs, CloudTrail, ELB logs, cost reports.
    • AWS Glue Data Catalog and web server logs.
    • Using Athena Federated Query you can use other data sources.