Analytics - Athena

Question 1

What is Athena?

Answer 1

Serverless, easy function used to analyze data in S3 using SQL

Question 2

What can I do with Athena?

Answer 2

Analyze structured and unstructured data sets using ANSI SQL without the need to aggregate or load data into Athena

Question 3

What which structured data sets can Athena process?

Answer 3

CSV, JSON, Avro, Apache Parquet or ORC

Question 4

How do I get started with Athena?

Answer 4

log into the AWS Management console and create a schema using DDL statements on the console or using the create table wizard.

Question 5

How can Athena be accessed?

Answer 5

AWS Management Console, an API, ODBC, or JDBC

Question 6

What is the underlying technology behind Athena?

Answer 6

Presto with full SQL support

Question 7

How does Athena store table definitions and schema?

Answer 7

uses a data catalog to store info about the tables and databases you create for your data store in S3.

Question 8

What is AWS Glue?

Answer 8

A fully managed ETL service, data catalog. It is not available in all regions.

Question 9

What does Glue ETL allow you to do?

Answer 9

transform and move to various destinations, automatically scan your data sources, identify data formats and infers schemas and stores metadata about databases and tables in S3

Question 10

What is the difference between Athena, EMR and Redshift?

Answer 10

Redshift provides fastest query performance for enterprise reporting and business workloads. EMR is a simple and cost effective method of running distributed frameworks like Hadoop, Spark when compared to on premise. Athena provides the easiest way to un ad-hoc queries for data in S3 without servers.

Question 11

What is partioning?

Answer 11

allows you to restrict the amount of data scanned by each query, thus improving performance and reducing cost. Data can be partitioned by any key.

Question 12

What are queries?

Answer 12

Athena retains query history for 45 days in S3. Many types of logs and geospatial data can be queried. Supports INTEGER, DOUBLE, VARCHAR, MAPS, ARRAY AND STRUCT data types.

Question 13

How is Athena secured?

Answer 13

IAM policies, access control lists, and S3 bucket policies. Queries can be performed on encrypted S3 data

Question 14

Pricing?

Answer 14

you only pay for queries that you run and amount of data scanned by each query. Not charged for failed queries. Compressing, partitioning, or converting your data to a columnar format.

Question 15

Availability?

Answer 15

Because Athena uses S3, it highly available and executes