I have the below requirement and I have thought a lot about it from multiple angles and couldn’t come up with a decent solution. Hence I am asking the question here.
Our Datawarehouse is in BigQuery and we use looker to to expose the data marts via explores and models to business power users who create dashboards based on it.
Only the developer team has the developer access to create views and alter models in the project.
Now we have a requirement where power users are asking for more access, so that they can import smaller reference tables ( Tables based on google sheets etc ) in a view and expose that in model.
So below is my dilemma,
- How can I let the business users create views in looker without having the privileges to mess up the rest of the setup ?
- Is providing them with developer access the only option ?
- I dont want to create a new project and new connection since that would still not solve the issue they face where they want to import and join the reference data with in that project.
Thanks a lot for all your help.