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.
1. Create a table in Databricks with column mapping enabled.
%python spark.conf.set("spark.databricks.delta.properties.defaults.minWriterVersion", 5) spark.conf.set("spark.databricks.delta.properties.defaults.minReaderVersion", 2) spark.conf.set("spark.databricks.delta.properties.defaults.columnMapping.mode", "name")
2. Add shortcut tables from Databricks to Synapse Lakehouse. The data shows correctly.
3. Go to the SQL Endpoint. Tables fail to load. with the error. Corrective Action: Recreate the table without column mapping property.
4. This has a knock-on effect with data failing to feed into the datasets and Power BI.
frithjof_v
on:
Fabric Deployment Pipeline - Trigger Fabric Data F...
miguel
on:
Jestor .mez connector not recognized in Power BI S...
on:
allow the use of Python scripts with the enterpris...
on:
Enable/Disable RLS Roles in PowerBI & avoid deleti...
on:
LAST_DAY() function
on:
Button Slicer width and Height should not changed