Run SQL queries on data in Amazon S3 using AWS Athena
Athena is a Analytics integration for Sim, the AI workspace where teams build and deploy AI agents. Sim's Athena integration provides 27 Athena tools that AI agents can use inside Sim's visual workflow builder. Athena requires no authentication. Free to start at sim.ai.
Last updated
Integrate AWS Athena into workflows. 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.
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Open your workspace, drag an Athena block onto the workflow builder. No authentication is needed.
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Athena automation is live.
Ready-to-use templates featuring Athena. Click any to build it instantly.
27 Athena tools available in Sim
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
Sim's Athena integration adds 27 Athena tools to the AI agents you build in Sim's visual workflow builder — you build it all visually. Run SQL queries on data in Amazon S3 using AWS Athena. Teams often pair Athena with Rippling and Linear in the same agent.
