influx query command executes a literal Flux query provided as a string
or a literal Flux query contained in a file.
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
_stop to optimize the download file size.
// ... |> drop(columns: ["_start", "_stop"])
|Flag||Description||Input type||Maps to ?|
|CLI configuration to use for command||string|
|Path to ||string|
|Path to Flux script file||string|
|Help for the |
|HTTP address of InfluxDB (default ||string|
|Organization name (mutually exclusive with ||string|
|Organization ID (mutually exclusive with ||string|
|Flux query profilers to enable (comma-separated)||string|
|Output raw query results (annotated CSV)|
|Skip TLS certificate verification|
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
- 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)'
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.