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