Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Fabric LakeHouse SQL Query

Hi Team,   I have loaded XML file and SQL query to check the date availability if date is missing in the sequence then add and fill the value based on latest Known value (column). Table : XML  ...
one lake
  • Element115's avatar
    Element115
    2 years ago

    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?

Element115's avatar
Element115
Memorable Member
2 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,
    We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
    Thanks