Create a view on the marketing table selecting only those fields approved for the sales team; alias the names of any fields that should be standardized to the sales naming conventions.

Create a new table with the required schema and use Delta Lake's DEEP CLONE functionality to sync up changes committed to one table to the corresponding table.

Use a CTAS statement to create a derivative table from the marketing table; configure a production job to propagate changes.

Add a parallel table write to the current production pipeline, updating a new sales table that varies as required from the marketing table.