Learn everything you need to get started with Amazon Athena, or discover new best practices that can help you improve performance and reduce costs. Browse through our library of blogs, ebooks, webinars and videos to find answers to your most pressing questions about Athena and the related ecosystem.
Thank you! One of our data experts will be reaching out to you.
Amazon Athena is a serverless, interactive query service that reads data directly from Amazon S3 object storage. It is based on the open-source Apache Presto, but offered exclusively as a managed service by Amazon Web Services. Athena allows you to analyze very high volumes of data using ANSI-SQL, without the need to manage infrastructure.
Unlike a traditional database, Athena doesn’t store data in rest – storage is done entirely on S3, while the compute resources needed to return results for a query are provisioned automatically by AWS. Pricing follows a similar logic and based on terabytes of data scanned ($5 per terabyte).
Read more about the benefits of Athena compared to traditional databases.
Generally speaking, Athena can be relevant whenever you want to query data stored on Amazon S3. Common scenarios include:
Streaming data is challenging in unique ways. See how to build efficient data pipelines that enable you to query event streams in Athena:
Athena reads data directly from Amazon S3, and the way data is stored on S3 can have a dramatic impact on how much value you get from Athena. Discover best practices around partitioning, compaction and file formats to learn how to optimize your data for analytic consumption.
Check out our handy guides to learn how to make your Athena queries run faster.
See real-life examples and reference architectures to see how companies are using Amazon Athena to analyze large volumes of data.
Discover the 6 crucial guidelines to prepare your data for Athena in this free webinar.
Learn how to avoid common pitfalls, reduce costs and ensure high performance.
Partibest practices you need to know in order to optimize your analytics infrastructure. Get the Guide »
Enforce GDPR and other regulatory compliance by keeping track of all user records in your lake