How to reduce bill for Athena

0 votes
Are there methods using which I can reduce the bill for using Athena? What should be the good practice for doing it? Can someone help?
Jan 17, 2019 in AWS by Anjali
• 2,950 points
721 views

1 answer to this question.

0 votes

You can save almost 90% on your query costs by compressing, partitioning, and converting your data into columnar formats. This will also increase the performance. Each of these operations reduces the amount of data Amazon Athena needs to scan to execute a query. Amazon Athena supports Apache Parquet and ORC, two of the most popular open-source columnar formats. You can see the amount of data scanned per query, on the Athena console.

Basically compressing and partitioning are the methods one should follow to reduce the billing amount. There is another method but not always effective i.e. Converting it into Columnar formats.

Hope you got the answer you were looking for.

answered Jan 17, 2019 by Edureka
• 4,220 points

Related Questions In AWS

0 votes
1 answer

How to create Athena tables for dynamic S3 paths using AWS Crawler?

The simplest and most efficient way to ...READ MORE

answered Feb 16, 2022 in AWS by anonymous
1,074 views
0 votes
3 answers
+1 vote
3 answers

How to get ARN for s3 Bucket using aws cli .

An ARN is a non-opaque, constructible identifier, ...READ MORE

answered Aug 16, 2018 in AWS by Priyaj
• 58,100 points
5,569 views
0 votes
1 answer

How to Enable CORS for an AWS API Gateway Resource

Since you're using Lambda Proxy integration for ...READ MORE

answered Jul 10, 2018 in AWS by Hammer
• 360 points
4,009 views
0 votes
1 answer

Pivot rows into columns in AWS Athena?

You can use the following method :- It ...READ MORE

answered Oct 29, 2018 in AWS by Priyaj
• 58,100 points
8,146 views
0 votes
1 answer

Connect AWS Athena to an existing Hive Metastore

Athena works only with its own metastore ...READ MORE

answered Nov 16, 2018 in AWS by Jino
• 5,820 points
1,685 views
0 votes
1 answer

How to update or insert data using Athena?

Athena is a query language and as ...READ MORE

answered Jan 17, 2019 in AWS by Edureka
• 4,220 points
12,010 views
0 votes
1 answer

How to delete / drop multiple tables in AWS athena?

It is not possible to run multiple ...READ MORE

answered Jan 17, 2019 in AWS by Edureka
• 4,220 points
8,085 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP