Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article gives an overview of tables, and views in Azure Databricks.
A table is a structured dataset stored in a specific location. The default table type created in Azure Databricks is a Unity Catalog managed table. Tables can be queried and manipulated using SQL commands or DataFrame APIs, supporting operations like INSERT, UPDATE, DELETE, and MERGE INTO. See Introduction to Azure Databricks tables
A view is a virtual table defined by a query that does not store data and can present data from one or more tables in a specific format or abstraction. Views are useful for simplifying complex queries, encapsulating business logic, and providing a consistent interface to the underlying data without duplicating storage. See What is a view?