top of page

Dynamic insert/update of File Ingestion config tables using excel sheet

Requirement

Requirement:

Read the attached all the records in the “ingest_config_data“ excel data and prepare a Databricks SQL script to insert/update ingest_config_master table.


In ingest_config_master table, If config_id is new then we need to insert the data else update the existing record with excel data. 


Prerequisite: 

Drop the table ingest_config_master_clone if exist. 

Perform the requirement in replica of ingest_config_master table in {{ingest_config_master_clone.}}

Purgo AI Agentic Code

bottom of page