Fabric LakeHouse SQL Query

[Qkv_123]

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

[v-nikhilan-msft]

Hi @Qkv_123 

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.

[Qkv_123]

Hi @v-nikhilan-msft 

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

[Qkv_123]

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

[v-nikhilan-msft]

Hi @Qkv_123 

I understand about the date column. But what about the other columns? Should they be null for the new entry?

[Qkv_123]

Yes, null value in the date column should be filled with latest date

[Element115 · Accepted solution]

@v-nikhilan-msft 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?

[v-nikhilan-msft]

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.

[v-nikhilan-msft]

Hi @Qkv_123 ,
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