Which method would you use?

The sales team's sales_raw table arrives every night. Marketing needs it in LH_Marketing with unneeded columns removed and confusing names fixed.

Select each method and compare what lands in the lakehouse. Which method should the team use?