Forum Discussion
Jy
2 years agoMicrosoft Employee
Is LakeHouse required to run SparkSQL queries?
I have a notebook running with Spark SQL queries. I do not have a Lakehouse attached. Seeing the error "Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to...
- 2 years ago
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.
frithjof_v
2 years agoCommunity Champion
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.