Forum Discussion
Fabric LakeHouse SQL Query
Anonymous If I remember correctly, we can't write to a LH table from the LH SQL endpoint. I think we can only create views, functions, and stored procedures in the SQL endpoint. But we can write to a LH table using PySpark in a notebook.
Or am I mistaken?
I the above table missing 16th Date
So I need to add in SQL query and fill the value
Hi Anonymous
I understand about the date column. But what about the other columns? Should they be null for the new entry?
Yes, null value in the date column should be filled with latest date
Anonymous If I remember correctly, we can't write to a LH table from the LH SQL endpoint. I think we can only create views, functions, and stored procedures in the SQL endpoint. But we can write to a LH table using PySpark in a notebook.
Or am I mistaken?
You are right Element115 .
As mentioned by Element115 DML statements are not yet supported in Lakehouse SQL endpoint. You can write into a Lakehouse table using Notebooks.
Hope this helps. Please let me know if you have any other questions.