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 an 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 schedule any new results for a Look’s query to be delivered as an alert. For example, your Look might have the query “orders over five days old that haven’t been shipped,” and you will receive an email alert only if there is an outstanding order that needs immediate attention.
You also can 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.
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.
Data formats available for scheduling will differ depending on whether you are scheduling delivery of a Look or a dashboard.
While choosing your scheduling options, if you don’t see the Visualization or HTML formats (for Looks) or the PDF or Visualization formats (for dashboards), check with your Looker admin about enabling the Enhanced Rendering Labs feature and installing Chromium or PhantomJS for your Looker instance.
For Admins: Enabling Scheduling for Your Looker Instance
For deliveries of large Excel files, see this documentation page if you encounter any problems.
Certain scheduling options require that Looker admins have enabled the Enhanced Rendering Labs feature and that on-premises Looker admins have installed PhantomJS or Chromium for their Looker instance. Admins can read more about rendering image-based data formats when sending and scheduling Looks or dashboards on this documentation page.
Looker offers several destination options for data deliveries. The scheduling options are different for each delivery destination, so please click the link for the specific delivery destination you want: