UmaMahesh1
Honored Contributor III

Hi @manoj kumar​ 

An easiest way would be to make use of unmanaged delta tables and while loading data into the path of that table, you can enable mergeSchema to be true. This handles all the schema differences, incase column is not present as null and if new column pops up, then all the previous records as null etc.

Uma Mahesh D