https://community.databricks.com/t5/data-engineering/global-temp-view-issue/m-p/116093#M45241 <P>I am following the&nbsp;<A href="https://spark.apache.org/docs/latest/sql-getting-started.html#global-temporary-view" target="_self">doc1</A>&nbsp;and&nbsp;<A href="https://spark.apache.org/docs/3.5.3/sql-ref-syntax-ddl-create-view.html" target="_self">doc2</A>&nbsp;but I am getting an error.</P><P>I was under the impression from the documentation that it is doable in pure sql. What am I doing wrong?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smpa01_0-1745253862295.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/16123i6B2E5F08E3C71C55/image-size/medium?v=v2&amp;px=400" role="button" title="smpa01_0-1745253862295.png" alt="smpa01_0-1745253862295.png" /></span></P><P>I know how to do this in python using dataframe API and I am not looking for that solution.</P><P>Thank you in advance.</P><P>&nbsp;</P> Mon, 21 Apr 2025 16:47:05 GMT smpa01 2025-04-21T16:47:05Z https://community.databricks.com/t5/data-engineering/global-temp-view-issue/m-p/116093#M45241 <P>I am following the&nbsp;<A href="https://spark.apache.org/docs/latest/sql-getting-started.html#global-temporary-view" target="_self">doc1</A>&nbsp;and&nbsp;<A href="https://spark.apache.org/docs/3.5.3/sql-ref-syntax-ddl-create-view.html" target="_self">doc2</A>&nbsp;but I am getting an error.</P><P>I was under the impression from the documentation that it is doable in pure sql. What am I doing wrong?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smpa01_0-1745253862295.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/16123i6B2E5F08E3C71C55/image-size/medium?v=v2&amp;px=400" role="button" title="smpa01_0-1745253862295.png" alt="smpa01_0-1745253862295.png" /></span></P><P>I know how to do this in python using dataframe API and I am not looking for that solution.</P><P>Thank you in advance.</P><P>&nbsp;</P> Mon, 21 Apr 2025 16:47:05 GMT https://community.databricks.com/t5/data-engineering/global-temp-view-issue/m-p/116093#M45241 smpa01 2025-04-21T16:47:05Z https://community.databricks.com/t5/data-engineering/global-temp-view-issue/m-p/116096#M45242 <P>it is missing ;</P> Mon, 21 Apr 2025 17:54:21 GMT https://community.databricks.com/t5/data-engineering/global-temp-view-issue/m-p/116096#M45242 smpa01 2025-04-21T17:54:21Z