I am trying to create a whole new section of Looker for a specific team. It will use access grant for security and also pull data that the team absolutely needs.
At first I wanted to use extend
but realise that I wanted to create a new model instead.
I included few views, one of them is a very big view called orders.view.lkml
this contains order level data.
With the new model I don’t really need that and moreover I have another table that can only join on date
.
What is the best/preferred way of solving this problem? Do I need to create a new view that is a derived table of my orders view?