---
title: experimental.to() function
description: experimental.to() writes pivoted data to an InfluxDB 2.x or InfluxDB Cloud bucket.
url: https://docs.influxdata.com/flux/v0/stdlib/experimental/to/
estimated_tokens: 1747
product: Flux
version: v0
---

# experimental.to() function

-   Flux 0.40.0 – 0.174.0
-   View InfluxDB support

`experimental.to()` is [subject to change at any time](/flux/v0/stdlib/experimental/#experimental-packages-are-subject-to-change).

`experimental.to()` writes *pivoted* data to an InfluxDB 2.x or InfluxDB Cloud bucket.

#### Deprecated

`experimental.to()` is deprecated in favor of [`wideTo()`](/flux/v0/stdlib/influxdata/influxdb/wideto/), which is an equivalent function.

#### Requirements and behavior

-   Requires both a `_time` and a `_measurement` column.
-   All columns in the group key (other than `_measurement`) are written as tags with the column name as the tag key and the column value as the tag value.
-   All columns **not** in the group key (other than `_time`) are written as fields with the column name as the field key and the column value as the field value.

If using `from()` to query data from InfluxDB, use `pivot()` to transform data into the structure `experimental.to()` expects.

##### Function type signature

```js
(
    <-tables: stream[A],
    ?bucket: string,
    ?bucketID: string,
    ?host: string,
    ?org: string,
    ?orgID: string,
    ?token: string,
) => stream[A] where A: Record
```

For more information, see [Function type signatures](/flux/v0/function-type-signatures/).

## Parameters

### bucket

Name of the bucket to write to. *`bucket` and `bucketID` are mutually exclusive*.

### bucketID

String-encoded bucket ID to to write to. *`bucket` and `bucketID` are mutually exclusive*.

### host

URL of the InfluxDB instance to write to.

See [InfluxDB Cloud regions](/influxdb/cloud/reference/regions/) or [InfluxDB OSS URLs](/influxdb/v2/reference/urls/). `host` is required when writing to a remote InfluxDB instance. If specified, `token` is also required.

### org

Organization name. *`org` and `orgID` are mutually exclusive*.

### orgID

String-encoded organization ID to query. *`org` and `orgID` are mutually exclusive*.

### token

InfluxDB API token.

**InfluxDB 1.x or Enterprise**: If authentication is disabled, provide an empty string (`""`). If authentication is enabled, provide your InfluxDB username and password using the `<username>:<password>` syntax. `token` is required when writing to another organization or when `host` is specified.

### tables

Input data. Default is piped-forward data (`<-`).

## Examples

### Pivot and write data to InfluxDB

```js
import "experimental"

from(bucket: "example-bucket")
    |> range(start: -1h)
    |> pivot(rowKey: ["_time"], columnKey: ["_field"], valueColumn: "_value")
    |> experimental.to(bucket: "example-target-bucket")
```

#### Related

-   [to() function](/flux/v0/stdlib/influxdata/influxdb/to/)

[outputs](/flux/v0/tags/outputs/)