@Loki you need to consider 2 things 1. environment wise segregation (dev,qa, prd) --> this will be good strategy for CICD and testing wise as in dev you can play with your data and customize according to needs before going to prod

2. coming data security (teams1, team2, teams 3) --> go with unity catalog ( best solution for governance)