InfluxDB InfluxQLQuery

InfluxDB InfluxQLQuery

Certified

Run InfluxQL query against InfluxDB

Executes an InfluxQL query for the specified bucket and organization. fetchType controls whether rows are returned inline, stored, or just counted.

yaml
type: io.kestra.plugin.influxdb.InfluxQLQuery

Execute an InfluxQL query.

yaml
id: influxdb_query
namespace: company.team

tasks:
  - id: query_influxdb
    type: io.kestra.plugin.influxdb.InfluxQLQuery
    connection:
      url: "{{ secret('INFLUXDB_URL') }}"
      token: "{{ secret('INFLUXDB_TOKEN') }}"
    org: "my-org"
    query: "SELECT * FROM measurement WHERE time > now() - 1h"
    fetchType: FETCH

Execute an InfluxQL query and store results as ION file

yaml
id: influxdb_query_to_file
namespace: company.team

tasks:
  - id: query_to_file
    type: io.kestra.plugin.influxdb.InfluxQLQuery
    connection:
      url: "{{ secret('INFLUXDB_URL') }}"
      token: "{{ secret('INFLUXDB_TOKEN') }}"
    org: "my-org"
    query: "SELECT * FROM measurement WHERE time > now() - 1h"
    fetchType: ION
Properties

InfluxDB connection

Connection settings (URL, token, optional options) reused across tasks

Definitions
token*string

InfluxDB token

The authentication token for InfluxDB

url*string

InfluxDB server URL

The URL of the InfluxDB server

connectTimeoutstring
DefaultPT10S

Connection timeout.

Connection establishment timeout (ISO-8601 duration, e.g. PT10S). Default is 10 seconds.

readTimeoutstring
DefaultPT10S

Read timeout.

Maximum time to wait for response bytes (including initial response) (ISO-8601 duration, e.g. PT10S). Default is 10 seconds.

Organization name

Organization scope for queries and writes

Query string

Flux or InfluxQL statement to run against InfluxDB

Assets this task consumes as inputs or produces as outputs, for lineage tracking and the asset graph (Enterprise Edition). A flow declaring this property on a task is rejected in the open-source edition.

Definitions
assetFailureBehaviorstring
Possible Values
IGNOREFAILWARN

Asset failure behavior

Behavior applied to the task state when a declared asset fails to render, emit, or be persisted (e.g. a lock conflict): FAIL escalates it to FAILED, WARN (default) warns it if it would otherwise succeed, IGNORE leaves the state untouched.

enableAutobooleanstring

Whether to auto-register assets referenced dynamically at runtime that are not statically declared in inputs or outputs.

inputsarray

The assets consumed as inputs.

id*string
Min length1
typestring
outputs

The assets produced as outputs.

id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*object
descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150
id*string
Min length1
Max length150
type*string
Min length1

Custom asset type

descriptionstring
displayNamestring
metadataobject
Default{}
namespacestring
Min length1
Max length150

Bucket name

Target bucket for write/query operations when required; ignored by Flux queries

DefaultNONE
Possible Values
STOREFETCHFETCH_ONENONE

Fetch behavior

FETCH_ONE returns the first row, FETCH returns all rows, STORE writes rows to an ION file, NONE only records metrics; default is NONE

First fetched row

Only populated when fetchType=FETCH_ONE

SubTypeobject

Fetched rows

Only populated when fetchType=FETCH

Number of rows returned

Total rows without pagination

Formaturi

URI of stored data

Only populated when fetchType=STORE

Unitcount

The number of records returned by the query