docs-v2/content/shared/influxdb3-admin/databases/create.md

3.4 KiB

Use the influxdb3 create database command to create a database in {{< product-name >}}. Provide the following:

  • Database name (see Database naming restrictions)

  • {{< product-name >}} authorization token

    [!Note] While in alpha, {{< product-name >}} does not require an authorization token.

{{% code-placeholders "DATABASE_NAME" %}}

influxdb3 create database DATABASE_NAME

{{% /code-placeholders %}}

Database naming restrictions

Database names must adhere to the following naming restrictions:

  • Alphanumeric characters
  • Dashes (-), underscores (_), and forward slashes (/) are allowed
  • Must start with a letter or number
  • Maximum length of 64 characters

InfluxQL DBRP naming convention

In InfluxDB 1.x, data is stored in databases and retention policies. In {{% product-name %}}, databases and retention policies have been merged into databases; retention policies are no longer part of the data model. Because InfluxQL uses the 1.x data model, to support InfluxQL queries the use databases and retention policies, an {{< product-name >}} database must be mapped to a v1 database and retention policy (DBRP) to be queryable with InfluxQL.

When naming a database that you want to query with InfluxQL, use the following naming convention to automatically map v1 DBRP combinations to an {{% product-name %}} database:

database_name/retention_policy_name
Database naming examples
v1 Database name v1 Retention Policy name New database name
db rp db/rp
telegraf autogen telegraf/autogen
webmetrics 1w-downsampled webmetrics/1w-downsampled

Database limit

Maximum number of databases: {{% influxdb3/limit "database" %}}

For more information about {{< product-name >}} database, table, and column limits, see Database, table, and column limits.