Dear Brahma,

Thank you very much for your detailed explanation and guidance. I truly appreciate the insights and suggestions you provided. I'll definitely try pointing the DLT logic to a new table with the updated FLOAT column, consider adding the .option("mergeSchema", "true") where applicable, and review any schema hints or expectations first. I want to exhaust these options before resorting to dropping the target table. Your help has been invaluable, and I might reach out if I need further assistance with scripting these adjustments safely.

 

Regards,
Hung Nguyen