influx bucket-schema create
- influx CLI 2.1.0+
- InfluxDB Cloud only
Works with InfluxDB Cloud bucket schemas
influx bucket-schema
and its subcommands work with InfluxDB Cloud bucket schemas. This feature is not available in InfluxDB OSS v2.3.
The influx bucket-schema create
command sets the schema for a measurement in an InfluxDB bucket that has the explicit schema-type.
Usage
influx bucket-schema create [flags]
Flags
Flag | Description | Input type | Maps to ? | |
---|---|---|---|---|
-c | —active-config | CLI configuration to use for command | string | |
-n | —bucket | (Required) Bucket name (mutually exclusive with —bucket-id ) | string | |
-i | —bucket-id | (Required) Bucket ID (mutually exclusive with —bucket ) | string | |
—columns-file | (Required) Path to column definitions file. For more information, see Create a columns file. | string | ||
—columns-format | Columns file format (csv , ndjson , json , default: auto ). For more information, see Create a schema with columns format | string | ||
—configs-path | Path to influx CLI configurations (default ~/.influxdbv2/configs ) | string | INFLUX_CONFIGS_PATH | |
-x | —extended-output | Print column information for each measurement schema (default: false) | ||
-h | —help | Help for the create command | ||
—hide-headers | Hide table headers (default false ) | INFLUX_HIDE_HEADERS | ||
—host | HTTP address of InfluxDB (default http://localhost:8086 ) | string | INFLUX_HOST | |
—json | Output data as JSON (default false ) | INFLUX_OUTPUT_JSON | ||
-n | —name | (Required) Measurement name | string | |
-o | —org | Organization name (mutually exclusive with —org-id ) | string | INFLUX_ORG |
—org-id | Organization ID (mutually exclusive with —org ) | string | INFLUX_ORG_ID | |
—skip-verify | Skip TLS certificate verification | INFLUX_SKIP_VERIFY | ||
-t | —token | API token | string | INFLUX_TOKEN |
Examples
Authentication credentials
The examples below assume your InfluxDB host, organization, and token are provided by either the active influx CLI configuration or by environment variables (INFLUX_HOST
, INFLUX_ORG
, and INFLUX_TOKEN
). If you do not have a CLI configuration set up or the environment variables set, include these required credentials for each command with the following flags:
--host
: InfluxDB host-o, --org
or--org-id
: InfluxDB organization name or ID-t, --token
: InfluxDB API token- Create a schema and print column information
- Create a schema with columns format
Create a schema using the influx CLI
influx bucket-schema create \
--bucket example-bucket \
--name temperature \
--columns-file columns.csv
Create a schema and print column information
influx bucket-schema create \
--bucket example-bucket \
--name cpu \
--columns-file columns.csv \
--extended-output
Create a schema with columns format
By default, InfluxDB attempts to detect the columns file format. If your file’s extension doesn’t match the format, set the format with the columns-format flag.
influx bucket-schema create \
--bucket example-bucket \
--name cpu \
--columns-file columns.json \
--columns-format ndjson
influx bucket-schema create \
--bucket example-bucket \
--name cpu \
--columns-file columns.txt \
--columns-format csv