influxdb3 update table
The influxdb3 update table command updates an existing table in a database in your InfluxDB 3 Core instance.
Use this command to add tag and field columns to a table .
Usage
influxdb3 update table [OPTIONS] --database <DATABASE_NAME> <TABLE_NAME>Arguments
TABLE_NAME: (Required) The name of the table to update
Options
| Option | Description | |
|---|---|---|
-H | --host | Host URL of the running InfluxDB 3 Core server (default is http://127.0.0.1:8181) |
-d | --database | The name of the database containing the table |
--token | Authentication token | |
--tags | Comma-separated list of tag columns to add to the table. Takes one or more values, so place the table name before it or follow it with another option | |
-f | --fields | Comma-separated list of field columns and their data types to add to the table |
--tls-ca | Path to a custom TLS certificate authority (for testing or self-signed certificates) | |
--tls-no-verify | Disable TLS certificate verification (Not recommended in production, useful for self-signed certificates) | |
-h | --help | Print help information |
--help-all | Print detailed help information |
Option environment variables
You can use the following environment variables instead of providing CLI options directly:
| Environment Variable | Option |
|---|---|
INFLUXDB3_HOST_URL | --host |
INFLUXDB3_DATABASE_NAME | --database |
INFLUXDB3_AUTH_TOKEN | --token |
INFLUXDB3_TLS_CA | --tls-ca |
INFLUXDB3_TLS_NO_VERIFY | --tls-no-verify |
Examples
The following examples show how to update a table.
In your commands replace the following:
DATABASE_NAME: Database nameTABLE_NAME: Table nameAUTH_TOKEN: Authentication token
Add tag columns to a table
Adds two tag columns to a table. This works whether the database uses implicit or explicit schema mode.
influxdb3 update table \
--database DATABASE_NAME \
--token AUTH_TOKEN \
TABLE_NAME \
--tags rack,zoneAdd field columns to a table
Adds two field columns to a table.
influxdb3 update table \
--database DATABASE_NAME \
--token AUTH_TOKEN \
--fields temp:float64,active:bool \
TABLE_NAMEAdd tag and field columns in one command
influxdb3 update table \
--database DATABASE_NAME \
--token AUTH_TOKEN \
--tags rack \
--fields temp:float64 \
TABLE_NAMEAdding a column that already exists with the same data type is a no-op. Adding a column that already exists with a different data type returns an error.
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.