# Amazon Athena API

> Amazon Athena API on Apizie: 68 endpoints (Returns the details of a single named query or a list of up to 50 queries, which you provide as an array of…, Returns the details of a single prepared statement or a list of up to 256 prepared statements for the array…, Returns the details of a single query execution or a list of up to 50 query executions, which you provide as…, Cancels the capacity reservation with the specified name. Cancelled reservations remain in your account and…, …) returned as clean JSON through one API key. Send your own provider key in the x-upstream-key header. Call it over REST at https://apizie.tech/v1/cloud:amazonaws-athena/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month.

- Project key: `cloud:amazonaws-athena`
- Category: Cloud
- Status: byok
- Source: https://github.com/mermade/aws2openapi
- Page: https://apizie.tech/api/cloud/amazonaws-athena
- OpenAPI: https://apizie.tech/api/cloud/amazonaws-athena/openapi.json

Amazon Athena is an interactive query service that lets you use standard SQL to analyze data directly in Amazon S3. You can point Athena at your data in Amazon S3 and run ad-hoc queries and get results in seconds.…

## Endpoints

### Returns the details of a single named query or a list of up to 50 queries, which you provide as an array of…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/batch-get-named-query` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns the details of a single prepared statement or a list of up to 256 prepared statements for the array…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/batch-get-prepared-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns the details of a single query execution or a list of up to 50 query executions, which you provide as…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/batch-get-query-execution` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Cancels the capacity reservation with the specified name. Cancelled reservations remain in your account and…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/cancel-capacity-reservation` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Creates a capacity reservation with the specified name and number of requested data processing units.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/create-capacity-reservation` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Creates (registers) a data catalog with the specified name and properties. Catalogs created are visible to…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/create-data-catalog` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Creates a named query in the specified workgroup. Requires that you have access to the workgroup. For code…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/create-named-query` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Creates an empty ipynb file in the specified Apache Spark enabled workgroup. Throws an error if a file in…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/create-notebook` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Creates a prepared statement for use with SQL queries in Athena.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/create-prepared-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Gets an authentication token and the URL at which the notebook can be accessed. During programmatic access,…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/create-presigned-notebook-url` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Creates a workgroup with the specified name. A workgroup can be an Apache Spark enabled workgroup or an…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/create-work-group` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Deletes a cancelled capacity reservation. A reservation must be cancelled before it can be deleted. A…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/delete-capacity-reservation` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Deletes a data catalog.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/delete-data-catalog` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Deletes the named query if you have access to the workgroup in which the query was saved. For code samples…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/delete-named-query` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Deletes the specified notebook.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/delete-notebook` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Deletes the prepared statement with the specified name from the specified workgroup.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/delete-prepared-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Deletes the workgroup with the specified name. The primary workgroup cannot be deleted.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/delete-work-group` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Exports the specified notebook and its metadata.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/export-notebook` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Describes a previously submitted calculation execution.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-calculation-execution` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Retrieves the unencrypted code that was executed for the calculation.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-calculation-execution-code` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Gets the status of a current calculation.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-calculation-execution-status` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Gets the capacity assignment configuration for a capacity reservation, if one exists.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-capacity-assignment-configuration` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns information about the capacity reservation with the specified name.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-capacity-reservation` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns the specified data catalog.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-data-catalog` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns a database object for the specified database and data catalog.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-database` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns information about a single query. Requires that you have access to the workgroup in which the query…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-named-query` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Retrieves notebook metadata for the specified notebook ID.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-notebook-metadata` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Retrieves the prepared statement with the specified name from the specified workgroup.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-prepared-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns information about a single execution of a query if you have access to the workgroup in which the…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-query-execution` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Streams the results of a single query execution specified by QueryExecutionId from the Athena query results…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-query-results` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Returns query execution runtime statistics related to a single execution of a query if you have access to…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-query-runtime-statistics` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Gets the full details of a previously created session, including the session status and configuration.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-session` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Gets the current status of a session.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-session-status` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns table metadata for the specified catalog, database, and table.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-table-metadata` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns information about the workgroup with the specified name.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/get-work-group` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Imports a single ipynb file to a Spark enabled workgroup. The maximum file size that can be imported is 10…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/import-notebook` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Returns the supported DPU sizes for the supported application runtimes (for example, Athena notebook version…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-application-dpusizes` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists the calculations that have been submitted to a session in descending order. Newer calculations are…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-calculation-executions` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists the capacity reservations for the current account.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-capacity-reservations` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists the data catalogs in the current Amazon Web Services account. In the Athena console, data catalogs are…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-data-catalogs` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists the databases in the specified data catalog.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-databases` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Returns a list of engine versions that are available to choose from, including the Auto option.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-engine-versions` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists, in descending order, the executors that joined a session. Newer executors are listed first; older…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-executors` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Provides a list of available query IDs only for queries saved in the specified workgroup. Requires that you…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-named-queries` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Displays the notebook files for the specified workgroup in paginated format.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-notebook-metadata` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Lists, in descending order, the sessions that have been created in a notebook that are in an active state…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-notebook-sessions` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Lists the prepared statements in the specified workgroup.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-prepared-statements` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Provides a list of available query execution IDs for the queries in the specified workgroup. If a workgroup…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-query-executions` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists the sessions in a workgroup that are in an active state like CREATING , CREATED , IDLE , or BUSY .…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-sessions` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists the metadata for the tables in the specified data catalog database.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-table-metadata` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists the tags associated with an Athena resource.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-tags-for-resource` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Lists available workgroups for the account.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/list-work-groups` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| MaxResults | integer | no | Pagination limit |
| NextToken | string | no | Pagination token |
| body | object | no | JSON request body |

### Puts a new capacity assignment configuration for a specified capacity reservation. If a capacity assignment…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/put-capacity-assignment-configuration` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Submits calculations for execution within a session. You can supply the code to run as an inline code block…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/start-calculation-execution` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Runs the SQL query statements contained in the Query . Requires you to have access to the workgroup in which…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/start-query-execution` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Creates a session for running calculations within a workgroup. The session is ready when it reaches an IDLE…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/start-session` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Requests the cancellation of a calculation. A StopCalculationExecution call on a calculation that is already…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/stop-calculation-execution` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Stops a query execution. Requires you to have access to the workgroup in which the query ran. For code…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/stop-query-execution` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Adds one or more tags to an Athena resource. A tag is a label that you assign to a resource. Each tag…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/tag-resource` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Terminates an active session. A TerminateSession call on a session that is already inactive (for example, in…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/terminate-session` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Removes one or more tags from an Athena resource.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/untag-resource` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Updates the number of requested data processing units for the capacity reservation with the specified name.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/update-capacity-reservation` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Updates the data catalog that has the specified name.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/update-data-catalog` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Updates a NamedQuery object. The database or workgroup cannot be updated.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/update-named-query` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Updates the contents of a Spark notebook.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/update-notebook` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Updates the metadata for a notebook.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/update-notebook-metadata` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Updates a prepared statement.
`POST https://apizie.tech/v1/cloud:amazonaws-athena/update-prepared-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

### Updates the workgroup with the specified name. The workgroup's name cannot be changed. Only…
`POST https://apizie.tech/v1/cloud:amazonaws-athena/update-work-group` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| region | string | no | The AWS region |
| body | object | no | JSON request body |

## Example
```
curl "https://apizie.tech/v1/cloud:amazonaws-athena/batch-get-named-query" \
  -H "x-api-key: $APIZIE_KEY" \
  -H "x-upstream-key: $PROVIDER_KEY"
```

## FAQ

### How do I call the Amazon Athena API?
Create a free Apizie key, then send POST https://apizie.tech/v1/cloud:amazonaws-athena/batch-get-named-query with the header x-api-key. Every endpoint returns { project, data, timestamp }.

### Is the Amazon Athena API free on Apizie?
Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Amazon Athena itself also needs your own key from amazonaws.com.

### Can AI agents use the Amazon Athena API?
Yes. Add the Apizie MCP server (https://apizie.tech/mcp) to Claude, ChatGPT, Cursor or VS Code, then ask in plain language. The agent calls run_scraper with project key cloud:amazonaws-athena.

### What is the status of the Amazon Athena API?
Needs your own provider key (bring your own key)