Data retention
Enable 30 day data retention policies within Hex.
- Available on select Enterprise plans. Contact [email protected] to request access.
Data retention allows Hex Admins to enable 30 day data retention policies for both cell outputs and cached warehouse data. When these data retention policies for cell outputs and cached warehouse data are enabled, respective data that is older than 30 days will be permanently deleted.
Admins can enable and disable data retention in the Data retention section of settings under Access & Security.
When a given data retention policy is enabled, all relevant data will be permanently deleted from Hex after 30 days and Hex has no liability for any deleted data thereafter.
Cached warehouse data
Hex writes the results of all warehouse SQL queries to the cache to optimize future query runtimes and app performance. By default, cached warehouse data that has not been read from Hex in the past 30 days is deleted. When data retention for cached warehouse data is enabled, all cache results are deleted 30 days after they are written, regardless of the last time they were read. When caching is enabled on a project but the cache entry has been deleted, queries are executed in your warehouse.
Cell outputs
When data retention is not enabled for cell outputs, this data is stored indefinitely. When enabled, cell outputs are deleted 30 days after they are created.
Notebook
When a user opens a Notebook after cell outputs have been deleted, no output will be displayed, as displayed in the screenshot below. In order to display outputs again, the Notebook will have to be rerun.
Published apps
When a user opens an app after cell outputs have been deleted, no cell outputs will be displayed and the user will see a banner at the top of the page indicating this. In order to display output again, the app will have to be manually rerun. To update the default state of the app with new cell outputs, the app will need to be republished, updated via scheduled run or API-triggered run, or run with the Run and update published results option via the app's three-dot menu by a user with "Can edit" or "Full access" to the project.