This may be a really silly question, but I am wondering what is considered best practice?
My scenario is: I have several PDTs, which at a View Level contain the “sql_trigger_value: SELECT CURDATE();;” statement. These are joined at the Explore level. I am seeking to improve query performance and was reading through Looker’s discourse.
Do I need to a) state a “sql_trigger_value:” at the Explore level? Or b) do nothing as they are already PDTs?
As well as seeking performance improvements, I am wondering what would be considered as best practice?