Add data warehouse function to reinitialize the table[s] for a given entity or group of entities
There have been a number of occasions when after introducing an entity into the data warehouse model, and developing the data load process, where I have needed to change an approach or correct an error, and the ideal thing to do would have been to purge the table[s] (since there can be satellite tables involved, and also load error tables) back to pristine state, as created by Compose with various required null records, etc.
However, neither support nor I have been able to find a way to do this natively; usually I end up dropping the whole data warehouse, and recreating it and reloading it from scratch.
So far, this has not been fatal, but soon we will start to keep row history in the warehouse, and this process would mean losing all of our history.
Please, Compose needs a function to reinitialize the table[s] for a given entity or group of entities.