Skip to main content

Add Truncate Notebooks

Enable to generate notebooks that will truncate all existing tables in the workspace. Recommended for development environments only.

When enabled, the build generates a truncate notebook per target database that issues TRUNCATE TABLE for each generated table. Staged source objects and objects created from Source Create SQL are excluded. The notebooks are generated alongside the create and deploy notebooks and only take effect when run deliberately.

When to Change This Setting

Keep the default Y in development, where resetting the data while keeping the table structures supports repeated test loads. Disable it for production builds so no generated artifact is capable of emptying the warehouse tables.

SettingInteraction
Add Drop NotebooksThe equivalent option for drop notebooks

Notes

  • This setting is part of the Databricks settings category.
  • The default value for this setting is Y.