- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 proceed" when trying to run the Spark SQL query.
Are there options to run this without attaching the Lakehouse?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-17-2024 05:22 AM | |||
08-19-2024 04:55 AM | |||
01-27-2025 01:24 AM | |||
01-10-2025 04:20 AM | |||
10-16-2024 04:44 AM |
User | Count |
---|---|
11 | |
6 | |
4 | |
2 | |
2 |
User | Count |
---|---|
10 | |
9 | |
7 | |
7 | |
5 |