schema.tagValues() function

The schema.tagValues() function returns a list of unique values for a given tag. The return value is always a single table with a single column, _value.

import "influxdata/influxdb/schema"

schema.tagValues(
  bucket: "example-bucket",
  tag: "host",
  predicate: (r) => true,
  start: -30d
)

Parameters

bucket

Bucket to return unique tag values from.

tag

Tag to return unique values from.

predicate

Predicate function that filters tag values. Default is (r) => true.

start

Oldest time to include in results. Default is -30d.

Relative start times are defined using negative durations. Negative durations are relative to now. Absolute start times are defined using time values.

Examples

import "influxdata/influxdb/schema"

schema.tagValues(
  bucket: "my-bucket",
  tag: "host",
)

Function definition

package schema

tagValues = (bucket, tag, predicate=(r) => true, start=-30d) =>
  from(bucket: bucket)
    |> range(start: start)
    |> filter(fn: predicate)
    |> keep(columns: [tag])
    |> group()
    |> distinct(column: tag)