Athena

Amazon Athena é um serviço de consulta interativa da AWS que facilita a análise de dados diretamente no Amazon S3 usando SQL padrão. O Athena é serverless, então não há infraestrutura para gerenciar, e você paga apenas pelas consultas que executa.

Com o Athena, você pode:

Consultar dados no S3: Executar consultas SQL diretamente contra dados armazenados no Amazon S3 sem carregá-los em um banco de dados
Suportar múltiplos formatos: Consultar CSV, JSON, Parquet, ORC, Avro e outros formatos comuns de dados
Integrar com o AWS Glue: Usar o AWS Glue Data Catalog para gerenciar metadados e schemas de tabelas
Escalar automaticamente: Lidar com consultas de qualquer tamanho sem provisionar servidores ou clusters
Salvar e reutilizar consultas: Criar named queries para instruções SQL usadas com frequência

No Zoen, a integração do Athena permite que seus agentes executem consultas SQL contra dados no S3, verifiquem o status de execução, recuperem resultados e gerenciem consultas salvas — tudo dentro dos fluxos de trabalho dos seus agentes. As operações suportadas incluem:

Start Query: Executar consultas SQL contra seus dados no S3
Get Query Execution: Verificar o status e os detalhes de uma consulta em execução ou concluída
Get Query Results: Recuperar os resultados de uma consulta concluída
Stop Query: Cancelar uma execução de consulta em andamento
List Query Executions: Visualizar IDs recentes de execução de consultas
Create Named Query: Salvar uma consulta para reutilização
Get Named Query: Recuperar detalhes de uma consulta salva
List Named Queries: Visualizar todos os IDs de consultas salvas

Essa integração capacita os agentes do Zoen a automatizar tarefas de análise de dados com o AWS Athena, permitindo fluxos de trabalho que consultam, monitoram e gerenciam dados em larga escala no S3 sem esforço manual ou gerenciamento de infraestrutura.

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)

Output

Parameter	Type	Description
`queryExecutionId`	string	Unique ID of the started query execution

`athena_get_query_execution`

Get the status and details of an Athena query execution

Input

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

Output

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

`athena_get_query_results`

Retrieve the results of a completed Athena query execution

Input

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

Output

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)

`athena_stop_query`

Stop a running Athena query execution

Input

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

Output

Parameter	Type	Description
`success`	boolean	Whether the query was successfully stopped

`athena_list_query_executions`

List recent Athena query execution IDs

Input

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

Output

Parameter	Type	Description
`queryExecutionIds`	array	List of query execution IDs
`nextToken`	string	Pagination token for next page

`athena_batch_get_query_execution`

Get the status and details of up to 50 Athena query executions in one call

Input

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)

Output

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

`athena_create_named_query`

Create a saved/named query in AWS Athena

Input

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

Output

Parameter	Type	Description
`namedQueryId`	string	ID of the created named query

`athena_get_named_query`

Get details of a saved/named query in AWS Athena

Input

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

Output

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

`athena_list_named_queries`

List saved/named query IDs in AWS Athena

Input

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

Output

Parameter	Type	Description
`namedQueryIds`	array	List of named query IDs
`nextToken`	string	Pagination token for next page

`athena_delete_named_query`

Delete a saved/named query in AWS Athena

Input

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

Output

Parameter	Type	Description
`success`	boolean	Whether the named query was successfully deleted

`athena_list_databases`

List the databases available in an Athena data catalog

Input

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

Output

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

`athena_list_table_metadata`

List tables and their column/partition metadata for an Athena database

Input

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

Output

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

Athena

Usage Instructions

Actions

`athena_start_query`

Input

Output

`athena_get_query_execution`

Input

Output

`athena_get_query_results`

Input

Output

`athena_stop_query`

Input

Output

`athena_list_query_executions`

Input

Output

`athena_batch_get_query_execution`

Input

Output

`athena_create_named_query`

Input

Output

`athena_get_named_query`

Input

Output

`athena_list_named_queries`

Input

Output

`athena_delete_named_query`

Input

Output

`athena_list_databases`

Input

Output

`athena_list_table_metadata`

Input

Output

On this page