---
title: influx query
description: The influx query command executes a literal Flux query provided as a string or a literal Flux query contained in a file by specifying the file prefixed with an ‘@’ sign.
url: https://docs.influxdata.com/influxdb/cloud/reference/cli/influx/query/
estimated_tokens: 2139
product: InfluxDB Cloud (TSM)
version: cloud
---

# influx query

-   influx CLI 2.0.0+
-   Updated in CLI v2.0.5

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.

```js
// ...
    |> drop(columns: ["_start", "_stop"])
```

## Flags

| Flag |  | Description | Input type | Maps to ? |
| --- | --- | --- | --- | --- |
| -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

#### Authentication credentials

The examples below assume your InfluxDB **host**, **organization**, and **token** are provided by either the [active `influx` CLI configuration](/influxdb/cloud/reference/cli/influx/#provide-required-authentication-credentials) 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](/influxdb/cloud/reference/urls/)
-   `-o, --org` or `--org-id`: InfluxDB organization name or ID
-   `-t, --token`: InfluxDB API token

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

#### Related

-   [Query data in InfluxDB](/influxdb/cloud/query-data/)
-   [Use the influx query command](/influxdb/cloud/query-data/execute-queries/influx-query/)
-   [influx CLI—Provide required authentication credentials](/influxdb/cloud/reference/cli/influx/#provide-required-authentication-credentials)
-   [influx CLI—Flag patterns and conventions](/influxdb/cloud/reference/cli/influx/#flag-patterns-and-conventions)

[query](/influxdb/cloud/tags/query/)