Great article! I think the Lakehouse.Contents() default behaviour is to query the SQL Analytics Endpoint, if querying a delta table in the Table section of the Lakehouse. https://www.reddit.com/r/MicrosoftFabric/s/55pqnnGhWz https://www.reddit.com/r/MicrosoftFabric/s/PgWSz1bHwl As you mention, and as Chris Webb wrote in the blog you linked to, using Value.Version can force it to bypass the SQL Analytics Endpoint. I guess query folding won't work then. And we would also need to know which table version number to query.

Great blog! I'm wondering, is it possible to switch the default Lakehouse multiple times within a Notebook run? If I understand correctly, changing the default Lakehouse by using the '%% configure' approach will only work properly if this is done in the first cell in the Notebook. I guess that means we can only set the default Lakehouse once in a Notebook run. Some users want to be able to switch default Lakehouse programmatically multiple times within a Notebook run, in order to use Spark SQL on multiple Lakehouses within the same Notebook run.

Sandeep Pawar Yes, thanks a lot!

Thanks for a great blog! I'm wondering, is it possible to mount a lakehouse as the Notebook's default lakehouse by using this approach (or another code approach)? If I understand correctly, the mounting operation which is shown in this blog makes it possible to work with the Lakehouse's directories by using relative path, which makes it possible to use the os module (e.g. list directory) and Pandas, however it doesn't enable the use of Spark SQL as that would require to mount the lakehouse as the Notebook's default lakehouse. All of this is new to me, so trying to wrap my head around this. Best regards, Frithjof