Dynamic Management of Metric Config & Master Tables: Insert/Update Based on Excel

Requirement:

Use the values in the attached excel sheet and prepare a Databricks SQL queries to update the excel data in metric_config_clone or metric_master_clone tables.

In metric_config_clone 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_clone 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

Final Output: Perform only Requirement without syntax error.