influx query

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

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