QueryQuery
QueryCertified
yaml
type: "io.kestra.plugin.aws.athena.Query"
yaml
id: aws_athena_query
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.aws.athena.Query
    accessKeyId: "{{ secret('AWS_ACCESS_KEY_ID') }}"
    secretKeyId: "{{ secret('AWS_SECRET_KEY_ID') }}"
    region: "eu-central-1"
    database: my_database
    outputLocation: s3://some-s3-bucket
    query: |
      select * from cloudfront_logs limit 10
Properties
DefaultSTORE
Possible Values
STOREFETCHFETCH_ONENONE
Defaulttrue
DefaultPT15M
Formatduration
Formaturi
Unitbytes
Unitmilliseconds
Unitrows
Unitmilliseconds
Unitmilliseconds
Unitmilliseconds
Unitmilliseconds
Unitrows

Create automations with AWS Athena Query

Event-driven data ingestion to AWS S3 data lake managed by Apache Iceberg, AWS Glue and Amazon Athena
Data
Ingest data to AWS S3 with Git, Python, Apache Iceberg, AWS Glue and Amazon Athena
Data
Ingest data to AWS S3 with Python, Apache Iceberg, AWS Glue and Athena
Data

More Plugins in this Category

Core Plugins and tasks
Core Plugins and tasks

Tasks that provide Kestra's built-in orchestration, I/O, and observability capabilities.

CoreStorageScript

126 Tasks

189 Blueprints

PostgreSQL
PostgreSQL

Tasks that connect to PostgreSQL via JDBC to run queries and loads.

Database

6 Tasks

8 Blueprints

SurrealDB
SurrealDB

Tasks that run SurrealQL queries against SurrealDB.

Database

2 Tasks

2 Blueprints
OVERVIEW
Versions
1.4.1
Latest
December 22, 2025 Release Notes Min. Compatible Kestra Version: 1.1.0
Previous Versions
1.4.0December 12, 2025 Min. Compatible Kestra Version: 1.1.0
1.3.0November 26, 2025 Min. Compatible Kestra Version: 1.1.0
1.2.1November 21, 2025 Min. Compatible Kestra Version: 1.1.0
1.2.0November 14, 2025 Min. Compatible Kestra Version: 1.1.0
1.1.0November 4, 2025 Min. Compatible Kestra Version: 1.1.0
1.0.1October 31, 2025 Min. Compatible Kestra Version: 1.0.0
1.0.0September 8, 2025 Min. Compatible Kestra Version: [1.0,)
0.24.0August 5, 2025 Min. Compatible Kestra Version: [0.24,)
0.24.0-rc1-SNAPSHOTJuly 31, 2025 Min. Compatible Kestra Version: [0.24,)
0.24.0-rc0-SNAPSHOTJuly 29, 2025 Min. Compatible Kestra Version: [0.23,)
0.23.0June 17, 2025 Min. Compatible Kestra Version: [0.23,0.24)
0.23.0-rc5-SNAPSHOTJune 16, 2025 Min. Compatible Kestra Version: [0.23,0.24)
0.23.0-rc4-SNAPSHOTJune 12, 2025 Min. Compatible Kestra Version: [0.23,0.24)
0.23.0-rc3-SNAPSHOTJune 10, 2025 Min. Compatible Kestra Version: [0.23,0.24)
0.23.0-rc2-SNAPSHOTJune 9, 2025 Min. Compatible Kestra Version: [0.22,)
0.23.0-rc1-SNAPSHOTJune 4, 2025 Min. Compatible Kestra Version: [0.22,)
0.23.0-rc0-SNAPSHOTJune 3, 2025 Min. Compatible Kestra Version: [0.22,)
0.22.1May 27, 2025 Min. Compatible Kestra Version: [0.22,)
0.22.0April 1, 2025 Min. Compatible Kestra Version: [0.22,)
0.22.0-rc4-SNAPSHOTMarch 31, 2025 Min. Compatible Kestra Version: [0.22,)
0.22.0-rc2-SNAPSHOTMarch 28, 2025 Min. Compatible Kestra Version: [0.22,)
0.22.0-rc1-SNAPSHOTMarch 25, 2025 Min. Compatible Kestra Version: [0.22,)
0.21.2February 25, 2025 Min. Compatible Kestra Version: [0.21,)
0.21.1February 14, 2025 Min. Compatible Kestra Version: [0.20,)
0.21.0February 4, 2025 Min. Compatible Kestra Version: [0.20,)
0.21.0-rc2-SNAPSHOTFebruary 3, 2025 Min. Compatible Kestra Version: [0.20,)
0.21.0-rc1-SNAPSHOTJanuary 31, 2025 Min. Compatible Kestra Version: [0.20,)
0.21.0-rc0-SNAPSHOTJanuary 29, 2025 Min. Compatible Kestra Version: [0.20,)
0.20.0December 3, 2024 Min. Compatible Kestra Version: [0.20,)

Created by

Kestra Core Team

Managed by

Kestra Core Team
Plugin Type
AlertingCloudMessagingStorageDatabaseScriptToolTransformation
Links & Resources
GitHub