Documentation

influx query

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

FlagDescriptionInput typeMaps to ?
-c--active-configCLI configuration to use for commandstring
--configs-pathPath to influx CLI configurations (default ~/.influxdbv2/configs)stringINFLUX_CONFIGS_PATH
-f--filePath to Flux script filestring
-h--helpHelp for the query command
--hostHTTP address of InfluxDB (default http://localhost:8086)stringINFLUX_HOST
-o--orgOrganization name (mutually exclusive with --org-id)stringINFLUX_ORG
--org-idOrganization ID (mutually exclusive with --org)stringINFLUX_ORG_ID
-p--profilersFlux query profilers to enable (comma-separated)string
-r--rawOutput raw query results (annotated CSV)
--skip-verifySkip TLS certificate verification
-t--tokenAuthentication tokenstringINFLUX_TOKEN

Examples

Authentication credentials

The examples below assume your InfluxDB host, organization, and token are provided by the active influx CLI configuration. If you do not have a CLI configuration set up, use the appropriate flags to provide these required credentials.

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)'

Set your InfluxDB URL

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.