Amazon Athena

aid: amazon-athena
name: Amazon Athena
description: >-
  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.
type: Index
image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
tags:
  - Amazon Athena
  - SQL
  - Analytics
  - Serverless
  - AWS
url: https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/apis.yml
created: '2024-01-15'
modified: '2026-05-19'
specificationVersion: '0.19'
apis:
  - aid: amazon-athena:amazon-athena-api
    name: Amazon Athena API
    description: >-
      REST management API for Amazon Athena covering query executions, named queries, work groups, data catalogs,
      databases, table metadata, and prepared statements.
    image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
    humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html
    baseURL: https://athena.us-east-1.amazonaws.com
    tags:
      - Amazon Athena
      - SQL
      - Analytics
      - Serverless
      - AWS
    properties:
      - type: OpenAPI
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/openapi/amazon-athena-openapi.yml
      - type: SpectralRules
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/rules/amazon-athena-spectral-rules.yml
      - type: Vocabulary
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/vocabulary/amazon-athena-vocabulary.yaml
      - type: JSONSchema
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/json-schema/athena-query-execution-schema.json
      - type: JSONSchema
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/json-schema/athena-named-query-schema.json
      - type: JSONSchema
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/json-schema/athena-work-group-schema.json
      - type: JSONStructure
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/json-structure/athena-query-execution-structure.json
      - type: JSONStructure
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/json-structure/athena-work-group-structure.json
      - type: JSONLD
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/json-ld/amazon-athena-context.jsonld
      - type: Example
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json
      - type: Example
        url: >-
          https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json
common:
  - type: Features
    data:
      - 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
  - type: UseCases
    data:
      - 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
  - type: Integrations
    data:
      - Amazon S3
      - AWS Glue
      - Amazon QuickSight
      - AWS Lake Formation
      - Amazon CloudWatch
      - AWS IAM
      - Amazon DynamoDB
      - AWS Step Functions
      - Amazon SageMaker
      - Apache Spark
maintainers:
  - FN: Kin Lane
    email: [email protected]