experimental.set() function

The experimental.set() function is subject to change at any time. By using this function, you accept the risks of experimental functions.

The experimental.set() function sets multiple static column values on all records. If a column already exists, the function updates the existing value. If a column does not exist, the function adds it with the specified value.

Once sufficiently vetted, experimental.set() will replace the existing set() function.

Function type: Transformation

import "experimental"

  o: {column1: "value1", column2: "value2"}



A record that defines the columns and values to set. The key of each key-value pair defines the column name. The value of each key-value pair defines the column value.

Data type: Record


Set values for multiple columns

Example input table
Example query
import "experimental"

  |> experimental.set(
    o: {
      _field: "temperature",
      unit: "°F",
      location: "San Francisco"
Example output table
2019-09-16T12:00:00Ztemperature71.2°FSan Francisco
2019-09-17T12:00:00Ztemperature68.4°FSan Francisco
2019-09-18T12:00:00Ztemperature70.8°FSan Francisco

New! Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: