AnalysisException: The schema of your Delta table has changed in an incompatible way since your DataFrame or DeltaTable object was created. Please redefine your DataFrame or DeltaTable object.

[ramankr48]

can anybody tell me why this error is coming and what's the reliable solution for it

[ramankr48]

I've found this one before but didn't found that much helpful.

[Anonymous]

Hi @Raman Gupta​ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!

[ramankr48 · Accepted solution]

I've used another method to insert the data,

used merge to insert as well as to update it simultaneously.