ViinayKumaarMamidi/Databricks_Healthcare_DLT_Pipeline_Project ? reverse-engineered prompt

Build me a Databricks healthcare data pipeline that processes daily patient admission files and a diagnosis lookup file using a Bronze, Silver, Gold flow.

I want it to ingest the raw CSV data, apply basic data quality checks, and drop bad rows when required fields are missing. Then enrich the patient records with human readable diagnosis descriptions, and create a few summary tables for things like patient counts and average age by admission date, diagnosis, and gender.

Please make it work as a Delta Live Tables style pipeline, with one notebook for the main processing and another notebook to load the sample source data into raw tables. Include clear table names, simple comments, and make it easy to run in Databricks with Unity Catalog. If you need to, look up current Databricks docs online so the setup matches how DLT works now.