Enhancing Onboarded Table with Additional Fields

Introduction: Existing onboarded table by adding new fields will accommodate additional data attributes required for downstream processing and reporting. The newly added fields will also support improved data validation, reporting, and analytics.

 

Requirements: Read the table “purgo_playground.patient_data“. Add the following fields to the onboarded patient_data table:

 

1. ingestion_date (Timestamp)
2. source_system (String)
3. record_status (String)
4. created_by (String)
5. modified_by (String)

 

Final Output: Display the output

 

Prerequisite:

 

1. Drop the table patient_data_clone if exist.
2. Create replica of patient_data table in patient_data_clone table and perform the requirement in the replica table.

 

 

 

Unity Catalog: “purgo_playground.patient_data“