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 in AWS by Anjali
• 2,930 points
44 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 by Edureka
• 4,180 points

Related Questions In AWS

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
• 56,940 points
1,595 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
823 views
0 votes
1 answer
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
• 56,940 points
1,052 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,560 points
437 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 in AWS by Edureka
• 4,180 points
695 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 in AWS by Edureka
• 4,180 points
791 views