Executing Queries in c360 Configuration Table

Requirement:

 

Develop a PySpark script to execute SQL scripts of each metric stored in c360_config table and load them into a target table based on the load type (“overwrite“ or “append“). If the target table and load type is 'NA' then execute the sql query and just display the output

 

Unity catalog: c360_config