Refresh of a custom semantic model based on a LH should add or delete columns if they've changed in the LH. This is important to have as an API. Could be an option in the UI.

[Anonymous]

Can we just get an API that does whatever is going on under the hood when the user goes through the UI and does the Edit Model > Refresh action?

I have a lakehouse.

I build a custom semantic model from it.

Now I add or delete columns in tables of the LH.

As Patrick points out in this GIAC video, there is no way to get the model to auto-update columns (add or delete them). You have to go into the UI (Edit Model > Refresh).

https://youtu.be/2RuoHpNZbc4?si=zSbhKHc0G0iIzQVJ

That is a non-workable solution for any large deployment.

There is an API that can modify the model schema, but it requires explicit naming of columns to be added or deleted.

That requires coding scripts that read the LH model, compare it to the semantic model, then dynamically build script to add/delete columns.

So ... can we just get an API that does whatever is going on when the user does Edit Model > Refresh in the UI? We clearly have the function to do it. Just need to be able to call it.