Hi I've setup the gold layer for my client by creating views. Currently not using CI/CD for view deployment but it's on roadmap. Now I've another 2-3 people joining the team and they will be making minor updates to the views as a result of change requests. This was perfectly possible in SQL Server. But in databricks other members are unable alter existing views as the views are currently tied with my user name as the view owners. If I change the view owner to a group next time another member alters the view he then becomes the view owner and other member does not even have permission to change owner. Wonder what would be best practice in this case without having to implement CI/CD. Thanks in advance.
