What is the difference between a Temporary View and a Global Temporary View in Spark

[aladda · Accepted solution]

In Databricks, each cluster creates an initial spark session. And each notebook creates a spark subsession within the same. A temporary View created in one notebook isn't accessible to others. If you need to share view across notebooks, you use Global Temporary View instead. Additional details can be found here - https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-view.ht...