Databricks View or Table

AzeemK 516 Reputation points
2021-08-09T23:20:54.273+00:00

I was wondering if there is a good white paper on Azure Databricks on when to build tables and when to build Views

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,080 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SUNOJ KUMAR YELURU 14,021 Reputation points MVP
    2021-08-10T13:31:20.84+00:00

    Hi @AzeemK

    An Azure Databricks database is a collection of tables. An Azure Databricks table is a collection of structured data. You can cache, filter, and perform any operations supported by Apache Spark DataFrames on Azure Databricks tables. You can query tables with Spark APIs and Spark SQL.
    https://learn.microsoft.com/en-us/azure/databricks/data/tables

    Constructs a virtual table that has no physical data based on the result-set of a SQL query. ALTER VIEW and DROP VIEW only change metadata.
    https://learn.microsoft.com/en-us/azure/databricks/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-view

    If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

    0 comments No comments