Explore your data schema with Flux

API token hashing is enabled by default in InfluxDB OSS 2.9.0

Stronger token security: tokens are stored as hashes on disk, so a copy of the database file doesn’t expose usable tokens. Existing tokens are hashed on first startup and the original strings can’t be recovered afterward — capture any plaintext tokens you still need before you upgrade.

For more information, see Token hashing.

Flux provides functions that let you explore the structure and schema of your data stored in InfluxDB.

Functions in the schema package are not supported in the Flux REPL.

List buckets

Use buckets() to list buckets in your organization.

buckets()

View example buckets() output

List measurements

Use schema.measurements() to list measurements in a bucket. By default, this function returns results from the last 30 days.

import "influxdata/influxdb/schema"

schema.measurements(bucket: "example-bucket")

View example schema.measurements() output

List field keys

Use schema.fieldKeys to list field keys in a bucket. By default, this function returns results from the last 30 days.

import "influxdata/influxdb/schema"

schema.fieldKeys(bucket: "example-bucket")

View example schema.fieldKeys() output

List fields in a measurement

Use schema.measurementFieldKeys to list field keys in a measurement. By default, this function returns results from the last 30 days.

import "influxdata/influxdb/schema"

schema.measurementFieldKeys(
    bucket: "example-bucket",
    measurement: "example-measurement",
)

View example schema.measurementFieldKeys() output

List tag keys

Use schema.tagKeys() to list tag keys in a bucket. By default, this function returns results from the last 30 days.

import "influxdata/influxdb/schema"

schema.tagKeys(bucket: "example-bucket")

View example schema.tagKeys() output

List tag keys in a measurement

Use schema.measurementTagKeys to list tag keys in a measurement. By default, this function returns results from the last 30 days.

import "influxdata/influxdb/schema"

schema.measurementTagKeys(
    bucket: "example-bucket",
    measurement: "example-measurement",
)

View example schema.measurementTagKeys() output

List tag values

Use schema.tagValues() to list tag values for a given tag in a bucket. By default, this function returns results from the last 30 days.

import "influxdata/influxdb/schema"

schema.tagValues(bucket: "example-bucket", tag: "example-tag")

View example schema.tagValues() output

List tag values in a measurement

Use schema.measurementTagValues to list tag values for a given tag in a measurement. By default, this function returns results from the last 30 days.

import "influxdata/influxdb/schema"

schema.measurementTagValues(
    bucket: "example-bucket",
    tag: "example-tag",
    measurement: "example-measurement",
)

View example schema.measurementTagValues() output

    Was this page helpful?

    Thank you for your feedback!