Skip to main content

Athena integration for AI agents

Run SQL queries on data in Amazon S3 using AWS Athena

Athena is a Sim integration in the Analytics category. Sim is the AI workspace where teams build and deploy AI agents. Sim's Athena integration provides 27 tools that AI agents can use inside Sim's visual workflow builder. Athena requires no authentication. Free to start at sim.ai.

View docs

Last updated

What Sim agents can do with Athena

Execute SQL queries against data in S3, check query status and runtime statistics, retrieve results, manage named queries and prepared statements, and inspect data catalogs, databases, tables, and workgroups. Requires AWS access key and secret access key.

Category
Analytics
Authentication
None required
Tools
27
Triggers
0
Documentation
Athena docs

How to automate Athena with Sim

  1. Create a free account

    Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.

  2. Add an Athena block

    Open your workspace, drag an Athena block onto the workflow builder. No authentication is needed.

  3. Configure, connect, and run

    Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Athena automation is live.

Agent templates

Ready-to-use templates featuring Athena. Click any to build it instantly.

Athena tools

27 Athena tools available to Sim agents.

Start Query

Start an SQL query execution in AWS Athena

Get Query Execution

Get the status and details of an Athena query execution

Get Query Results

Retrieve the results of a completed Athena query execution

Get Query Runtime Statistics

Get runtime statistics (timeline, row counts, and output stage) for a completed Athena query execution

Stop Query

Stop a running Athena query execution

List Query Executions

List recent Athena query execution IDs

Batch Get Query Executions

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

Create Named Query

Create a saved/named query in AWS Athena

Get Named Query

Get details of a saved/named query in AWS Athena

Batch Get Named Queries

Get the details of up to 50 Athena named queries by ID in a single call

Update Named Query

Update the name, description, or SQL of an existing Athena named query (database and workgroup cannot change)

List Named Queries

List saved/named query IDs in AWS Athena

Delete Named Query

Delete a saved/named query in AWS Athena

Create Prepared Statement

Create a parameterized prepared statement in an Athena workgroup for use with EXECUTE or execution parameters

Get Prepared Statement

Get the SQL and metadata of a prepared statement in an Athena workgroup

Batch Get Prepared Statements

Get the details of up to 256 prepared statements in an Athena workgroup by name in a single call

Update Prepared Statement

Replace the SQL and description of an existing prepared statement in an Athena workgroup

List Prepared Statements

List the prepared statements saved in an Athena workgroup

Delete Prepared Statement

Delete a prepared statement from an Athena workgroup

List Data Catalogs

List the data catalogs (data sources) registered in the AWS account

Get Data Catalog

Get the type, status, and connection parameters of an Athena data catalog

List Databases

List the databases available in an Athena data catalog

Get Database

Get a single database (name, description, and parameters) from an Athena data catalog

List Table Metadata

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

Get Table Metadata

Get the columns, partition keys, and properties of a single table in an Athena data catalog database

List Workgroups

List the Athena workgroups available in the AWS account

Get Workgroup

Get the configuration of an Athena workgroup, including its result location, encryption, and limits

Frequently asked questions

Sim's Athena integration adds 27 tools to the AI agents you build in Sim's visual workflow builder. Run SQL queries on data in Amazon S3 using AWS Athena.

Every agent your company runs. All in one place.