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
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?