Databricks View or Table

AzeemK 516 Reputation points

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.
1,971 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SUNOJ KUMAR YELURU 13,961 Reputation points MVP

    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.

    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.

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

    0 comments No comments