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.



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


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


List all columns per input table

import "sampledata"

    |> columns(column: "labels")

View example input and output

Was this page helpful?

Thank you for your feedback!

Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.