description Amazon Web Services (AWS) Athena Overview
Athena is a serverless interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. It supports real-time analysis and integrates seamlessly with AWS services, making it ideal for businesses requiring flexible and cost-effective big data analytics.
help Amazon Web Services (AWS) Athena FAQ
How does Amazon Athena query files in Amazon S3?
Athena lets users define a schema and run standard SQL directly against data stored in S3. It can use the AWS Glue Data Catalog, an external Hive metastore, or federated connectors for other data sources.
Does Amazon Athena require an EC2 cluster?
No, Athena is a serverless query service, so users do not provision or manage an EC2 cluster for ordinary SQL queries. AWS runs the query infrastructure and charges according to the data scanned.
When would I use Amazon Athena instead of Amazon Redshift?
Athena is useful for on-demand analysis of files already stored in Amazon S3 without maintaining a warehouse cluster. Amazon Redshift is a separate data warehouse service intended for persistent, repeatable workloads and managed warehouse storage.
explore Explore More
Similar to Amazon Web Services (AWS) Athena
See all arrow_forwardformat_list_numbered Lists featuring Amazon Web Services (AWS) Athena
Reviews & Comments
Write a Review
Be the first to review
Share your thoughts with the community and help others make better decisions.