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.

Automate Amazon Athena with Lodol.

Connect Amazon Athena, then hand Lodol the job in Slack, Claude or ChatGPT.

Free plan, no credit card