When working in a Fabric Lakehouse and right clicking on a table and "Load Data" in the Explorer you currentely get a bunch of Python code in return.
%%pyspark
df = spark.sql("SELECT * FROM [Lakehouse].[Database].[Table] LIMIT 1000")
display(df)
Please make it possible to return this in pure SQL instead. Writing SQL in Python when you are working in Notebooks seems unnecessary as you can change the code language for every cell, and this should at least not happen when Spark SQL has been picked as the Notebook Language.
SriV
on:
Connecting to AML Workspace from Fabric Notebook u...
on:
REST API for removing all tags