Amazon Athena
#168 · Level 3 · Modern architecture · Data and analyticsConcept
Section titled “Concept”With Amazon Athena you can ask SQL questions directly on files stored in S3 — no database or server needed. The files can be in formats like CSV, JSON or Parquet. The description of which file belongs to which table is usually kept in the AWS Glue Data Catalog. Athena gets the computing it needs by itself when it runs a query, so there is nothing to keep running. With connectors, you can also query data sources outside S3.
Simple example
Section titled “Simple example”Standing in the library and asking questions and getting answers, without taking the books out.
Why it’s needed
Section titled “Why it’s needed”Building a separate database just to analyze data takes time and money.
Where it’s used
Section titled “Where it’s used”Analyzing log files, quick queries on a data lake, occasional reports.
Azure equivalent
Section titled “Azure equivalent”Azure Synapse serverless SQL / Fabric
Learn more
Section titled “Learn more”For details and the latest information, see the official documentation: