LookerML question: I have got this snowflake query which joins one static table (does not refresh) and one table that refreshes every day. I want to pop this query into Looker and create a simple Looker dashboard using it. Two options I think are available to me to do so:
- Create view file and PDT but that would mean I need to add a trigger value and the data including the static table would refresh, right? - Isn’t this very inefficient?
- Create regular DT with the explore being a PDT?