---
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/influxdb/cloud/reference/cli/influx/bucket-schema/create/
estimated_tokens: 2499
product: InfluxDB Cloud (TSM)
version: cloud
---

# influx bucket-schema create

-   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 ? |
| --- | --- | --- | --- | --- |
| -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](/influxdb/cloud/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/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