set() function

The set() function assigns a static value to each record in the input table. The key may modify an existing column or add a new column to the tables. If the modified column is part of the group key, the output tables are regrouped as needed.

*Function type: Transformation
**Output data type:* Record

  1. set(key: "myKey",value: "myValue")

Parameters

key

The label of the column to modify or set.

*Data type: String*

value

The string value to set.

*Data type: String*

Examples

  1. from(bucket: "example-bucket")
  2.   |> set(key: "host", value: "prod-node-1")