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
--http-debugInspect communication with InfluxDB servers.string
-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 verificationINFLUX_SKIP_VERIFY
-t--tokenAPI tokenstringINFLUX_TOKEN

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

Was this page helpful?

Thank you for your feedback!


Select your region

Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.

InfluxDB Cloud powered by TSM