---
title: influxctl table create
description: The influxctl table create command creates a new table in the specified database.
url: https://docs.influxdata.com/influxdb3/clustered/reference/cli/influxctl/table/create/
estimated_tokens: 1134
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/clustered/reference/cli/influxctl/table/create/
date: '2025-06-30T15:05:37-06:00'
lastmod: '2025-06-30T15:05:37-06:00'
---

* influxctl 2.5.0+

The `influxctl table create` command creates a new table in the specified
database in an InfluxDB 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](/influxdb3/clustered/admin/custom-partitions/partition-templates/#time-part-templates), 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](/influxdb3/clustered/admin/custom-partitions/best-practices/).

#### Always provide a time format when using custom partitioning

If defining a custom partition template for your table with any of the`--template-*` flags, always include the `--template-timeformat` flag with a
time format to use in your partition template.
Otherwise, InfluxDB omits time from the partition template and won’t compact partitions.

## Usage

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

## Arguments

|     Argument     |        Description        |
|------------------|---------------------------|
|**DATABASE\_NAME**|Name of the target database|
| **TABLE\_NAME**  |        Table name         |

## Flags

|Flag|                       |                                                              Description                                                              |
|----|-----------------------|---------------------------------------------------------------------------------------------------------------------------------------|
|    |   `--template-tag`    |                                 Tag to add to partition template (can include multiple of this flag)                                  |
|    |`--template-tag-bucket`|Tag and number of buckets to partition tag values into separated by a comma–for example: `tag1,100` (can include multiple of this flag)|
|    |`--template-timeformat`|                                                Timestamp format for partition template                                                |
|`-h`|       `--help`        |                                                          Output command help                                                          |

*Also see [`influxctl` global flags](/influxdb3/clustered/reference/cli/influxctl/#global-flags).*

## Examples

* [Create a table](#create-a-table)
* [Create a table with a custom partition template](#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

```sh
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`:

```sh
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](/influxdb3/clustered/admin/custom-partitions/).*

[](#view-command-updates)

View command updates

#### v2.7.0

* Introduce the `--template-tag-bucket` flag to group tag values into buckets
  and partition by each tag bucket.

*Also see [`influxctl` global flags](/influxdb3/clustered/reference/cli/influxctl/#global-flags).*

#### Related

* [Define custom partitions](/influxdb3/clustered/admin/custom-partitions/define-custom-partitions/)
* [Partition templates](/influxdb3/clustered/admin/custom-partitions/partition-templates/)
| Argument | Description |
| --- | --- |
| Argument | Description |
| DATABASE_NAME | Name of the target database |
| TABLE_NAME | Table name |

| Flag |  | Description |
| --- | --- | --- |
| Flag |  | Description |
|  | --template-tag | Tag to add to partition template (can include multiple of this flag) |
|  | --template-tag-bucket | Tag and number of buckets to partition tag values into separated by a comma–for example:  tag1,100  (can include multiple of this flag) |
|  | --template-timeformat | Timestamp format for partition template |
| -h | --help | Output command help |
