Excel-Driven Insert & Update for Metric Config & Master Tables

Requirement:

 

Use the values in the attached excel sheet and prepare a Databricks SQL queries to update the excel data in metric_config or metric_master tables

 

* In metric_config table, If metric_id in the excel sheet is new then we need to insert the data else update the existing record with excel data

* In metric_master table, If metric_template_name column and dependency column in the excel sheet is new then we need to insert the data else update the existing record with excel data