influxctl table create

The influxctl table create command creates a new table in the specified database in an InfluxDB Cloud Dedicated cluster.

Custom partitioning

You can override the default partition template (the partition template of the target database) with the --template-tag, --template-tag-bucket, and --template-timeformat flags when you create the table. Provide a time format using Rust strftime, partition by specific tag, or partition tag values into a specified number of “buckets.” Each of these can be used as part of the partition template. Be sure to follow partitioning best practices.

Usage

influxctl table create [flags] <DATABASE_NAME> <TABLE_NAME>

Arguments

Flags

Examples

• Create a table
• Create a table with a custom partition template

In the following examples, replace:

• DATABASE_NAME: The name of the database to create the table in.
• TABLE_NAME : The name of table to create.

Create a table

influxctl table create 
DATABASE_NAME
 
TABLE_NAME

Create a table with a custom partition template

The following example creates a new table and applies a partition template that partitions by two tags (room and sensor-type) and by day using the time format %Y-%m-%d:

influxctl table create \
  --template-tag room \
  --template-tag sensor-type \
  --template-tag-bucket customerID,1000 \
  --template-timeformat '%Y-%m-%d' \
  
DATABASE_NAME
 \
  
TABLE_NAME

For more information about custom partitioning, see Manage data partitioning.