Forum Discussion
execute delta table using Select statement in fabric notebook
Hi Team I want to execute select statement using deltatable path in fabric notebook . it gives an error. Please help on urgent basis . below is select satament in Pyspark : df= spark.sql "(SELE...
Hi Udaysutar28apr ,
You can try the following solution for the same error, change it to the default Lakehouse and be able to use relative file paths afterward.
Refer to:
Solved: Re: Fabric tutorial failing on files path - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i want to execute delta table using below code :
df= spark.sql "(SELECT * FROM abfss://<workspace_name>@msit-onelake.dfs.fabric.microsoft.com/<lakehouse_Name>.Lakehouse/Tables/<table_Name>")
display(df)