Name-based column mappings

[jjaeger94]

I was hoping to leverage .option("delta.columnMapping.mode", "name") to remove underscores from my column names and make more user friendly fields. However, when I write the table to the Lakehouse, it doesn't appear in the SQL Analytics endpoint, and doesn't appear in the semantic model.

It looks like the issue is related to this.

Delta Lake table format interoperability 

Is there any hope that Microsoft will expand the Delta Lake table format interoperability (considering that is what a lot of this is built on?)

It would be nice if Fabric worked as a universally compatible suite of tools.

[frithjof_v]

@jjaeger94  Please vote and write in the comments https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a93f4fa7-8d03-ee11-a81c-000d3ae52c8f

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=a973fa77-03b6-ee11-92bd-00224850a62f

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=cf1f0082-9250-ef11-b4ac-6045bd8620f1

[frithjof_v]

@jimhav and others, please vote for these ideas (in previous comment) to highlight this need. 

(It seems the third link is not working anymore, but the two first ones should be working)

[jjaeger94]

Thank you. These are exactly the features I need. 

[v-huijiey-msft · Accepted solution]

Hi @jjaeger94 ,

It sounds really unfortunate that the table won't show up in the SQL Analytics endpoint and semantic model when it's written to Lakehouse after you remove the underscores from the column names using .option(“delta.columnMapping.mode”, “name”).

This is a known limitation mentioned in the official documentation and it is uncertain when Delta Lake interoperability will be extended, you can keep an eye on Microsoft updates for any developments in this area.

You also have the option to make suggestions on Home (microsoft.com).

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[jimhav]

this is not really a solution.  this should not be an issue.  when is microsoft planning to fix this?