Looker lets you schedule periodic delivery of a user-defined dashboard, a Look’s visualization, or a Look’s data. You can send the information to email addresses, an Amazon S3 bucket, an SFTP server, a webhook, or to the Segment integrated service.
Types of Schedules
There are several ways to time the delivery of your data. You can send data periodically, such as sending a certain dashboard every Monday. And, for Looks, you can create a schedule so that information is sent only if the data has changed since the last delivery, or if there are results for the query. Setting up delivery in this way is particularly interesting, because you can set up a Look’s query as an alert, and then set up a schedule for that Look where data is sent only if that Look has new results. So, for example, your Look might have the query “orders over five days old that haven’t been shipped,” and you will receive an email only if there is an outstanding order that needs immediate attention.
You can also use a datagroup as a trigger, so that data is sent only after it has been updated.
You can also immediately send data directly from an Explore, Look, or dashboard with the same destination and formatting options that are available when scheduling data deliveries. This lets you send data right away, without setting up a schedule. In the case of an Explore, you can send a query immediately using all the destination and formatting options, without having to save the query to a dashboard or a Look. See the Sharing Data page for more information.
Each saved Look or dashboard can have multiple schedules, and each user of that data has their own set of schedules. If a user edits or deletes one of their schedules, only their recipients will be impacted; other users might have other schedules related to that data.
In the Admin section of Looker, administrators can use the Scheduler Plans and Scheduler History pages to look up and resolve any schedule issues. Admins should be careful about deleting or disabling a user who may be the owner of important scheduled deliveries because the schedules are also deleted or disabled.
Enabling Scheduling for Your Looker Instance
Certain scheduling options require that your Looker admin enables the “Dashboards PDFs and Scheduled Visualizations” in Looker Labs:
Enabling this lab is required for the following scheduling options:
- For dashboards, all scheduling options require the lab feature.
- For Looks, schedules using the inline visualizations (charts) format require the labs feature.
In addition, to schedule visualizations for Looks and dashboards, your Looker instance must have PhantomJS installed. If your instance is hosted by Looker, this will already be installed. Otherwise, installation instructions are here. Make sure you install PhantomJS into an executable path on the same machine as the Looker is hosted.
Looker lets you choose several destination options for scheduling data delivery. The scheduling options are different for each type of delivery destination, so please click the link for the specific delivery destination you want: