DJames617 AWS Service
Amazon Athena
Athena runs serverless SQL queries against data in S3 using table metadata from a catalog.
What This Service Solves
Athena runs serverless SQL queries against data in S3 using table metadata from a catalog.
- Use Athena for ad hoc SQL over S3, log analysis, and data-lake exploration without provisioning a warehouse.
When You Should Not Use It
- Avoid Athena for high-concurrency warehouse workloads or workloads needing persistent optimized compute.
What AWS Manages and What You Manage
AWS manages query infrastructure. You manage data layout, catalog, permissions, workgroups, and query cost controls.
Security Implications
Use IAM, Lake Formation, KMS, workgroup controls, and least-privilege S3 access.
Availability and Scaling
Data remains in S3. Catalog and permission configuration determine usability.
Partitioning, compression, columnar formats, and file sizing control performance.
Cost Behavior
Athena charges by data scanned. Parquet, compression, and partitions reduce cost.
Common Integrations
- S3
- Glue Data Catalog
- Lake Formation
- CloudTrail logs
- QuickSight
How AWS Might Present It
Certification-Specific Depth
Data Engineer Associate
Know configuration choices, integrations, failure modes, security, operations, and cost tradeoffs.
Related Comparisons
Sources and Review Metadata
This independent training application is not affiliated with or endorsed by Amazon Web Services. AWS, Amazon Web Services, and AWS certification names are trademarks of Amazon.com, Inc. or its affiliates.