Hi. I want users to click into data on my dashboards.
But, I find that they often give up because the load times so long. Can I set it so that it runs every drill-down query when it refreshes the dashboard?
Instead of caching every drill down, a PDT might be the alternative solution to get the speed you are looking for
The dashboard pulls from data stored in a PDT.
Hey @sebastian there's no simple way to have cache "warmed" with every potential drill-down. If you could email email@example.com with a few more details as to how this would work in your instance I'd be happy to pass this information along to our product team.
I suspect you could use the looker API to do this. If you set up a cron-job that hits all of the relevant looks with the drill downs every morning and set the caching rules appropriately I think you could make this happen.