rename() function

The rename() function renames specified columns in a table. If a column is renamed and is part of the group key, the column name in the group key will be updated.

There are two variants:

  • one which maps old column names to new column names
  • one which takes a mapping function.
rename(columns: {host: "server", facility: "datacenter"})

// OR

rename(fn: (column) => "{column}_new")


Make sure fn parameter names match each specified parameter. To learn why, see Match parameter names.


A map of columns to rename and their corresponding new names. Cannot be used with fn.


A function mapping between old and new column names. Cannot be used with columns.


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


The following examples use data provided by the sampledata package to show how rename() transforms data.

Rename specific columns

import "sampledata"
    |> rename(columns: {tag: "uid", _value: "val"})

View input and output

Rename all columns using a function

import "sampledata"
    |> rename(fn: (column) => "${column}_new")

View input and output

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.