• Contents:

Amazon Athena Generic Overview

• Check section in AWS SAA-C03:

Amazon Athena 101

• 💡 Will only include notes on new details and insights!

Intro to Amazon Athena

Ref: https://www.udemy.com/course/aws-certified-machine-learning-engineer-associate-mla-c01/learn/lecture/46730209

• 🔧 Serverless, interactive SQL-like query service

• Presto under the hood

• Supported compression formats: Snappy, Zlib, LZO, Gzip

• Integrations

  • Notebooks: Jupyter, Apache Zeppelin, RStudio
  • Visualization tools
    • QuickSight
    • Other tools integration via ODBC/JDBC

• Many formats supported:

  Athena-supported data format	Human readable?	Columnar?	Splittable?
  CSV, TSV	Yes	No	No
  JSON	Yes	No	No
  ORC	No	Yes	Yes
  Parquet	No	Yes	Yes
  Avro	No	No	Yes

Athena Features

Ref: https://www.udemy.com/course/aws-certified-machine-learning-engineer-associate-mla-c01/learn/lecture/46730253

Athena Workgroups

• 🔧 Organize or segregate Athena usage
  • e.g. users/teams/apps/workloads…