Can a Notion workspace owner verify that database relations and formulas survive a backup restore?

Answer

A workspace owner cannot verify the survival of relations, formulas, and permissions using native Notion exports (Markdown, HTML, or CSV), as these formats flatten data and strip out the underlying logic and IDs. However, verification is possible by using the Notion API to capture a baseline of computed values and schemas before the restore, then comparing them against the restored state.

Explanation of Constraints

Because native exports do not preserve formula definitions or relation IDs, a standard "import" creates new pages with fresh IDs, which breaks existing internal links. Furthermore, the Notion API provides the result of a formula but not the raw formula string itself. Therefore, you cannot perform a text-based diff of the logic; you can only verify that the output remains consistent for the same input data.

Confirmed Facts

• Relations: Native exports omit relation properties; API-based restores require mapping new page IDs to maintain links.
• Formulas: Formula expressions are not exported via standard tools; only the computed value is accessible via API.
• Permissions: Granular roles (Editor, Viewer) are not preserved in exports and must be re-applied.

Verification Steps

1. Establish Baseline: Use GET /v1/databases/{database_id}/query to export the current schema and a sample of row values (including computed formula results) to a JSON file.
2. Perform Restore: Import your backup via the UI or API.
3. Capture Post-Restore State: Run the same API query on the restored databases.
4. Compare Metrics:
   • Schema: Ensure all property names and types match the baseline.
   • Formulas: Compare the computed values of sample rows. If the input data is identical but the output differs, the formula logic was lost.
   • Relations: Check if the relation property contains a valid page ID that exists within the restored workspace.
5. Audit Permissions: Use GET /v1/blocks/{block_id}/shared_with to verify the user list and manually confirm roles.

Missing Diagnostic Detail

Are you using a third-party backup tool or Notion's native "Export all workspace content" feature? If using a third-party tool, the verification method may change based on whether that tool preserves internal UUIDs.