https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-a-temporary-view-and-a-global/m-p/22116#M15109 <P>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 - <A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-view.html" target="test_blank">https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-view.html</A></P> Sun, 20 Jun 2021 03:57:34 GMT aladda 2021-06-20T03:57:34Z https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-a-temporary-view-and-a-global/m-p/22115#M15108 Sun, 20 Jun 2021 03:55:47 GMT https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-a-temporary-view-and-a-global/m-p/22115#M15108 aladda 2021-06-20T03:55:47Z https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-a-temporary-view-and-a-global/m-p/22116#M15109 <P>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 - <A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-view.html" target="test_blank">https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-view.html</A></P> Sun, 20 Jun 2021 03:57:34 GMT https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-a-temporary-view-and-a-global/m-p/22116#M15109 aladda 2021-06-20T03:57:34Z