influxdb3 create table
InfluxDB 3 Core is in Public Beta
InfluxDB 3 Core is in public beta and available for testing and feedback, but is not meant for production use yet. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the beta and invite you to join our public channels for updates and to share feedback.
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 InfluxDB 3 Core server (default is http://127.0.0.1:8181) |
-d | --database | (Required) Name of the database to operate on |
--token | Authentication token | |
--tags | (Required) Comma-separated list of tag columns to include in the table | |
--fields | Comma-separated list of field columns and their types to include in the table | |
-h | --help | Print help information |
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
In the examples below, replace the following:
DATABASE_NAME: Database nameTABLE_NAME: 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
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.