Easy ReviewCLF-C02
Cloud Technology and Services1

Athena

Query S3 logs and external sources with SQL, scoped permissions, and selective data scans.

Athena SQL reads S3 data through table definitions. Partition filters, columnar formats, and file sizes determine how much work a query performs; permissions and workgroups control access and query behavior.

Athena basics

Amazon Athena runs SQLA language for selecting and aggregating data through tables. queries on data where it sits in Amazon S3.

How it works

  1. Point Athena at data in S3.
  2. Define a table over it.
  3. Run SQL queries.

Exam cues

  • If the question says query data in S3 with SQL, think Athena.

Remember

  • Standard SQL on S3 data.

Trap: Athena queries data in place; a data warehouse with loaded data is Amazon Redshift.

From the AWS docs (1)
  • Amazon Athena is an interactive query service that analyzes data directly in Amazon S3 with standard SQL.

Flashcards

tap to flip
Answer

·

All 1 cards as a list

Analysts want to run SQL on log files in Amazon S3 without loading them into a database. Which service fits?

Amazon Athena.

You finished every topic of CLF-C02!

Your badge turned gold. Next step: book the exam on AWS. Once you pass, add yourself to Who passed.

Share

Share that you finished this certification

I finished every topic of AWS Certified Cloud Practitioner (CLF-C02) on Easy Review. Come study too!