---
title: Query InfluxDB
description: Use from() and range to query data from InfluxDB using Flux.
url: https://docs.influxdata.com/flux/v0/query-data/influxdb/
estimated_tokens: 1249
product: Flux
version: v0
publisher: InfluxData
canonical: https://docs.influxdata.com/flux/v0/query-data/influxdb/
date: '2023-11-06T15:53:12-07:00'
lastmod: '2023-11-06T15:53:12-07:00'
---

To query data from InfluxDB using Flux, use [`from()`](/flux/v0/stdlib/influxdata/influxdb/from/)and [`range`](/flux/v0/stdlib/universe/range/).
Provide the following parameters to each function:

* **from()**:
  * **bucket** or **bucketID**: *InfluxDB bucket name* or *bucket ID* to query.

* **range()**:
  * **start**: Earliest time to return results from.

> [!Note]
> InfluxDB requires queries to be time-bound, so `from()` must always be followed by[`range()`](/flux/v0/stdlib/universe/range/).

```js
from(bucket: "example-bucket")
    |> range(start: -1h)
```

## Query InfluxDB Cloud or 2.x remotely

To query InfluxDB Cloud or 2.x remotely, provide the following parameters
in addition to **bucket** or **bucketID**.

* **host**: [InfluxDB Cloud region URL](/influxdb/cloud/reference/urls/) or[InfluxDB URL](/influxdb/v2/reference/urls/)
* **org** or **orgID**: InfluxDB organization name or ID
* **token**: InfluxDB [API token](/influxdb/cloud/admin/tokens/)

```js
from(
    bucket: "example-bucket",
    host: "http://localhost:8086",
    org: "example-org",
    token: "mYSup3r5Ecr3T70keN",
)
```

## Query InfluxDB 1.x

To query InfluxDB 1.x, use the `database-name/retention-policy-name` naming
convention for your bucket name.
For example, to query data from the `autogen` retention policy in the `telegraf` database:

```js
from(bucket: "telegraf/autogen")
    |> range(start: -30m)
```

To query the [default retention policy](/influxdb/v1/query_language/manage-database/#create-a-retention-policy) in a database, use the same bucket naming
convention, but do not provide a retention policy:

```js
from(bucket: "telegraf/")
    |> range(start: -30m)
```

## Results structure

`from()` and `range()` return a [stream of tables](/flux/v0/get-started/data-model/#stream-of-tables)grouped by [series](/influxdb/cloud/reference/glossary/#series)(measurement, tag set, and field).
Each table includes the following columns:

* **\_start**: Query range start time (defined by `range()`)
* **\_stop**: Query range stop time (defined by `range()`)
* **\_time**: Data timestamp
* **\_measurement**: Measurement name
* **\_field**: Field key
* **\_value**: Field value
* **Tag columns**: A column for each tag where the column label is the tag key
  and the column value is the tag value

#### Columns with the underscore prefix

Columns with the underscore (`_`) prefix are considered “system” columns.
Some Flux functions require these columns.

### Example InfluxDB query results

Hover over highlighted text to view description.

|      \_start       |       \_stop       |       \_time       |\_measurement|host |\_field|\_value|
|--------------------|--------------------|--------------------|-------------|-----|-------|-------|
|2021-01-01T00:00:00Z|2021-01-02T00:00:00Z|2021-01-01T00:00:00Z|     foo     |host1|  bar  |  1.2  |
|2021-01-01T00:00:00Z|2021-01-02T00:00:00Z|2021-01-01T01:00:00Z|     foo     |host1|  bar  |  1.6  |
|2021-01-01T00:00:00Z|2021-01-02T00:00:00Z|2021-01-01T02:00:00Z|     foo     |host1|  bar  |  2.1  |

|      \_start       |       \_stop       |       \_time       |\_measurement|host |\_field|\_value|
|--------------------|--------------------|--------------------|-------------|-----|-------|-------|
|2021-01-01T00:00:00Z|2021-01-02T00:00:00Z|2021-01-01T00:00:00Z|     foo     |host2|  bar  |  1.2  |
|2021-01-01T00:00:00Z|2021-01-02T00:00:00Z|2021-01-01T01:00:00Z|     foo     |host2|  bar  |  1.7  |
|2021-01-01T00:00:00Z|2021-01-02T00:00:00Z|2021-01-01T02:00:00Z|     foo     |host2|  bar  |  2.1  |

#### Structure results like InfluxQL

[InfluxQL](/influxdb/v1/query_language/) returns each field as
a column where the column label is the field key and the column value is the field value.
To structure results similarly with Flux, use [`pivot()`](/flux/v0/stdlib/universe/pivot/)or [`schema.fieldsAsCols()`](/flux/v0/stdlib/influxdata/influxdb/schema/fieldsascols/)to pivot fields into columns.

#### Related

* [Optimize Flux queries for InfluxDB](/influxdb/cloud/query-data/optimize-queries/)
| _start | _stop | _time | _measurement | host | _field | _value |
| --- | --- | --- | --- | --- | --- | --- |
| _start | _stop | _time | _measurement | host | _field | _value |
| 2021-01-01T00:00:00Z | 2021-01-02T00:00:00Z | 2021-01-01T00:00:00Z | foo | host1 | bar | 1.2 |
| 2021-01-01T00:00:00Z | 2021-01-02T00:00:00Z | 2021-01-01T01:00:00Z | foo | host1 | bar | 1.6 |
| 2021-01-01T00:00:00Z | 2021-01-02T00:00:00Z | 2021-01-01T02:00:00Z | foo | host1 | bar | 2.1 |

| _start | _stop | _time | _measurement | host | _field | _value |
| --- | --- | --- | --- | --- | --- | --- |
| _start | _stop | _time | _measurement | host | _field | _value |
| 2021-01-01T00:00:00Z | 2021-01-02T00:00:00Z | 2021-01-01T00:00:00Z | foo | host2 | bar | 1.2 |
| 2021-01-01T00:00:00Z | 2021-01-02T00:00:00Z | 2021-01-01T01:00:00Z | foo | host2 | bar | 1.7 |
| 2021-01-01T00:00:00Z | 2021-01-02T00:00:00Z | 2021-01-01T02:00:00Z | foo | host2 | bar | 2.1 |