Excel Integration for Account Table: Add 4 New Fields

Introduction: creating a 4 new data in the table of patient related details by uploading a file serves several critical purposes, enabling better healthcare delivery and efficient management of Centralized Account Information by providing consolidates account data into a single table.

 

Requirement:

 

Develop Databricks SQL code by create the table ‘Account' using ‘Column Name’ and ‘Datatype’ and add 4 new ‘Column Name’ to the existing table 'Account' from ‘patient_addition_field’ table in attached excel file.

 

Expected Output: Write the Databricks SQL to Create the table and alter the table ‘purgo_playground.Account’, drop the table if already exists.

 

[^patient_addition_field.xlsx] [^patient_reg.xlsx]