We do not directly expose the tables to our end users. We have separate Subject Area Schemas where we create Views, which are then accessed by End-Users.
Currently we are managing these scripts outside Compose and they have to be executed everytime we make changes to the DM.
"create view abc as select * from datamarttable; " , will stop working if the datamarttable has been extended. If we can get these scripts to run, everytime there is a schema change maintenance will be a lot easier for us.
The same also applies to Data masking policies. We are currently running these after every load, which is an overkill. Ability to setup it up to run only when DDL changes are taking place, would be ideal.
The same could be extended to the DW DDLs as well.
