Add Newly Introduced Entry Column from Source Mapping Sheet to field_usage_report and Synchronize with Downstream View

Introduction: New entry column has been introduced in the source_mapping_sheet to support additional data mapping requirements. This change involves updating the underlying logic in the field_usage_report table to ensure the new column is properly integrated with the view.

 

Requirement: Read the source_mapping_sheet with newly added entry column with logic change in the table “field_usage_report“. Newly added entry column should reflect in the downstream view ”field_usage_report_view”, which was not in the view.

 

Prerequisite:

 

1. Drop the table field_usage_report_clone if exist.
2. Create replica of field_usage_report table in field_usage_report_clone table and perform the requirement in the replica table.

 

Final output: SQL logic, show the output of table and view.

 

Unity catalog: field_usage_report, field_usage_report_view