Name Column Mapping Mode in SQL Endpoints for Lakehouse is not supported so tables with unsupported columns names (spaces, special chars, capitalization) do not work. To re-create the behaviour...
More details in case others are looking for this same issue:
(1) The tables in question were created from a python notebook (PySpark) with the columnMapping mode set to "name".
(2) Tables load successfully and show up properly in the explorer window on the left pane in the same window where the notebook executed.
(3) Switching over to the Lakehouse SQL Query window, we get errors popping up that tables could not be loaded.
Example error popups have this message for each table that was loaded by the notebook.
Table uses column mapping which is not supported.
- Warehouse: Product
- Error Code:
- Subcode: 0
- Exception Type:
- Sync Error Time: Wed May 22 2024 17:58:55 GMT-0500 (Central Daylight Time)
- Hresult: -2147467259
- Table Sync State: Failure
- Sql Sync State: Failure
- Last Sync Time:
Corrective Action: Recreate the table without column mapping property.
