Amazon Athena website screenshot

Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

1 APIs 10 Features
Amazon AthenaSQLAnalyticsServerless

APIs

Amazon Athena API

REST management API for Amazon Athena covering query executions, named queries, work groups, data catalogs, databases, table metadata, and prepared statements.

Collections

Pricing Plans

Rate Limits

Amazon Athena Rate Limits

2 limits

RATE LIMITS

FinOps

Features

Serverless SQL query execution against Amazon S3 data
Pay-per-query pricing with no infrastructure management
Support for standard ANSI SQL with complex joins and window functions
Integration with AWS Glue Data Catalog for schema management
Named queries for saving and reusing SQL statements
Work groups for query isolation and cost management
Prepared statements for parameterized query execution
Multiple data format support including Parquet, ORC, JSON, CSV
Query result caching for improved performance and cost reduction
Fine-grained access control with IAM and Lake Formation

Use Cases

Analyze log files and clickstream data stored in S3
Run ad-hoc SQL queries on data lake without ETL
Build serverless data pipelines and reporting solutions
Query AWS service logs including CloudTrail, ELB, and VPC Flow Logs
Perform cost analysis on AWS Cost and Usage Reports
Enable self-service analytics for business intelligence teams

Integrations

Amazon S3
AWS Glue
Amazon QuickSight
AWS Lake Formation
Amazon CloudWatch
AWS IAM
Amazon DynamoDB
AWS Step Functions
Amazon SageMaker
Apache Spark

Semantic Vocabularies

Amazon Athena Context

11 classes · 0 properties

JSON-LD

API Governance Rules

Amazon Athena API Rules

19 rules · 12 errors 7 warnings

SPECTRAL

JSON Structure

Athena Athena Error Structure

0 properties

JSON STRUCTURE

Athena Batch Get Named Query Input Structure

0 properties

JSON STRUCTURE

Athena Batch Get Named Query Output Structure

0 properties

JSON STRUCTURE

Athena Column Info Structure

0 properties

JSON STRUCTURE

Athena Column Structure

0 properties

JSON STRUCTURE

Athena Create Data Catalog Input Structure

0 properties

JSON STRUCTURE

Athena Create Data Catalog Output Structure

0 properties

JSON STRUCTURE

Athena Create Named Query Input Structure

0 properties

JSON STRUCTURE

Athena Create Named Query Output Structure

0 properties

JSON STRUCTURE

Athena Create Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Create Work Group Output Structure

0 properties

JSON STRUCTURE

Athena Data Catalog Structure

0 properties

JSON STRUCTURE

Athena Data Catalog Summary Structure

0 properties

JSON STRUCTURE

Athena Database Structure

0 properties

JSON STRUCTURE

Athena Datum Structure

0 properties

JSON STRUCTURE

Athena Delete Data Catalog Input Structure

0 properties

JSON STRUCTURE

Athena Delete Data Catalog Output Structure

0 properties

JSON STRUCTURE

Athena Delete Named Query Input Structure

0 properties

JSON STRUCTURE

Athena Delete Named Query Output Structure

0 properties

JSON STRUCTURE

Athena Delete Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Delete Work Group Output Structure

0 properties

JSON STRUCTURE

Athena Encryption Configuration Structure

0 properties

JSON STRUCTURE

Athena Engine Version Structure

0 properties

JSON STRUCTURE

Athena Get Data Catalog Input Structure

0 properties

JSON STRUCTURE

Athena Get Data Catalog Output Structure

0 properties

JSON STRUCTURE

Athena Get Database Input Structure

0 properties

JSON STRUCTURE

Athena Get Database Output Structure

0 properties

JSON STRUCTURE

Athena Get Named Query Input Structure

0 properties

JSON STRUCTURE

Athena Get Named Query Output Structure

0 properties

JSON STRUCTURE

Athena Get Prepared Statement Input Structure

0 properties

JSON STRUCTURE

Athena Get Query Execution Input Structure

0 properties

JSON STRUCTURE

Athena Get Query Execution Output Structure

0 properties

JSON STRUCTURE

Athena Get Query Results Input Structure

0 properties

JSON STRUCTURE

Athena Get Query Results Output Structure

0 properties

JSON STRUCTURE

Athena Get Table Metadata Input Structure

0 properties

JSON STRUCTURE

Athena Get Table Metadata Output Structure

0 properties

JSON STRUCTURE

Athena Get Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Get Work Group Output Structure

0 properties

JSON STRUCTURE

Athena List Data Catalogs Input Structure

0 properties

JSON STRUCTURE

Athena List Data Catalogs Output Structure

0 properties

JSON STRUCTURE

Athena List Databases Input Structure

0 properties

JSON STRUCTURE

Athena List Databases Output Structure

0 properties

JSON STRUCTURE

Athena List Named Queries Input Structure

0 properties

JSON STRUCTURE

Athena List Named Queries Output Structure

0 properties

JSON STRUCTURE

Athena List Query Executions Input Structure

0 properties

JSON STRUCTURE

Athena List Query Executions Output Structure

0 properties

JSON STRUCTURE

Athena List Table Metadata Input Structure

0 properties

JSON STRUCTURE

Athena List Table Metadata Output Structure

0 properties

JSON STRUCTURE

Athena List Tags For Resource Input Structure

0 properties

JSON STRUCTURE

Athena List Work Groups Input Structure

0 properties

JSON STRUCTURE

Athena List Work Groups Output Structure

0 properties

JSON STRUCTURE

Athena Named Query Structure

0 properties

JSON STRUCTURE

Athena Prepared Statement Structure

0 properties

JSON STRUCTURE

Athena Prepared Statement Summary Structure

0 properties

JSON STRUCTURE

Athena Query Execution Context Structure

0 properties

JSON STRUCTURE

Athena Query Execution Statistics Structure

0 properties

JSON STRUCTURE

Athena Query Execution Status Structure

0 properties

JSON STRUCTURE

Athena Query Execution Structure

0 properties

JSON STRUCTURE

Athena Query Runtime Statistics Structure

0 properties

JSON STRUCTURE

Athena Query Stage Plan Node Structure

0 properties

JSON STRUCTURE

Athena Query Stage Structure

0 properties

JSON STRUCTURE

Athena Result Configuration Structure

0 properties

JSON STRUCTURE

Athena Result Configuration Updates Structure

0 properties

JSON STRUCTURE

Athena Result Set Metadata Structure

0 properties

JSON STRUCTURE

Athena Result Set Structure

0 properties

JSON STRUCTURE

Athena Row Structure

0 properties

JSON STRUCTURE

Athena Start Query Execution Input Structure

0 properties

JSON STRUCTURE

Athena Start Query Execution Output Structure

0 properties

JSON STRUCTURE

Athena Stop Query Execution Input Structure

0 properties

JSON STRUCTURE

Athena Stop Query Execution Output Structure

0 properties

JSON STRUCTURE

Athena Table Metadata Structure

0 properties

JSON STRUCTURE

Athena Tag Resource Input Structure

0 properties

JSON STRUCTURE

Athena Tag Resource Output Structure

0 properties

JSON STRUCTURE

Athena Tag Structure

0 properties

JSON STRUCTURE

Athena Unprocessed Named Query Id Structure

0 properties

JSON STRUCTURE

Athena Untag Resource Input Structure

0 properties

JSON STRUCTURE

Athena Untag Resource Output Structure

0 properties

JSON STRUCTURE

Athena Update Work Group Input Structure

0 properties

JSON STRUCTURE

Athena Update Work Group Output Structure

0 properties

JSON STRUCTURE

Athena Work Group Configuration Structure

0 properties

JSON STRUCTURE

Athena Work Group Structure

0 properties

JSON STRUCTURE

Athena Work Group Summary Structure

0 properties

JSON STRUCTURE

Example Payloads

Athena Athena Error Example

3 fields

EXAMPLE

Athena Column Example

3 fields

EXAMPLE

Athena Column Info Example

3 fields

EXAMPLE

Athena Data Catalog Example

3 fields

EXAMPLE

Athena Database Example

3 fields

EXAMPLE

Athena Datum Example

3 fields

EXAMPLE

Athena Named Query Example

3 fields

EXAMPLE

Athena Query Stage Example

3 fields

EXAMPLE

Athena Result Set Example

3 fields

EXAMPLE

Athena Row Example

3 fields

EXAMPLE

Athena Tag Example

3 fields

EXAMPLE

Athena Work Group Example

3 fields

EXAMPLE

Sources

Raw ↑
opencollection: 1.0.0
info:
  name: Amazon Athena API
  version: '2017-05-18'
request:
  auth:
    type: apikey
    key: Authorization
    value: '{{Authorization}}'
    placement: header
items:
- info:
    name: Query Executions
    type: folder
  items:
  - info:
      name: Amazon Athena Start Query Execution
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=StartQueryExecution
      body:
        type: json
        data: '{}'
    docs: Runs the SQL query statements contained in the query string. Requires you to have access to the workgroup in which
      the query ran.
  - info:
      name: Amazon Athena Stop Query Execution
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=StopQueryExecution
      body:
        type: json
        data: '{}'
    docs: Stops a query execution. Requires you to have access to the workgroup in which the query ran.
  - info:
      name: Amazon Athena Get Query Execution
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetQueryExecution
      body:
        type: json
        data: '{}'
    docs: Returns information about a single execution of a query if you have access to the work group in which the query
      ran.
  - info:
      name: Amazon Athena Batch Get Query Execution
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=BatchGetQueryExecution
      body:
        type: json
        data: '{}'
    docs: Returns the details of a single query execution or a list of up to 50 query executions, which you provide as an
      array of query execution ID strings.
  - info:
      name: Amazon Athena List Query Executions
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListQueryExecutions
      body:
        type: json
        data: '{}'
    docs: Provides a list of available query execution IDs for the queries in the specified workgroup.
  - info:
      name: Amazon Athena Get Query Results
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetQueryResults
      body:
        type: json
        data: '{}'
    docs: Streams the results of a single query execution specified by QueryExecutionId from the Athena query results location
      in Amazon S3.
  - info:
      name: Amazon Athena Get Query Runtime Statistics
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetQueryRuntimeStatistics
      body:
        type: json
        data: '{}'
    docs: Returns query execution runtime statistics related to a single execution of a query if you have access to the workgroup
      in which the query ran.
- info:
    name: Named Queries
    type: folder
  items:
  - info:
      name: Amazon Athena Create Named Query
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=CreateNamedQuery
      body:
        type: json
        data: '{}'
    docs: Creates a named query in the specified workgroup. Requires that you have access to the workgroup.
  - info:
      name: Amazon Athena Delete Named Query
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=DeleteNamedQuery
      body:
        type: json
        data: '{}'
    docs: Deletes the named query if you have access to the workgroup in which the query was saved.
  - info:
      name: Amazon Athena Get Named Query
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetNamedQuery
      body:
        type: json
        data: '{}'
    docs: Returns information about a single query. Requires that you have access to the workgroup in which the query was
      saved.
  - info:
      name: Amazon Athena List Named Queries
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListNamedQueries
      body:
        type: json
        data: '{}'
    docs: Provides a list of available query IDs only for queries saved in the specified workgroup.
  - info:
      name: Amazon Athena Batch Get Named Query
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=BatchGetNamedQuery
      body:
        type: json
        data: '{}'
    docs: Returns the details of a single named query or a list of up to 50 queries, which you provide as an array of query
      ID strings.
- info:
    name: Work Groups
    type: folder
  items:
  - info:
      name: Amazon Athena Create Work Group
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=CreateWorkGroup
      body:
        type: json
        data: '{}'
    docs: Creates a workgroup with the specified name. A workgroup can contain one or more named queries or scheduled queries.
  - info:
      name: Amazon Athena Delete Work Group
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=DeleteWorkGroup
      body:
        type: json
        data: '{}'
    docs: Deletes the workgroup with the specified name. The primary workgroup cannot be deleted.
  - info:
      name: Amazon Athena Get Work Group
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetWorkGroup
      body:
        type: json
        data: '{}'
    docs: Returns information about the workgroup with the specified name.
  - info:
      name: Amazon Athena Update Work Group
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=UpdateWorkGroup
      body:
        type: json
        data: '{}'
    docs: Updates the workgroup with the specified name. The workgroup's name cannot be changed.
  - info:
      name: Amazon Athena List Work Groups
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListWorkGroups
      body:
        type: json
        data: '{}'
    docs: Lists available workgroups for the account.
- info:
    name: Data Catalogs
    type: folder
  items:
  - info:
      name: Amazon Athena Create Data Catalog
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=CreateDataCatalog
      body:
        type: json
        data: '{}'
    docs: Creates (registers) a data catalog with the specified name and properties. Catalogs created are visible to all users
      of the same AWS account.
  - info:
      name: Amazon Athena Delete Data Catalog
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=DeleteDataCatalog
      body:
        type: json
        data: '{}'
    docs: Deletes a data catalog.
  - info:
      name: Amazon Athena Get Data Catalog
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetDataCatalog
      body:
        type: json
        data: '{}'
    docs: Returns the specified data catalog.
  - info:
      name: Amazon Athena List Data Catalogs
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListDataCatalogs
      body:
        type: json
        data: '{}'
    docs: Lists the data catalogs in the current AWS account.
- info:
    name: Databases
    type: folder
  items:
  - info:
      name: Amazon Athena List Databases
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListDatabases
      body:
        type: json
        data: '{}'
    docs: Lists the databases in the specified data catalog.
  - info:
      name: Amazon Athena Get Database
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetDatabase
      body:
        type: json
        data: '{}'
    docs: Returns a database object for the specified database and data catalog.
- info:
    name: Table Metadata
    type: folder
  items:
  - info:
      name: Amazon Athena List Table Metadata
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListTableMetadata
      body:
        type: json
        data: '{}'
    docs: Lists the metadata for the tables in the specified data catalog database.
  - info:
      name: Amazon Athena Get Table Metadata
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetTableMetadata
      body:
        type: json
        data: '{}'
    docs: Returns table metadata for the specified catalog, database, and table.
- info:
    name: Prepared Statements
    type: folder
  items:
  - info:
      name: Amazon Athena Create Prepared Statement
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=CreatePreparedStatement
      body:
        type: json
        data: '{}'
    docs: Creates a prepared statement for use with SQL queries in Athena.
  - info:
      name: Amazon Athena Delete Prepared Statement
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=DeletePreparedStatement
      body:
        type: json
        data: '{}'
    docs: Deletes the prepared statement with the specified name from the specified workgroup.
  - info:
      name: Amazon Athena Get Prepared Statement
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=GetPreparedStatement
      body:
        type: json
        data: '{}'
    docs: Retrieves the prepared statement with the specified name from the specified workgroup.
  - info:
      name: Amazon Athena List Prepared Statements
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListPreparedStatements
      body:
        type: json
        data: '{}'
    docs: Lists the prepared statements in the specified workgroup.
- info:
    name: Tags
    type: folder
  items:
  - info:
      name: Amazon Athena Tag Resource
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=TagResource
      body:
        type: json
        data: '{}'
    docs: Adds one or more tags to an Athena resource. A tag is a label that you assign to an AWS Athena resource.
  - info:
      name: Amazon Athena Untag Resource
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=UntagResource
      body:
        type: json
        data: '{}'
    docs: Removes one or more tags from a resource.
  - info:
      name: Amazon Athena List Tags For Resource
      type: http
    http:
      method: POST
      url: https://athena.us-east-1.amazonaws.com/?Action=ListTagsForResource
      body:
        type: json
        data: '{}'
    docs: Lists the tags associated with an Athena resource.
bundled: true