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.
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 to Sim agents.
Start an SQL query execution in AWS Athena
Get the status and details of an Athena query execution
Retrieve the results of a completed Athena query execution
Get runtime statistics (timeline, row counts, and output stage) for a completed Athena query execution
Stop a running Athena query execution
List recent Athena query execution IDs
Get the status and details of up to 50 Athena query executions in one call
Create a saved/named query in AWS Athena
Get details of a saved/named query in AWS Athena
Get the details of up to 50 Athena named queries by ID in a single call
Update the name, description, or SQL of an existing Athena named query (database and workgroup cannot change)
List saved/named query IDs in AWS Athena
Delete a saved/named query in AWS Athena
Create a parameterized prepared statement in an Athena workgroup for use with EXECUTE or execution parameters
Get the SQL and metadata of a prepared statement in an Athena workgroup
Get the details of up to 256 prepared statements in an Athena workgroup by name in a single call
Replace the SQL and description of an existing prepared statement in an Athena workgroup
List the prepared statements saved in an Athena workgroup
Delete a prepared statement from an Athena workgroup
List the data catalogs (data sources) registered in the AWS account
Get the type, status, and connection parameters of an Athena data catalog
List the databases available in an Athena data catalog
Get a single database (name, description, and parameters) from an Athena data catalog
List tables and their column/partition metadata for an Athena database
Get the columns, partition keys, and properties of a single table in an Athena data catalog database
List the Athena workgroups available in the AWS account
Get the configuration of an Athena workgroup, including its result location, encryption, and limits
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.
