Forum Discussion
openrowset compatibility
Is OPENROWSET compatible with lakehouse files?
E.g. the following does not work
select *
from openrowset(
BULK 'https://onelake.dfs.fabric.microsoft.com/ws/lakehouse_testing.Lakehouse/File...
Hi smpa01
You should convert parquet to delta file. This is the script.
sdf= spark.read.parquet("Crime-Data-Boston-2016.parquet")
sdf.write.mode("overwrite").format("delta").saveAsTable("DimXYZ")
BhaveshPatel : There is a new feature in GA Openrowset to read the lakehouse files in sql endpoint. No need to convert parquet to delta etc. We are discussion why Openrowset is not yet working.