aws-athena

Start a query execution

$ aws athena start-query-execution --query-string "[SELECT * FROM table LIMIT 10]" --work-group [primary]

$ aws athena start-query-execution --query-string "[SELECT * FROM logs]" --result-configuration OutputLocation=s3://[bucket/results/]

$ aws athena get-query-execution --query-execution-id [query-id]

$ aws athena get-query-results --query-execution-id [query-id]

$ aws athena list-query-executions --work-group [primary]

$ aws athena start-query-execution --query-string "CREATE DATABASE [mydb]" --work-group [primary]

$ aws athena list-databases --catalog-name AwsDataCatalog

aws athena command [options]

aws athena manages Amazon Athena, an interactive query service for analyzing data in Amazon S3 using standard SQL. Athena is serverless, requiring no infrastructure setup.
Queries are executed asynchronously via start-query-execution, which returns a query execution ID. Use get-query-execution to check status and get-query-results to retrieve results once complete. Results are also stored in the specified S3 output location.
Workgroups organize queries and control settings like result locations, encryption, and query limits. The --query-execution-context parameter specifies which database and data catalog to query against.
Athena uses the AWS Glue Data Catalog to store table metadata, or you can use an external Hive metastore. Tables are created over data in S3 using DDL statements like CREATE EXTERNAL TABLE.

start-query-execution

Execute a SQL query asynchronously

Get information about a query execution

Retrieve results of a completed query

Cancel a running query

List query execution IDs

List databases in a data catalog

List tables in a database

Create a workgroup for queries

Get workgroup configuration

SQL statement to execute

Identifier of query execution

Workgroup to run the query in

Database and catalog context (Database=db,Catalog=catalog)

Output location and encryption settings (OutputLocation=s3://path/)

Maximum results to return

Queries are charged based on data scanned; use partitioning and columnar formats (Parquet, ORC) to reduce costs. Query results expire after a configured period. Long-running queries may timeout. Requires appropriate IAM permissions for S3 data access and Glue catalog.

Amazon Athena was launched in November 2016 as a serverless query service based on Presto. It enables SQL queries on S3 data without provisioning infrastructure. Athena integrates with AWS Glue for schema discovery and supports ANSI SQL with extensions for nested data types common in analytics workloads.

aws(1), aws-s3(1), aws-glue(1)