Semantic Model: Refresh OAC physical table structure

Question

Hi community,

let's suppose that I have made many changes to a DB table (new columns, changes to column dimensions, name changes, etc.) and I don't want to manually apply these changes to the physical OAC table. Is there any way to automatically refresh the physical table structure to reflect the changes that occurred on the db?

Thanks in advance for your support.

Gianni Ceresa · Accepted Answer

Hi,

You mean in the Semantic Modeler? (you mentioned a "physical" table)

Not really …

But you can import it again in a different part of your model, or even a new model, copy the code definition (the JSON), replace it in your current model.

Or, because it's just a piece of JSON defining your table, you can generate the new JSON from your database directly with a query and past it into your model definition replacing the existing one.

Of course if you renamed columns and some used columns changed name, your model will break and you will need to remap things as needed.

Gianni Ceresa · Accepted Answer

Just as reference in case somebody else open this thread and it isn't directly obvious what I meant by "editing the JSON": right click an object in the semantic modeler > Open in SMML Editor.

And from there it's just a simple JSON that can be quickly edited (faster then the GUI sometime).