dbt model runs in databricks is failing because columns have spaces in them
I cannot remove spaces from columns because they are used in various places downstream. Ideally i would like a configuration to set TBLPROPERTIES while running models
Some example code or error messages
Found invalid character(s) among ' ,;{}()\n\t=' in the column names of your schema.
11:25:51 Please enable Column Mapping on your Delta table with mapping mode 'name'.
11:25:51 You can use one of the following commands.
11:25:51
11:25:51 If your table is already on the required protocol version:
11:25:51 ALTER TABLE table_name SET TBLPROPERTIES ('delta.columnMapping.mode' = 'name')
11:25:51
11:25:51 If your table is not on the required protocol version and requires a protocol upgrade:
11:25:51 ALTER TABLE table_name SET TBLPROPERTIES (
11:25:51 'delta.columnMapping.mode' = 'name',
11:25:51 'delta.minReaderVersion' = '2',
11:25:51 'delta.minWriterVersion' = '5')