We have a few models, where new columns are being added dynamically. We have set up our DBT transformations to handle this, and the last step would be to automatically update the code in Holistics when new columns are added.
There are two ways you could solve this as I see it:
The automatic rebuild option (Preferred option):
You add an option to data tables to automatically rebuild based on a schedule you can set like once a day. This would obviously overwrite any custom definitions in that model. It should, therefore, that is turned off by default.
The CLI method:
With this option you would add a new feature to the CLI, that would make it possible to update the AML code for a model. This would allow us to update programmatically but would require us to handle the logic outside of Holistics.