Once you decide to migrate from On-Prem to Big Query the first and foremost process to plan out would be Schema migration, its critical…