search
Get Started
search
zoom_in Click to enlarge

Amazon Web Services (AWS) Athena

language

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.

Reviews & Comments

Write a Review

rate_review

Be the first to review

Share your thoughts with the community and help others make better decisions.

Save to your list

Save your favorites and follow how their scores change over time.

Save favorites
Track changes
Compare scores

Already have an account? Sign in

Compare Items

See how they stack up against each other

Comparing
VS
Select 1 more item to compare