Documentation

Create a database

Use the influxdb3 create database command to create a database in InfluxDB 3 Core. Provide the following:

influxdb3 create database 
DATABASE_NAME
  • Copy
  • Fill window

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 InfluxDB 3 Core, 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 InfluxDB 3 Core 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 InfluxDB 3 Core database:

database_name/retention_policy_name
  • Copy
  • Fill window
Database naming examples
v1 Database namev1 Retention Policy nameNew database name
dbrpdb/rp
telegrafautogentelegraf/autogen
webmetrics1w-downsampledwebmetrics/1w-downsampled

Database limit

Maximum number of databases: 5

For more information about InfluxDB 3 Core database, table, and column limits, see Database, table, and column limits.


Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.2

Key enhancements in InfluxDB 3.2 and the InfluxDB 3 Explorer UI is now generally available.

See the Blog Post

InfluxDB 3.2 is now available for both Core and Enterprise, bringing the general availability of InfluxDB 3 Explorer, a new UI that simplifies how you query, explore, and visualize data. On top of that, InfluxDB 3.2 includes a wide range of performance improvements, feature updates, and bug fixes including automated data retention and more.

For more information, check out: