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 deliveryModel: model: unknown open_source: false commercial: false callable_host: true label: Delivery model not determined — needs a product licence on record confidence: low source: - openapi generated: '2026-08-28' method: derived accessModel: pricing: free onboarding: self-serve trial: false try_now: true public: false label: Free · Self-serve signup confidence: medium source: - plans - authentication - security generated: '2026-09-03' method: derived image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/amazon-athena.png 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-09-16' specificationVersion: '0.23' apis: - aid: amazon-athena:amazon-athena-data-catalogs-api name: Amazon Athena Data Catalogs API description: Operations for managing data catalogs humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Data Catalogs properties: - type: OpenAPI url: openapi/amazon-athena-data-catalogs-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-databases-api name: Amazon Athena Databases API description: Operations for listing databases in a data catalog humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Database tags_raw: - Databases properties: - type: OpenAPI url: openapi/amazon-athena-databases-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-named-queries-api name: Amazon Athena Named Queries API description: Operations for creating and managing saved SQL queries humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Named Queries properties: - type: OpenAPI url: openapi/amazon-athena-named-queries-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-prepared-statements-api name: Amazon Athena Prepared Statements API description: Operations for managing prepared SQL statements humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Prepared Statements properties: - type: OpenAPI url: openapi/amazon-athena-prepared-statements-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-query-executions-api name: Amazon Athena Query Executions API description: Operations for running and managing SQL query executions humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Query Executions properties: - type: OpenAPI url: openapi/amazon-athena-query-executions-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-table-metadata-api name: Amazon Athena Table Metadata API description: Operations for listing and getting table metadata humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Table Metadata properties: - type: OpenAPI url: openapi/amazon-athena-table-metadata-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-tags-api name: Amazon Athena Tags API description: Operations for managing resource tags humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Tags properties: - type: OpenAPI url: openapi/amazon-athena-tags-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-work-groups-api name: Amazon Athena Work Groups API description: Operations for managing Athena work groups humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Workgroups tags_raw: - Work Groups properties: - type: OpenAPI url: openapi/amazon-athena-work-groups-api-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: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-query-execution-example.json - type: Examples url: >- https://raw.githubusercontent.com/api-evangelist/amazon-athena/refs/heads/main/examples/athena-named-query-example.json - aid: amazon-athena:amazon-athena-calculation-execution-api name: Amazon Athena Athena Calculation Execution API description: >- The Athena Calculation Execution API from Amazon Athena — 4 operation(s) for athena calculation execution. humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Athena Calculation Execution properties: - type: OpenAPI url: openapi/amazon-athena-calculation-execution-api-openapi.yml - aid: amazon-athena:amazon-athena-capacity-reservation-api name: Amazon Athena Athena Capacity Reservation API description: >- The Athena Capacity Reservation API from Amazon Athena — 6 operation(s) for athena capacity reservation. humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Athena Capacity Reservation properties: - type: OpenAPI url: openapi/amazon-athena-capacity-reservation-api-openapi.yml - aid: amazon-athena:amazon-athena-notebook-api name: Amazon Athena Athena Notebook API description: The Athena Notebook API from Amazon Athena — 5 operation(s) for athena notebook. humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Athena Notebook properties: - type: OpenAPI url: openapi/amazon-athena-notebook-api-openapi.yml - aid: amazon-athena:amazon-athena-notebook-metadata-api name: Amazon Athena Athena Notebook Metadata API description: >- The Athena Notebook Metadata API from Amazon Athena — 3 operation(s) for athena notebook metadata. humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Athena Notebook Metadata properties: - type: OpenAPI url: openapi/amazon-athena-notebook-metadata-api-openapi.yml - aid: amazon-athena:amazon-athena-operations-api name: Amazon Athena Athena Operations API description: The Athena Operations API from Amazon Athena — 17 operation(s) for athena operations. humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Athena Operations properties: - type: OpenAPI url: openapi/amazon-athena-operations-api-openapi.yml - aid: amazon-athena:amazon-athena-session-api name: Amazon Athena Athena Session API description: The Athena Session API from Amazon Athena — 3 operation(s) for athena session. humanURL: https://docs.aws.amazon.com/athena/latest/APIReference/Welcome.html baseURL: https://athena.us-east-1.amazonaws.com tags: - Athena Session properties: - type: OpenAPI url: openapi/amazon-athena-session-api-openapi.yml common: - type: CapabilityMap url: capabilities/amazon-athena-capability-edges.yml name: Amazon Athena Business Capability Map - type: Plans url: plans/amazon-athena-plans-pricing.yml - type: RateLimits url: rate-limits/amazon-athena-rate-limits.yml - type: FinOps url: finops/amazon-athena-finops.yml - type: Website url: https://aws.amazon.com/athena/ - type: AgenticAccess url: agentic-access/amazon-athena-agentic-access.yml - type: VulnerabilityDisclosure url: security/amazon-athena-vulnerability-disclosure.yml - type: DomainSecurity url: security/amazon-athena-domain-security.yml - type: Authentication url: authentication/amazon-athena-authentication.yml - 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: kin@apievangelist.com x-parent: amazon-web-services x-relationship: product