Query InfluxDB

To query data from InfluxDB using Flux, use from() and range. Provide the following parameters to each function:

• from():
  • bucket or bucketID: InfluxDB bucket name or bucket ID to query.
• range():
  • start: Earliest time to return results from.

from(bucket: "example-bucket")
    |> range(start: -1h)

Query InfluxDB Cloud or 2.x remotely

To query InfluxDB Cloud or 2.x remotely, provide the following parameters in addition to bucket or bucketID.

• host: InfluxDB Cloud region URL or InfluxDB URL
• org or orgID: InfluxDB organization name or ID
• token: InfluxDB API token

from(
    bucket: "example-bucket",
    host: "http://localhost:8086",
    org: "example-org",
    token: "mYSup3r5Ecr3T70keN",
)

Query InfluxDB 1.x

To query InfluxDB 1.x, use the database-name/retention-policy-name naming convention for your bucket name. For example, to query data from the autogen retention policy in the telegraf database:

from(bucket: "telegraf/autogen")
    |> range(start: -30m)

To query the default retention policy in a database, use the same bucket naming convention, but do not provide a retention policy:

from(bucket: "telegraf/")
    |> range(start: -30m)

Results structure

from() and range() return a stream of tables grouped by series (measurement, tag set, and field). Each table includes the following columns:

• _start: Query range start time (defined by range())
• _stop: Query range stop time (defined by range())
• _time: Data timestamp
• _measurement: Measurement name
• _field: Field key
• _value: Field value
• Tag columns: A column for each tag where the column label is the tag key and the column value is the tag value

Example InfluxDB query results