docs-v2/content/shared/influxdb3-cli/create/table.md

The influxdb3 create table command creates a table in a database.

Usage

influxdb3 create table [OPTIONS] \
  --tags [<TAGS>...] \
  --database <DATABASE_NAME> \
  <TABLE_NAME>

Arguments

• TABLE_NAME: The name of the table to create.

Options

Option		Description
-H	--host	Host URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
-d	--database	({{< req >}}) Name of the database to operate on
	--token	Authentication token
	--tags	({{< req >}}) Space-separated list of tag columns to include in the table
	--fields	Space-separated list of field columns to include in the table
-h	--help	Print help information

[!Important]

Tag and field naming requirements

Tag and field keys are alphanumeric and must start with a letter or number. They can contain dashes (-) and underscores (_).

Option environment variables

You can use the following environment variables to set command options:

Environment Variable	Option
INFLUXDB3_HOST_URL	--host
INFLUXDB3_DATABASE_NAME	--database
INFLUXDB3_AUTH_TOKEN	--token

Examples

• Create a table
• Create a table with tag and field columns

In the examples below, replace the following:

• {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}}: Database name
• {{% code-placeholder-key %}}TABLE_NAME{{% /code-placeholder-key %}}: Table name

{{% code-placeholders "(DATABASE|TABLE)_NAME" %}}

Create a table

influxdb3 create table \
  --tags tag1 tag2 tag3 \
  --database DATABASE_NAME
  TABLE_NAME

Create a table with tag and field columns

influxdb3 create table \
  --tags room sensor_id \
  --fields temp:float64 hum:float64 co:int64 \
  --database DATABASE_NAME
  TABLE_NAME

{{% /code-placeholders %}}