Hey this code is awesome it has helped me implement my code. Thanks so much for sharing. I was able to reach my SQL end point and created queries directly from my notebook. So helpful, thank you! I have been trying to create a function or for loop with this code you provided but I have been struggling since its quite pro level. I was wondering if you had done this before or had any pointers? thank you again!
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.
reddit.com/r/MicrosoftFabric/s/55pqnnGhWz
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.
German Munoz
Article is very useful and helped me reach my SQL end point. I am trying to create a function from this but my coding in scala is limited so I haven't been able to