From the course: AWS Certified Machine Learning Engineer - Associate (MLA-C02) Cert Prep

Unlock this course with a free trial

Join today to access over 26,500 courses taught by industry experts.

What is Amazon Athena?

What is Amazon Athena?

From the course: AWS Certified Machine Learning Engineer - Associate (MLA-C02) Cert Prep

Start my 1-month free trial Buy for my team

What is Amazon Athena?

“

Amazon Athena is a serverless interactive query service that lets you run standard SQL directly against data in Amazon S3. There's no load step involved. You define a table that points to your S3 data, write a select statement, and Athena returns the results. Because it's serverless, there's nothing to provision or manage, and Athena automatically scales the compute needed to run queries in parallel. Athena uses a schema on read approach. It applies the schema when it reads the data without modifying or rewriting the underlying files. That means you're free to choose the format that makes sense for your workload. Athena supports CSV, PSV, JSON, Apache Avro, ORC, Parquet, and Amazon Ion. The format you choose has a direct impact on cost because Athena charges based on the amount of data it scans. The less data Athena has to read, the less you pay. Table definitions are stored in the AWS Glue Data Catalog. The catalog contains information such as the schema, column data types, and the…

Contents