What is Amazon Athena?

Amazon Athena is an interactive serverless service used to analyze data directly in Amazon Simple Storage Service using standard SQL ad-hoc queries.

Pricing Details:-

1. Charges are applied based on the amount of data scanned by each query at standard S3 rates for storage, requests, and data transfer.
2. Canceled queries are charged based on the amount of data scanned.
   1. No charges are applied for Data Definition Language (DDL) statements. 4.Charges are applied for canceled queries also based on the amount of data scanned.
3. Additional costs can be reduced if data gets compressed, partitioned, or converted into a columnar format.

Functions of Athena:

1. It helps to analyze different kinds of data (unstructured, semi-structured, and structured) stored in Amazon S3.

2. Using Athena, ad-hoc queries can be executed using ANSI SQL without actually loading the data into Athena.

3. It can be integrated with Amazon Quick Sight for data visualization and helps to generate reports with business intelligence tools.

4. It can be integrated with the AWS Glue Data Catalog to store metadata in Amazon S3 and offers data discovery features of AWS Glue.

5. It helps to connect SQL clients with a JDBC or an ODBC driver.

6. It executes multiple queries in parallel, so no need to worry about compute resources.

7. It supports various standard data formats, such as CSV, JSON, ORC,Avro, and Parquet.