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 
columns : Rate, Date, Curr code
Task: if table missing sequence date then add and fill the rate from latest kown date.

 

 

Kindly advise me.

 

Thanks,

Qkv_123

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?

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

    Thanks for using Fabric Community.

    Can you please explain your ask further? What should be the expected output? Please provide these details, so that I can help you better.

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 

      I have table in that table Date column missing sequence date, I have to fill the date

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I the above table missing 16th Date
        So I need to add in SQL query and fill the value