set() function

set() assigns a static column value to each row in the input tables.

set() may modify an existing column or add a new column. If the modified column is part of the group key, output tables are regrouped as needed. set() can only set string values.

Function type signature
(<-tables: stream[A], key: string, value: string) => stream[A] where A: Record
For more information, see Function type signatures.



(Required) Label of the column to modify or set.


(Required) String value to set.


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


Set a column to a specific string value

import "sampledata"
    |> set(key: "host", value: "prod1")

View example input and ouput

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.