Manage databases
InfluxDB 3 Enterprise is in Public Alpha
InfluxDB 3 Enterprise is in public alpha and available for testing and feedback, but is not meant for production use. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the alpha and invite you to join our public channels for updates and to share feedback.
An InfluxDB 3 Enterprise database is a named location where time series data is stored. Each database can contain multiple tables.
If coming from InfluxDB v1, the concepts of databases and retention policies have been combined into a single concept–database. Retention policies are no longer part of the InfluxDB data model. However, InfluxDB 3 Enterprise does support InfluxQL, which requires databases and retention policies. See InfluxQL DBRP naming convention.
If coming from InfluxDB v2, InfluxDB Cloud (TSM), or InfluxDB Cloud Serverless, database and bucket are synonymous.
Database, table, and column limits
InfluxDB 3 Enterprise places the following limits on databases, tables, and columns:
Database limit
Maximum number of databases: 100
Table limit
Maximum number of tables across all databases: 4000
InfluxDB 3 Enterprise limits the number of tables you can have across all databases to 4000. There is no specific limit on how many tables you can have in an individual database, as long as the total across all databases is below the limit.
Having more tables affects your InfluxDB 3 Enterprise installation in the following ways:
Column limit
Maximum number of columns per table: 500
Each row must include a time column, with the remaining columns representing tags and fields. As a result, a table can have one time column and up to 499 combined field and tag columns. If you attempt to write to a table and exceed the column limit, the write request fails and InfluxDB returns an error.
Higher numbers of columns has the following side-effects:
Create a database
Use the influxdb3 create database
command to create a new database in InfluxDB 3 Enterprise.
influxdb3 create database DATABASE_NAME
List databases
Use the influxdb3 show databases
command to list databases in InfluxDB 3 Enterprise.
influxdb3 show databases
Delete a database
Use the influxdb3 delete database
command to delete a database from InfluxDB 3 Enterprise. Provide the name of the database you want to delete.
influxdb3 delete database DATABASE_NAME
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 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.