Amazon Athena

CHOOSE IT WHEN

What job does it solve?

Data can be queried in place and intermittent or ad hoc analysis does not justify a continuously running warehouse.

DO NOT CONFUSE IT WITH

Where does it stop?

The workload needs transactional serving, durable transformation, or sustained modeled warehouse concurrency.

COMPARE NEXT

Closely related services

• Amazon S3Durable object storage for data addressed by bucket and object key rather than as a mounted disk.
• AWS GlueServerless data integration with a data catalog and managed extract-transform-load capabilities.
• Amazon RedshiftManaged columnar data warehousing for analytical SQL over large datasets.

IN THIS COURSE

Lessons that mention it

• Lesson 33Transformation, processing, and governed data lakes
• Lesson 34Analytics serving and visualization strategy
• Lesson 41Database type, capacity, and cache economics

OFFICIAL AWS SOURCE

Verify and go deeper