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
- Point Athena at data in S3.
- Define a table over it.
- 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.
Flashcards
Nada para revisar aqui agora. Escolha outros tópicos ou outro filtro.
·
Todos os 1 flashcards em lista
Analysts want to run SQL on log files in Amazon S3 without loading them into a database. Which service fits?
Amazon Athena.