A view that isn't saved to a catalog. It lives for the session in notebooks and jobs, for the query in Databricks SQL, and inside a Lakeflow pipeline (CREATE TEMPORARY VIEW or @dp.temporary_view) only that pipeline can see it.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Temporary view in context, with comparison tables and the common traps.
Terms in this definition
- View
Shows a system through one chosen group of related concerns. No view is generic; each one is tied to whichever architecture it depicts.
- Catalog
The first level of Unity Catalog's
catalog.schema.tablenaming and the primary boundary for isolating data. Privileges granted on a catalog flow down to every schema and object it contains. - Databricks SQL
Brings warehousing to an Azure Databricks lakehouse. ANSI SQL runs against Delta tables using SQL warehouses, compute tuned for heavy query concurrency and BI tools.
- Pipeline
Groups activities logically so that, together, they move and transform data, either one after another or side by side; found in both Azure Data Factory and Microsoft Fabric.
- CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
Related terms
- SQL view
Stores a query under a name, not its results, which is what sets it apart from a materialized view. Within a pipeline,
CREATE VIEWmakes it available to anyone withSELECT, whereas a temporary view stays internal.