Skip to main content

Use Temporary Views

When enabled, notebooks use the CREATE OR REPLACE TEMPORARY VIEW SQL statement to store intermediate data in memory for quicker access, rather than the CREATE TABLE IF NOT EXISTS statement which persists data on disk. Using temporary views reduces storage usage and can improve performance for short-lived intermediate results, but the data is lost when the Spark session ends. This setting is mutually exclusive with Use SQL Scripting — enabling both at the same time produces validation error SET_28002004.

Notes:

  • This setting is part of the Databricks settings category.
  • The default value for this setting is Y.
  • This setting is mutually exclusive with Use SQL Scripting. Enabling both produces validation error SET_28002004.