Forum Discussion

jjaeger94's avatar
jjaeger94
Helper II
2 years ago
Solved

Name-based column mappings

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, i...
one lake
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

  • frithjof_v's avatar
    frithjof_v
    Community Champion
    2 years ago

    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's avatar
      jjaeger94
      Helper II
      2 years ago

      Thank you. These are exactly the features I need.