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...
Even the internal delta tables created using Fabric notebooks in lakehouse does not appear in the sql endpoint
df.write.format("delta").option('delta.columnMapping.mode' , 'name').saveAsTable("TABLE_NAME")
Can you please share an ETA, when can we expect the feature to be available. This pose severe limitations in integration of data from different sources
