Amazon Athena is an interactive query service from AWS that makes it easy to analyze data directly in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries you run.
With Athena, you can:
- Query data in S3: Run SQL queries directly against data stored in Amazon S3 without loading it into a database
- Support multiple formats: Query CSV, JSON, Parquet, ORC, Avro, and other common data formats
- Integrate with AWS Glue: Use the AWS Glue Data Catalog to manage table metadata and schemas
- Scale automatically: Handle queries of any size without provisioning servers or clusters
- Save and reuse queries: Create named queries for frequently used SQL statements
In Sim, the Athena integration enables your agents to run SQL queries against data in S3, check query execution status, retrieve results, and manage saved queries — all within your agent workflows. Supported operations include:
- Start Query: Execute SQL queries against your S3 data
- Get Query Execution: Check the status and details of a running or completed query
- Get Query Results: Retrieve the results of a completed query
- Stop Query: Cancel a running query execution
- List Query Executions: View recent query execution IDs
- Create Named Query: Save a query for reuse
- Get Named Query: Retrieve details of a saved query
- List Named Queries: View all saved query IDs
This integration empowers Sim agents to automate data analysis tasks using AWS Athena, enabling workflows that query, monitor, and manage large-scale data in S3 without manual effort or infrastructure management.
Integrate AWS Athena into workflows. Execute SQL queries against data in S3, check query status, retrieve results, manage named queries, and list executions. Requires AWS access key and secret access key.
Start an SQL query execution in AWS Athena
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
queryString | string | Yes | SQL query string to execute |
database | string | No | Database name within the catalog |
catalog | string | No | Data catalog name (default: AwsDataCatalog) |
outputLocation | string | No | S3 output location for query results (e.g., s3://bucket/path/) |
workGroup | string | No | Workgroup to execute the query in (default: primary) |
| Parameter | Type | Description |
|---|
queryExecutionId | string | Unique ID of the started query execution |
Get the status and details of an Athena query execution
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
queryExecutionId | string | Yes | Query execution ID to check |
| Parameter | Type | Description |
|---|
queryExecutionId | string | Query execution ID |
query | string | SQL query string |
state | string | Query state (QUEUED, RUNNING, SUCCEEDED, FAILED, CANCELLED) |
stateChangeReason | string | Reason for state change (e.g., error message) |
statementType | string | Statement type (DDL, DML, UTILITY) |
database | string | Database name |
catalog | string | Data catalog name |
workGroup | string | Workgroup name |
submissionDateTime | number | Query submission time (Unix epoch ms) |
completionDateTime | number | Query completion time (Unix epoch ms) |
dataScannedInBytes | number | Amount of data scanned in bytes |
engineExecutionTimeInMillis | number | Engine execution time in milliseconds |
queryPlanningTimeInMillis | number | Query planning time in milliseconds |
queryQueueTimeInMillis | number | Time the query spent in queue in milliseconds |
totalExecutionTimeInMillis | number | Total execution time in milliseconds |
outputLocation | string | S3 location of query results |
Retrieve the results of a completed Athena query execution
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
queryExecutionId | string | Yes | Query execution ID to get results for |
maxResults | number | No | Maximum number of rows to return (1-999) |
nextToken | string | No | Pagination token from a previous request |
| Parameter | Type | Description |
|---|
columns | array | Column metadata (name and type) |
rows | array | Result rows as key-value objects |
nextToken | string | Pagination token for next page of results |
updateCount | number | Number of rows affected (for INSERT/UPDATE statements) |
Stop a running Athena query execution
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
queryExecutionId | string | Yes | Query execution ID to stop |
| Parameter | Type | Description |
|---|
success | boolean | Whether the query was successfully stopped |
List recent Athena query execution IDs
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
workGroup | string | No | Workgroup to list executions for (default: primary) |
maxResults | number | No | Maximum number of results (0-50) |
nextToken | string | No | Pagination token from a previous request |
| Parameter | Type | Description |
|---|
queryExecutionIds | array | List of query execution IDs |
nextToken | string | Pagination token for next page |
Get the status and details of up to 50 Athena query executions in one call
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
queryExecutionIds | string | Yes | Comma-separated query execution IDs to check (up to 50) |
| Parameter | Type | Description |
|---|
queryExecutions | array | Details for each successfully retrieved query execution |
↳ queryExecutionId | string | Query execution ID |
↳ query | string | SQL query string |
↳ state | string | Query state (QUEUED, RUNNING, SUCCEEDED, FAILED, CANCELLED) |
↳ stateChangeReason | string | Reason for state change |
↳ statementType | string | Statement type (DDL, DML, UTILITY) |
↳ database | string | Database name |
↳ catalog | string | Data catalog name |
↳ workGroup | string | Workgroup name |
↳ submissionDateTime | number | Query submission time (Unix epoch ms) |
↳ completionDateTime | number | Query completion time (Unix epoch ms) |
↳ dataScannedInBytes | number | Amount of data scanned in bytes |
↳ engineExecutionTimeInMillis | number | Engine execution time in milliseconds |
↳ queryPlanningTimeInMillis | number | Query planning time in milliseconds |
↳ queryQueueTimeInMillis | number | Time the query spent in queue in milliseconds |
↳ totalExecutionTimeInMillis | number | Total execution time in milliseconds |
↳ outputLocation | string | S3 location of query results |
unprocessedQueryExecutionIds | array | Query execution IDs that could not be retrieved, with error details |
↳ queryExecutionId | string | Query execution ID |
↳ errorCode | string | Error code |
↳ errorMessage | string | Error message |
Create a saved/named query in AWS Athena
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
name | string | Yes | Name for the saved query |
database | string | Yes | Database the query runs against |
queryString | string | Yes | SQL query string to save |
description | string | No | Description of the named query |
workGroup | string | No | Workgroup to create the named query in |
| Parameter | Type | Description |
|---|
namedQueryId | string | ID of the created named query |
Get details of a saved/named query in AWS Athena
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
namedQueryId | string | Yes | Named query ID to retrieve |
| Parameter | Type | Description |
|---|
namedQueryId | string | Named query ID |
name | string | Name of the saved query |
description | string | Query description |
database | string | Database the query runs against |
queryString | string | SQL query string |
workGroup | string | Workgroup name |
List saved/named query IDs in AWS Athena
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
workGroup | string | No | Workgroup to list named queries for |
maxResults | number | No | Maximum number of results (0-50) |
nextToken | string | No | Pagination token from a previous request |
| Parameter | Type | Description |
|---|
namedQueryIds | array | List of named query IDs |
nextToken | string | Pagination token for next page |
Delete a saved/named query in AWS Athena
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
namedQueryId | string | Yes | Named query ID to delete |
| Parameter | Type | Description |
|---|
success | boolean | Whether the named query was successfully deleted |
List the databases available in an Athena data catalog
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
catalogName | string | Yes | Data catalog name to list databases from (e.g., AwsDataCatalog) |
workGroup | string | No | Workgroup for which the metadata is being fetched (required for IAM Identity Center enabled catalogs) |
maxResults | number | No | Maximum number of results (1-50) |
nextToken | string | No | Pagination token from a previous request |
| Parameter | Type | Description |
|---|
databases | array | List of databases (name, description) |
↳ name | string | Database name |
↳ description | string | Database description |
nextToken | string | Pagination token for next page |
List tables and their column/partition metadata for an Athena database
| Parameter | Type | Required | Description |
|---|
awsRegion | string | Yes | AWS region (e.g., us-east-1) |
awsAccessKeyId | string | Yes | AWS access key ID |
awsSecretAccessKey | string | Yes | AWS secret access key |
catalogName | string | Yes | Data catalog name (e.g., AwsDataCatalog) |
databaseName | string | Yes | Database name to list tables from |
expression | string | No | Regex filter that pattern-matches table names |
workGroup | string | No | Workgroup for which the metadata is being fetched (required for IAM Identity Center enabled catalogs) |
maxResults | number | No | Maximum number of results (1-50) |
nextToken | string | No | Pagination token from a previous request |
| Parameter | Type | Description |
|---|
tables | array | Table metadata (name, type, columns, partition keys) |
↳ name | string | Table name |
↳ tableType | string | Table type |
↳ createTime | number | Table creation time (Unix epoch ms) |
↳ lastAccessTime | number | Table last access time (Unix epoch ms) |
↳ columns | array | Column definitions |
↳ name | string | Column name |
↳ type | string | Column data type |
↳ comment | string | Column comment |
↳ partitionKeys | array | Partition key definitions |
↳ name | string | Partition key name |
↳ type | string | Partition key data type |
↳ comment | string | Partition key comment |
nextToken | string | Pagination token for next page |