Hi @yit ,

Maybe give a try to a new VARIANT data type? VARIANT is flexible to schema and type changes and maintains case sensitivity and NULL values present in the data source, this pattern is robust to most ingestion scenarios (at lease according to documentation 🙂 

Ingest data as semi-structured variant type | Databricks Documentation