All integrationsDatabases
Amazon Athena
Query data in Amazon S3 with Amazon Athena's serverless SQL: run a query and read its rows, track or cancel a running query, browse the data catalogs, databases and tables available to it, read workgroup settings, and manage saved queries.
- actions
- 20
Actions
Steps a workflow can run in Amazon Athena.
- Start queryRun a SQL statement in Athena and return its query execution id. The query runs asynchronously: follow this with Get query execution until the state is SUCCEEDED, then Get query results.
- Get query executionRead a query's state, timings and the number of bytes it scanned. States are QUEUED, RUNNING, SUCCEEDED, FAILED and CANCELLED; results can only be read once it is SUCCEEDED.
- Get query resultsRead a finished query's rows. Each row comes back as a mapping of column name to value, with Athena's repeated header row removed. The query must have reached SUCCEEDED.
- Stop queryCancel a running query. Athena still bills for the data the query had scanned when it stopped.
- List query executionsList recent query execution ids, most recent first. Ids only - follow with Get query executions (batch) for the detail.
- Get query executions (batch)Read up to 50 query executions in one call. An id Athena does not recognise is reported under 'unprocessed' instead of failing the whole call.
- Get query runtime statisticsRead a query's timeline, input/output row counts and execution plan. Athena keeps the full statistics for about 30 days; an older query returns the timeline only.
- List data catalogsList the data catalogs in the region - the Athena console calls them data sources. Every account has the built-in AwsDataCatalog, backed by AWS Glue.
- Get data catalogRead one data catalog, including the connector settings a federated catalog uses.
- List databasesList the databases (schemas) in a data catalog, with their descriptions and properties.
- Get databaseRead one database's description and properties.
- List tablesList a database's tables with their columns, partition keys and properties.
- Get tableRead one table's columns and partition keys. Partition columns appear only under 'partition_keys', never in 'columns'.
- List workgroupsList the workgroups in the region. Every account has one called 'primary' that queries use by default.
- Get workgroupRead a workgroup's settings - most usefully where its query results go, whether managed query results are on, and whether its settings override anything a query asks for.
- Create saved querySave a query so it appears under Saved queries in the Athena console. Nothing runs, and the SQL is not checked.
- Get saved queryRead one saved query's name, SQL, database and workgroup.
- List saved queriesList saved query ids in a workgroup. Ids only - follow with Get saved query for each one's SQL.
- Update saved queryReplace a saved query's name, SQL and description. Athena requires all of them on every update and drops a description that is not resent, so read the query first and pass back what you are not changing. Its database and workgroup cannot be changed.
- Delete saved queryDelete a saved query. Deleting an id that does not exist is an error, not a silent no-op.
No actions match that.
Automate Amazon Athena with Lodol.
Connect Amazon Athena, then hand Lodol the job in Slack, Claude or ChatGPT.
Free plan, no credit card