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] ``` {{% note %}} #### 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. ```js // ... |> drop(columns: ["_start", "_stop"]) ``` {{% /note %}} ## Flags | Flag | | Description | Input type | {{< cli/mapped >}} | |:-----|:------------------|:----------------------------------------------------------------------|:----------:|:----------------------| | `-c` | `--active-config` | CLI configuration to use for command | string | | | | `--configs-path` | Path to `influx` CLI configurations (default `~/.influxdbv2/configs`) | string | `INFLUX_CONFIGS_PATH` | | `-f` | `--file` | Path to Flux script file | string | | | `-h` | `--help` | Help for the `query` command | | | | | `--host` | HTTP address of InfluxDB (default `http://localhost:8086`) | string | `INFLUX_HOST` | | | `--http-debug` | Inspect communication with InfluxDB servers. | string | | | `-o` | `--org` | Organization name (mutually exclusive with `--org-id`) | string | `INFLUX_ORG` | | | `--org-id` | Organization ID (mutually exclusive with `--org`) | string | `INFLUX_ORG_ID` | | `-p` | `--profilers` | Flux query profilers to enable (comma-separated) | string | | | `-r` | `--raw` | Output raw query results (annotated CSV) | | | | | `--skip-verify` | Skip TLS certificate verification | | `INFLUX_SKIP_VERIFY` | | `-t` | `--token` | API token | string | `INFLUX_TOKEN` | ## Examples {{< cli/influx-creds-note >}} - [Query InfluxDB with a Flux string](#query-influxdb-with-a-flux-string) - [Query InfluxDB using a Flux file](#query-influxdb-with-a-flux-file) - [Query InfluxDB and return annotated CSV](#query-influxdb-and-return-annotated-csv) - [Query InfluxDB and append query profile data to results](#query-influxdb-and-append-query-profile-data-to-results) ##### Query InfluxDB with a Flux string ```sh influx query 'from(bucket:"example-bucket") |> range(start:-1m)' ``` ##### Query InfluxDB with a Flux file ```sh influx query --file /path/to/example-query.flux ``` ##### Query InfluxDB and return annotated CSV ```sh 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](/flux/v0/stdlib/profiler/#available-profilers)._ ```sh influx query \ --profilers operator,query \ 'from(bucket:"example-bucket") |> range(start:-1m)' ```