--- title: influx bucket-schema create description: The influx bucket-schema create command sets the schema for a measurement in an InfluxDB bucket that has the explicit schema-type. url: https://docs.influxdata.com/influxdb3/cloud-serverless/reference/cli/influx/bucket-schema/create/ estimated_tokens: 2447 publisher: InfluxData canonical: https://docs.influxdata.com/influxdb3/cloud-serverless/reference/cli/influx/bucket-schema/create/ date: '2025-04-02T15:54:32-06:00' lastmod: '2025-04-02T15:54:32-06:00' --- * influx CLI 2.1.0+ The `influx bucket-schema create` command sets the schema for a measurement in an InfluxDB bucket that has the [`explicit` schema-type](/influxdb/cloud/reference/cli/influx/bucket/create/#create-a-bucket-with-an-explicit-schema). ## Usage ```sh influx bucket-schema create [flags] ``` ## Flags |Flag| | Description |Input type|Maps to [?](/influxdb/cloud-serverless/reference/cli/influx/#view-mapped-environment-variables)| |----|-------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------|-----------------------------------------------------------------------------------------------| |`-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](/influxdb/cloud/reference/cli/influx/bucket-schema/create/#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](#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](/influxdb/cloud-serverless/reference/cli/influx/#provide-required-authentication-credentials) 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](/influxdb/cloud-serverless/reference/urls/) * `-o, --org` or `--org-id`: InfluxDB organization name or ID * `-t, --token`: InfluxDB API token * [Create a schema using the influx CLI](#create-a-schema-using-the-influx-cli) * [Create a schema and print column information](#create-a-schema-and-print-column-information) * [Create a schema with columns format](#create-a-schema-with-columns-format) ### Create a schema using the influx CLI ```sh influx bucket-schema create \ --bucket example-bucket \ --name temperature \ --columns-file columns.csv ``` ### Create a schema and print column information ```sh 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](/influxdb/cloud/reference/cli/influx/bucket-schema/create). ```sh influx bucket-schema create \ --bucket example-bucket \ --name cpu \ --columns-file columns.json \ --columns-format ndjson ``` ```sh influx bucket-schema create \ --bucket example-bucket \ --name cpu \ --columns-file columns.txt \ --columns-format csv ``` #### Related * [Manage buckets](/influxdb3/cloud-serverless/admin/buckets/) * [influx CLI—Provide required authentication credentials](/influxdb3/cloud-serverless/reference/cli/influx/#provide-required-authentication-credentials) * [influx CLI—Provide required authentication credentials](/influxdb3/cloud-serverless/reference/cli/influx/#provide-required-authentication-credentials) | Flag | | Description | Input type | Maps to ? | | --- | --- | --- | --- | --- | | 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 |