Create f_invntry_bal_dly_hist using mapping Excel

Requirement: Develop a Databricks SQL to display all fields as output based on the field mappings provided in the attached Excel file.

 

_The excel file has 3 sheets:_

 

1. Data_map – This file contains the source-to-target mapping.
2. Source – It includes the source table along with any filters and special handling required for the table.
3. Joins – This tab defines the joining conditions, and the type of join used.