influx query

• influx CLI 2.0.0+
• InfluxDB 2.0.0+
• Updated in CLI v2.0.5

This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. View this page in the v2.7 documentation.

The influx query command executes a literal Flux query provided as a string or a literal Flux query contained in a file.

Usage

influx query [query literal] [flags]

Remove unnecessary columns in large datasets

When using the influx query command to query and download large datasets, drop columns such as _start and _stop to optimize the download file size.

// ...
    |> drop(columns: ["_start", "_stop"])

Flags

Examples

Authentication credentials

The examples below assume your InfluxDB host, organization, and token are provided by either the active influx CLI configuration or by environment variables (INFLUX_HOST, INFLUX_ORG, and INFLUX_TOKEN). If you do not have a CLI configuration set up or the environment variables set, include these required credentials for each command with the following flags:

• --host: InfluxDB host
• -o, --org or --org-id: InfluxDB organization name or ID

• -t, --token: InfluxDB API token

• Query InfluxDB with a Flux string

• Query InfluxDB using a Flux file
• Query InfluxDB and return annotated CSV
• Query InfluxDB and append query profile data to results

Query InfluxDB with a Flux string

influx query 'from(bucket:"example-bucket") |> range(start:-1m)'

Query InfluxDB with a Flux file

influx query --file /path/to/example-query.flux

Query InfluxDB and return annotated CSV

influx query 'from(bucket:"example-bucket") |> range(start:-1m)' --raw

Query InfluxDB and append query profile data to results

For more information about profilers, see Flux profilers.

influx query \
  --profilers operator,query \
  'from(bucket:"example-bucket") |> range(start:-1m)'

Related

• Query data in InfluxDB
• Use the influx query command
• influx CLI—Provide required authentication credentials
• influx CLI—Flag patterns and conventions

query