How AI is applied across API Evangelist and APIs.io. Read my AI disclosure →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC
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.

agent aware

Limited machine-readable signal and partial portal coverage — documentation a human can read, but little a machine or agent can consume without scraping.

Kin Score

API Evangelist profiles Amazon Athena the way a machine reads it — 349 machine-readable artifacts across 1 API, pulled from the provider's own public surface and indexed so a developer, an analyst, or an AI agent can evaluate it against every other provider on the network.

Every provider in the network is reduced to the same set of machine-readable artifacts — OpenAPI contracts, event specifications, GraphQL schemas, runnable collections, pricing and rate-limit signals, security posture, OAuth scopes, and the agent surfaces (MCP servers and skills) that let software drive the API on its own. We profile them because the interface is the part of a company you can actually inspect: it is a truer signal of what a provider does than any marketing page. From those artifacts we compute the Kin Score — Amazon Athena scores 38.1/100 (thin), with a separate agent-readiness read of 25/100 (agent aware). The full breakdown is below, followed by every artifact we hold — each card links through to its machine-readable definition on apis.io.

Kin Score

This is the API Evangelist rating — a single, repeatable read computed from the artifacts on this page. Green fill is points earned; the red track is points possible, so every bar shows earned-versus-possible at a glance. Every facet and dimension name is a link: it opens that measurement's page on APIs.io, where the rating runs across the whole catalog — the exact checks that feed it, how every profiled provider distributes on it, and who is at the top of it.

Kin Score Kin Score How this is scored →
scored 2026-09-10 · rubric v0.20.0
Amazon Athena Kin Score — API readiness rating by API Evangelist

Put this on your own site. The badge is drawn live from Amazon Athena's current Kin Score — paste it once and it updates itself every time the score is recomputed. It follows your visitor's light or dark setting, and it links back here so anyone who sees it can read the full breakdown.

<!-- Kin Score · API Evangelist -->
<a href="https://providers.apievangelist.com/providers/amazon-athena/"
   title="Amazon Athena on API Evangelist — API profile and Kin Score">
  <img src="https://apis.io/badge/amazon-athena.svg"
       alt="Amazon Athena Kin Score — API readiness rating by API Evangelist" width="150" height="150" loading="lazy">
</a>

More shapes, themes and sizes → · Score as JSON · How badges work

How we profile Amazon Athena

Each block below is one kind of artifact we hold for Amazon Athena. For each we say what it is and why it earns a place in the profile, then list every one we've indexed — capped at two rows, scroll within the panel for the rest.

APIs 8

Each API is captured as its own OpenAPI definition — every operation, parameter, and response. This is the single most useful machine-readable description of what an API does, and it's what lets us score, lint, mock, and generate against it without asking the provider for anything.

Individual APIs this provider publishes, each with its own machine-readable definition.

Amazon Athena Data Catalogs API

Operations for managing data catalogs

Amazon Athena Databases API

Operations for listing databases in a data catalog

Amazon Athena Named Queries API

Operations for creating and managing saved SQL queries

Amazon Athena Prepared Statements API

Operations for managing prepared SQL statements

Amazon Athena Query Executions API

Operations for running and managing SQL query executions

Amazon Athena Table Metadata API

Operations for listing and getting table metadata

Amazon Athena Tags API

Operations for managing resource tags

Amazon Athena Work Groups API

Operations for managing Athena work groups

Scroll within the panel for all 8 ·

Open Collections 10

Open, tool-agnostic collections carry the same runnable value as Postman without locking you to one client — the portable, forkable form of the same exercise.

Open, tool-agnostic API collections (OpenAPI-derived and Bruno).

Scroll within the panel for all 10 ·

Pricing Plans 1

Pricing is part of the interface. Machine-readable plans tell you what a tier costs and includes before you commit — one of the things the Kin Score reads for access clarity — renamed from commercial clarity in rubric 0.12, because a free statutory interface has access terms and no commercial ones.

Published pricing tiers and plan structures.

Rate Limits 1

Rate limits are the difference between a demo that works and a production integration that doesn't fall over. Publishing them is an operational-transparency signal — and a hard requirement for any agent that plans its own throughput.

Documented rate limits and quota policies.

Amazon Athena Rate Limits

2 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals let a buyer model the financial operations of an API before it's live. We profile them for the same reason we profile pricing: the money is part of the contract.

Cost, billing, and metering signals for API financial operations.

Features 10

The notable capabilities this provider advertises, captured as structured features so they can be searched and compared instead of read one landing page at a time.

Notable capabilities this provider offers.

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

Scroll within the panel for all 10 ·

Semantic Vocabularies 1

JSON-LD contexts give the data shared meaning across APIs. We profile them because semantics are what let a machine reconcile 'customer' here with 'customer' somewhere else.

JSON-LD contexts and semantic vocabularies used across these APIs.

Amazon Athena Context

11 classes · 0 properties

JSON-LD

Spectral Rules 2

Governance rulesets we run against this provider's specs — the automated checks behind parts of the score. Profiling them makes the quality bar explicit and re-runnable, not a matter of opinion.

Amazon Athena API Rules

6 rules · 5 warnings

SPECTRAL

Amazon Athena API Rules

26 rules · 13 errors · 13 warnings

SPECTRAL

JSON Schema 99

Standalone JSON Schema definitions describe the data models behind the API. We profile them so the shapes are validatable on their own — useful long after a single request is forgotten.

Standalone JSON Schema definitions for this provider's data models.

Amazon Athena Query Execution

11 properties

JSON SCHEMA

AthenaError

0 properties

JSON SCHEMA

BatchGetNamedQueryInput

0 properties

JSON SCHEMA

BatchGetNamedQueryOutput

0 properties

JSON SCHEMA

BatchGetQueryExecutionInput

0 properties

JSON SCHEMA

BatchGetQueryExecutionOutput

0 properties

JSON SCHEMA

ColumnInfo

0 properties

JSON SCHEMA

Column

0 properties

JSON SCHEMA

CreateDataCatalogInput

0 properties

JSON SCHEMA

CreateDataCatalogOutput

0 properties

JSON SCHEMA

CreateNamedQueryInput

0 properties

JSON SCHEMA

CreateNamedQueryOutput

0 properties

JSON SCHEMA

CreatePreparedStatementInput

0 properties

JSON SCHEMA

CreatePreparedStatementOutput

0 properties

JSON SCHEMA

CreateWorkGroupInput

0 properties

JSON SCHEMA

CreateWorkGroupOutput

0 properties

JSON SCHEMA

DataCatalog

0 properties

JSON SCHEMA

DataCatalogSummary

0 properties

JSON SCHEMA

Database

0 properties

JSON SCHEMA

Datum

0 properties

JSON SCHEMA

DeleteDataCatalogInput

0 properties

JSON SCHEMA

DeleteDataCatalogOutput

0 properties

JSON SCHEMA

DeleteNamedQueryInput

0 properties

JSON SCHEMA

DeleteNamedQueryOutput

0 properties

JSON SCHEMA

DeletePreparedStatementInput

0 properties

JSON SCHEMA

DeletePreparedStatementOutput

0 properties

JSON SCHEMA

DeleteWorkGroupInput

0 properties

JSON SCHEMA

DeleteWorkGroupOutput

0 properties

JSON SCHEMA

EncryptionConfiguration

0 properties

JSON SCHEMA

EngineVersion

0 properties

JSON SCHEMA

GetDataCatalogInput

0 properties

JSON SCHEMA

GetDataCatalogOutput

0 properties

JSON SCHEMA

GetDatabaseInput

0 properties

JSON SCHEMA

GetDatabaseOutput

0 properties

JSON SCHEMA

GetNamedQueryInput

0 properties

JSON SCHEMA

GetNamedQueryOutput

0 properties

JSON SCHEMA

GetPreparedStatementInput

0 properties

JSON SCHEMA

GetPreparedStatementOutput

0 properties

JSON SCHEMA

GetQueryExecutionInput

0 properties

JSON SCHEMA

GetQueryExecutionOutput

0 properties

JSON SCHEMA

GetQueryResultsInput

0 properties

JSON SCHEMA

GetQueryResultsOutput

0 properties

JSON SCHEMA

GetQueryRuntimeStatisticsInput

0 properties

JSON SCHEMA

GetQueryRuntimeStatisticsOutput

0 properties

JSON SCHEMA

GetTableMetadataInput

0 properties

JSON SCHEMA

GetTableMetadataOutput

0 properties

JSON SCHEMA

GetWorkGroupInput

0 properties

JSON SCHEMA

GetWorkGroupOutput

0 properties

JSON SCHEMA

ListDataCatalogsInput

0 properties

JSON SCHEMA

ListDataCatalogsOutput

0 properties

JSON SCHEMA

ListDatabasesInput

0 properties

JSON SCHEMA

ListDatabasesOutput

0 properties

JSON SCHEMA

ListNamedQueriesInput

0 properties

JSON SCHEMA

ListNamedQueriesOutput

0 properties

JSON SCHEMA

ListPreparedStatementsInput

0 properties

JSON SCHEMA

ListPreparedStatementsOutput

0 properties

JSON SCHEMA

ListQueryExecutionsInput

0 properties

JSON SCHEMA

ListQueryExecutionsOutput

0 properties

JSON SCHEMA

ListTableMetadataInput

0 properties

JSON SCHEMA

ListTableMetadataOutput

0 properties

JSON SCHEMA

ListTagsForResourceInput

0 properties

JSON SCHEMA

ListTagsForResourceOutput

0 properties

JSON SCHEMA

ListWorkGroupsInput

0 properties

JSON SCHEMA

ListWorkGroupsOutput

0 properties

JSON SCHEMA

NamedQuery

0 properties

JSON SCHEMA

PreparedStatement

0 properties

JSON SCHEMA

PreparedStatementSummary

0 properties

JSON SCHEMA

QueryExecutionContext

0 properties

JSON SCHEMA

QueryExecution

0 properties

JSON SCHEMA

QueryExecutionStatistics

0 properties

JSON SCHEMA

QueryExecutionStatus

0 properties

JSON SCHEMA

QueryRuntimeStatisticsRows

0 properties

JSON SCHEMA

QueryRuntimeStatistics

0 properties

JSON SCHEMA

QueryRuntimeStatisticsTimeline

0 properties

JSON SCHEMA

QueryStagePlanNode

0 properties

JSON SCHEMA

QueryStage

0 properties

JSON SCHEMA

ResultConfiguration

0 properties

JSON SCHEMA

ResultConfigurationUpdates

0 properties

JSON SCHEMA

ResultSetMetadata

0 properties

JSON SCHEMA

ResultSet

0 properties

JSON SCHEMA

Row

0 properties

JSON SCHEMA

StartQueryExecutionInput

0 properties

JSON SCHEMA

StartQueryExecutionOutput

0 properties

JSON SCHEMA

StopQueryExecutionInput

0 properties

JSON SCHEMA

StopQueryExecutionOutput

0 properties

JSON SCHEMA

TableMetadata

0 properties

JSON SCHEMA

TagResourceInput

0 properties

JSON SCHEMA

TagResourceOutput

0 properties

JSON SCHEMA

Tag

0 properties

JSON SCHEMA

UnprocessedNamedQueryId

0 properties

JSON SCHEMA

UnprocessedQueryExecutionId

0 properties

JSON SCHEMA

UntagResourceInput

0 properties

JSON SCHEMA

UntagResourceOutput

0 properties

JSON SCHEMA

UpdateWorkGroupInput

0 properties

JSON SCHEMA

UpdateWorkGroupOutput

0 properties

JSON SCHEMA

WorkGroupConfiguration

0 properties

JSON SCHEMA

WorkGroupConfigurationUpdates

0 properties

JSON SCHEMA

WorkGroup

0 properties

JSON SCHEMA

WorkGroupSummary

0 properties

JSON SCHEMA

Scroll within the panel for all 99 ·

JSON Structure 98

JSON Structure captures the data shapes in a form built for tooling — a complement to JSON Schema that keeps the model machine-legible.

JSON Structure definitions describing this provider's data shapes.

Athena Athena Error 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 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 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 Query Execution Input 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 Table Metadata 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 Query Execution Context 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 Set Metadata Structure

0 properties

JSON STRUCTURE

Athena Result Set Structure

0 properties

JSON STRUCTURE

Athena Row 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 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

Scroll within the panel for all 98 ·

Examples 98

Real request and response payloads are what turn a spec from abstract into obvious — and they're one of the twelve things an agent needs to call an API correctly on the first try.

Example request and response payloads for these APIs.

Athena Column Example

3 fields

EXAMPLE

Athena Database Example

3 fields

EXAMPLE

Athena Datum 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

Scroll within the panel for all 98 ·

Security Posture 3

Authentication, domain security, vulnerability disclosure, and trust-center signals — the evidence that a provider takes security seriously enough to document it. We profile it because you can't govern what you can't see.

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Amazon Athena Authentication

apiKey · 1 scheme

SECURITY

Amazon Athena Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Amazon Athena Vulnerability Disclosure

Hackerone · security.txt · contact published

SECURITY

Agentic Access 1

An x-agentic-access contract marks which operations are safe for an agent to run on its own and which need a human in the loop. It is the difference between an API an agent can use and one it can use safely.

Recommended x-agentic-access execution contracts for AI agents.

Amazon Athena Agentic Access

32 operations · 32 acting · 1 human-in-the-loop

32 operations · 32 acting

AGENTIC

Use Cases 6

What developers actually build with this provider — captured so the catalogue answers 'what is this for', not just 'what does this expose'.

What developers build with this provider.

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 10

Pre-built integrations with other platforms tell you where this provider already fits in a stack.

Pre-built integrations with other platforms and tools.

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

Scroll within the panel for all 10 ·

Resources

Every other property we hold for Amazon Athena — documentation, portals, status pages, policies, and corporate surface — grouped by the job it does, following the integrator's arc from getting started to running in production.

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

← All providers · Data indexed from github.com/api-evangelist/amazon-athena · machine-readable index on apis.io

Where this information came from

This is an independent, third-party profile of Amazon Athena, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.

The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.

Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.

info@apievangelist.com · Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.