Skip to main content

Temp Table Schema

Specifies the schema name for temporary tables when using Unity Catalog.

On a Unity Catalog target, the temporary tables the generated load processes create (when the load pattern materializes temp tables rather than temporary views) are qualified with this schema. The deploy notebook creates the schema with CREATE SCHEMA IF NOT EXISTS when a value is set.

When to Change This Setting​

Keep the default default to use the workspace's standard schema for the transient load tables. Change it to isolate the transient tables in a dedicated schema, keeping them apart from the warehouse tables for visibility and cleanup.

SettingInteraction
Use Unity CatalogThe schema qualification only applies on Unity Catalog targets
Use Temporary ViewsLoads based on temporary views do not create the temp tables this schema holds

Notes​

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