Forum Discussion
Microsoft EmployeeIs LakeHouse required to run SparkSQL queries?
Hi Jy
In my experience, you can use Spark SQL without attaching a Lakehouse to the Notebook.
I did it by using the abfss path to create a dataframe of my data.
Then I used this dataframe as the source to create a temporary view.
Then I could use the temporary view for doing Spark SQL.
Hi Jy ,
Running Spark SQL queries in Fabric does require attaching lakehouse.
Unfortunately, there is no other option to run Spark SQL queries in Fabric Lakehouse notebooks without attaching a lakehouse.Lakehouse provides the necessary context and storage for executing these queries.
If you want to run Spark SQL queries, attach a Lakehouse.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!