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|
|Inspect communication with InfluxDB servers.||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 either the active
influx CLI configuration or by environment variables (
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
--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)'
Was this page helpful?
Thank you for your feedback!
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, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.