Forum Discussion
Name-based column mappings
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 TeamIf 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!
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!
this is not really a solution. this should not be an issue. when is microsoft planning to fix this?