Is prefetching allowed in Looker?

Looker Tips & Resources Technical Tips & Tricks
1

Knowledge Drop

Last tested: June 2021

Prefetching is strongly discouraged. Use scheduling and datagroups instead.

To pre-load dashboards when an ETL job finishes:

  1. Create a datagroup that triggers when the ETL job finishes. (Perhaps using a trigger that checks for new rows such as “SELECT MAX(id) FROM table”)
  2. Schedule the dashboard to yourself or a placeholder email, based on the datagroup trigger.