Lakehouse Delta table changes are not reflecting in SQL Analytics Endpoint

Hi Debasish_p ,

Thanks for the reply from frithjof_v .

In addition to using Overwrite, you'll have to check that the following architectures match, and that the saves you've made have not been changed. My test was successful, here are my test steps:

Here's my raw tabular data:

When I change the column names and then save the changes using the following statement, I get an architecture mismatch error:

Use the following statement to save your changes without any problems:

df.write.format(“delta”).option(“mergeSchema”, “true”).mode(“overwrite”).save(“Tables/products”)

You can also verify that the changes were successful:

df = spark.read.format(“delta”).load(“Tables/products”)
df.show()

The last table you see at the SQL endpoint looks like this:

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!