Amazon Web Services (AWS): Athena: Points to remember

Let's learn about Amazon Athena:

  1. Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL.

  2. Athena is serverless, so there is no infrastructure to setup or manage & user can start analyzing data immediately.

  3. Athena uses Presto with full standard SQL support and works with a variety of standard data formats, including CSV, JSON, ORC, Apache Parquet and Avro.

  4. Users can use Athena to generate reports or to explore data with business intelligence tools or SQL clients, connected via an ODBC or JDBC driver.

  5. Athena can be accessed via the AWS Management Console, an API or an ODBC or JDBC driver.

  6. Athena can handle complex analysis, including large joins, window functions and arrays.

  7. User can invoke their SageMaker machine learning models in an Athena SQL query to run inference.

  8. With User-Defined Functions (UDFs), users can now write their own functions in Java and invoke them in Athena SQL query.

  9. Users can connect Athena to their external Apache Hive Metastore.

  10. Athena uses Apache Hive DDL to define tables.

  11. Athena supports compressed data in Snappy, Zlib, LZO and GZIP formats.

  12. Athena supports both simple data types such as INTEGER, DOUBLE, VARCHAR and complex data types such as MAPS, ARRAY and STRUCT.

  13. Users can run ANSI-Compliant SQL SELECT statements to query their data in Amazon S3.

  14. Athena uses SerDes (Serializer/Deserializer) to interpret the data read from Amazon S3.

  15. Parquet and ORC files created via Spark can be read in Athena.

Image retrieved from:

  1. Athena allows users to partition their data on any column.

  2. Athena integrates with Amazon QuickSight, allowing users to easily visualize their data stored in Amazon S3.

  3. Athena has open sourced data source connectors to Apache HBase, Amazon DocumentDB, Amazon DynamoDB and Amazon CloudWatch Logs and CloudWatch Metrics.

  4. All Athena query results are stored in an Amazon S3 location that user set.

  5. Athena allows users to control access to their data by using AWS IAM policies, Access Control Lists (ACLs) and Amazon S3 bucket policies.

  6. Athena integrates with KMS and provides users an option to encrypt their result sets.

  7. Athena is priced per query and charges based on the amount of data scanned by the query.

  8. Users can save 30%-90% on their query costs and get better performance by compressing, partitioning & converting their data into columnar formats.

  9. Users are not charged for failed queries.

  10. If user cancel a query manually, they are charged for the amount of data scanned up to the point at which they cancelled the query.

A Points to remember series by Piyush Jalan.