Undelete a table
Use the Admin UI or the influxctl table undelete command
to restore a previously deleted table in your InfluxDB Cloud Dedicated cluster.
To undelete a table:
- A new table with the same name cannot already exist.
- You must have appropriate permissions to manage databases.
When you undelete a table, it is restored with the same partition template and other settings as when it was deleted.
Tables can only be undeleted for approximately 7 days after they are deleted. After this grace period, all Parquet files associated with the deleted table are permanently removed and the table cannot be undeleted.
Access the InfluxDB Cloud Dedicated Admin UI at console.influxdata.com. If you don’t have login credentials, contact InfluxData support.
In the table list for a database, find the deleted table you want to restore. Deleted tables are shown with a “Deleted” status indicator. You can sort on column headers or use the Search field to find a specific table.
- In the options menu (three vertical dots to the right of the table), click Restore Table. The Restore Table dialog displays.
- In the Restore Table dialog, review the table name and deletion date.
- Click the Restore Table button to restore the table.
If you haven’t already, download and install the
influxctlCLI.Use the
influxctl table undeletecommand to restore a deleted table. Provide the following:- The name of the database associated with the deleted table
- The ID of the deleted table to restore
influxctl table undelete DATABASE_NAME TABLE_IDReplace the following:
DATABASE_NAME: Name of the database associated with the deleted tableTABLE_ID: ID of the deleted table to restore
View deleted table IDs
To view the IDs of deleted tables, use the influxctl table list command with
the --filter-status=deleted flag–for example:
influxctl table list --filter-status=deleted DATABASE_NAMEReplace DATABASE_NAME
with the name of the database associated with the table you want to undelete.
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 Cloud Dedicated and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.