Azure Mapping JSON – convert empty string or whitespace cells from CSV’s to null
I’m importing multiple addressbase CSV files that don’t have headers via Azure Synapse and ADLS so using MAPPING_JSON in an ETL.Process table with SQL Server Management Studio 20.1.10.0.