Create a new field "HCC_Account_Id" in user table and logic update for "HCC_Account_name" field

Requirements: Refer the attached Source_Target_Mapping Excel sheet. Develop Pyspark script to calculate column.

 

Unity Catalog: “pat_accounts“,”user”