I am trying to add additional columns / attributes to existing Date entity in an existing Data Warehouse project that has been in use for a while. I am able to add the attributes, such as FIRST_DAY_OF_MONTH, LAST_DAY_OF_MONTH etc., but how do I process further to regenerate / repopulate just the Date entity and not touch other entities that are not modified. I am looking for an option to modify the Date entity without regenerating scripts for all the entities.
Also, instead of modifying the Date entity, what would be happen if the underlying table is altered using SQL? Would that affect existing project's daily refresh workflows?
