Documentation

columns() function

columns() returns the column labels in each input table.

For each input table, columns outputs a table with the same group key columns and a new column containing the column labels in the input table. Each row in an output table contains the group key value and the label of one column of the input table. Each output table has the same number of rows as the number of columns of the input table.

Function type signature
(<-tables: stream[A], ?column: string) => stream[B] where A: Record, B: Record

For more information, see Function type signatures.

Parameters

column

Name of the output column to store column labels in. Default is “_value”.

tables

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

Examples

List all columns per input table

import "sampledata"

sampledata.string()
    |> columns(column: "labels")

View example input and output


Was this page helpful?

Thank you for your feedback!


New in InfluxDB 3.6

Key enhancements in InfluxDB 3.6 and the InfluxDB 3 Explorer 1.4.

See the Blog Post

InfluxDB 3.6 is now available for both Core and Enterprise. This release introduces the 1.4 update to InfluxDB 3 Explorer, featuring the beta launch of Ask AI, along with new capabilities for simple startup and expanded functionality in the Processing Engine.

For more information, check out:

InfluxDB Docker latest tag changing to InfluxDB 3 Core

On February 3, 2026, the latest tag for InfluxDB Docker images will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments.

If using Docker to install and run InfluxDB, the latest tag will point to InfluxDB 3 Core. To avoid unexpected upgrades, use specific version tags in your Docker deployments. For example, if using Docker to run InfluxDB v2, replace the latest version tag with a specific version tag in your Docker pull command–for example:

docker pull influxdb:2