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

[Kaniz]

Hi @Raman Gupta​, You will find the answer here in this GitHub link. Please let us know if that helps.

[ramankr48]

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

[Kaniz]

@Raman Gupta​ , Thank you for your response. Let us help you with this.

[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.