Amazon Athena | Pricing & Billing Flashcards

1
Q

Can I provide cross-account access to someone else’s S3 bucket?

Pricing & Billing

Amazon Athena | Analytics

A

Yes, you can provide cross-account access to Amazon S3.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How is Amazon Athena priced?

Pricing & Billing

Amazon Athena | Analytics

A

Amazon Athena is priced per query and charges based on the amount of data scanned by the query. You can store data in a variety of formats on Amazon S3. If you compress your data, partition, or convert it to columnar storage formats, you pay less because you scan less data. Converting data to the columnar format allows Athena to read only the columns it needs to process the query. Please see the Athena pricing page for more details

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Why do I get charged less when I use a columnar format?

Pricing & Billing

Amazon Athena | Analytics

A

Amazon Athena charges you for the amount of data scanned per query. Compressing your data allows Amazon Athena to scan less data. Converting your data to columnar formats allows Athena to selectively read only required columns to process the data. Partitioning your data also allows Athena to restrict the amount of data scanned. This leads to cost savings and improved performance. See pricing example for details.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do I lower my costs?

Pricing & Billing

Amazon Athena | Analytics

A

You can save 30%-90% on your query costs and get better performance by compressing, partitioning, and converting your data into columnar formats. 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Does Amazon Athena charge me for failed queries?

Pricing & Billing

Amazon Athena | Analytics

A

No, you are not charged for failed queries.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Does Amazon Athena charge me for cancelled queries?

Pricing & Billing

Amazon Athena | Analytics

A

Yes, if you cancel a query manually, you are charged for the amount of data scanned up to the point at which you cancelled the query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Are there any additional charges associated with Amazon Athena?

Pricing & Billing

Amazon Athena | Analytics

A

Amazon Athena queries data directly from Amazon S3, so your source data is billed at S3 rates. When Amazon Athena runs a query, it stores the results in an S3 bucket of your choice and you are billed at standard S3 rates for these result sets. We recommend you monitor these buckets and use lifecycle policies to control how much data gets retained.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly