home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Delivering Looks and Explores

This page provides an overview of delivering Looks and Explores to Looker’s native delivery destinations and to any integrated services that are available for your Looker instance. For information about delivering legacy dashboards, see the Delivering legacy dashboards documentation page. For information about scheduling dashboards that use the new dashboard experience, visit the Scheduling and sending dashboards documentation page.

The Looker Scheduler is the name of the pop-up window in which you configure the settings for your content delivery. For Looks, you can use the Scheduler to send one-time or recurring deliveries. Explores can be sent as one-time deliveries only. To schedule Explore content for recurring delivery, you must first save it as a Look.

If you are a Looker developer, you must turn off Development Mode to enable these scheduling options.

The delivery options available to you are dependent on the delivery-related permissions granted to you by your Looker admin.

Opening the Scheduler from a folder

For Explores, you can open the Scheduler from within the Explore only, not from a folder.

To open the Scheduler from within a folder or subfolder, find the folder or subfolder containing the dashboard you want to deliver. When you navigate to a folder, any Looks and dashboards within the folder are listed in list view or grid view.

If your admin has enabled the Enhanced Navigation Labs feature, you can access folders by expanding the list of folders in the Folders section of the new enhanced left navigation panel.

A calendar icon indicates that you have scheduled at least one recurring delivery for that content (in grid view, you must hover over the content thumbnail to see the calendar icon, if present):

In list view you can open the Scheduler by:

In grid view, you can open the Scheduler by:

Creating a delivery

Because Explores can be sent as one-time deliveries only, there is not a Schedule option in an Explore’s gear menu.

Naming the delivery

Give the schedule a unique title in the Give your schedule a name field. The title will appear in the left panel after you save the schedule, in the list of schedules you've created, and on the schedule management pages in the Admin panel.

Depending on the destination of your delivery, the title may also appear in other places:

Choosing the delivery destination

Depending on how your Looker admin has configured your permissions, all destinations may not be visible.

The Where should this data go? setting may display several destination options for data deliveries. Each destination offers different delivery options.

Destinations include:

Once you’ve selected a data destination, a new setting field appears for you to add specific details about that destination, such as an email address or a webhook URL.

Delivery options for email

Choose Email in the Where should this data go? section. Your content will be delivered to a list of email addresses that you specify.

In the Who should it be emailed to section, enter the email addresses of the recipients. Enter a single email address, or multiple addresses separated by commas, and click Add.

Depending on the settings for your Looker instance and on your assigned permissions, you may be able to send emails to email addresses that are unassociated with any user account on your Looker instance. These are classified as external emails. To deliver content to external users, your Looker admin must have granted you permissions to deliver content to external users or have added those recipients' email domains to the Email Domain Allowist for Scheduled Content.

If a recipient is another Looker user, that person will see the option to link back to the dashboard from the email, unless your Looker admin has set your Looker instance's emailed data policy to Send Data Only or the Include links option is deselected.

If all recipients unsubscribe from a scheduled email delivery, that schedule is deleted from Looker, even from the schedule management pages for users and admins. If a recipient unsubscribes on behalf of an email group, no members of the group will receive scheduled email deliveries.

See the Applying advanced delivery options section on this page for more information about email deliveries.

Check Include a custom message to add a customized message in the body of the email.

Emailed deliveries may not exceed 20 MB (for formats that are delivered in the email body) and 15 MB (for formats that are delivered as an attachment).

Delivery options for webhooks

Webhooks are an increasingly common way to trigger exchanges between internet-based services. With a web service like Zapier, webhooks can let Looker data be delivered to a wide range of applications; for example, you may be able to schedule periodic delivery of a Look or dashboard to a webhook. When you set up a delivery, Looker will prompt you for the webhook address.

In the Where should this data go? section, choose Webhook. In the Webhook URL section, enter the URL where Looker should send an HTTPS request for this delivery. You can obtain this URL from the web service you're using to handle your webhook. To set up a webhook, go to your web service and do the following:

  1. Obtain a URL where Looker should send an HTTPS request.
  2. Specify a destination application for your Looker data delivery. The destination application may require additional configuration in order to receive data from Looker.

The exact procedure differs depending on what web service and destination application you're using to deliver the dashboard. See this Looker Community topic on Scheduling Looks and dashboards using webhooks (3.46+) for guidelines on setting up another application to receive the webhook data from Looker.

Looker will attempt delivery to a webhook for a maximum of 30 minutes. Ensure that the destination can respond within 30 minutes to the webhook delivery attempt.

Delivery options for Amazon S3 buckets

Amazon S3 buckets are a common way to store large amounts of data. You or your company will need to have created an S3 bucket with Amazon before Looker can use it.

If you choose the Amazon S3 destination option, Looker prompts you for additional settings about formatting and about the Amazon S3 bucket as described on this page. See this Looker Community topic on Scheduling (unlimited) results to S3 for more details about delivering data using an Amazon S3 bucket.

In the Where should this data go? section, choose Amazon S3. The S3 Details section appears and prompts you for information about your Amazon S3 bucket:

Check out this Looker Community topic for more details about delivering data using an Amazon S3 bucket.

Delivery options for SFTP servers

Choose SFTP in the Where should this data go? section to deliver your dashboard to an SFTP server. Sending results to an SFTP server is a good method to use when your data or visualization is too large to send via email. If you choose this delivery option, Looker prompts you for the SFTP server address, username, and password as described below.

To receive SFTP deliveries from Looker, be sure your network admin has added Looker's IP addresses to your SFTP server's IP allowlist or inbound traffic rules.

When you choose to SFTP, Looker prompts you for the URL and login information for the server:

Currently, SFTP support is limited to username and password credentials. SSH private key credentials are not supported.

Looker stores SFTP fingerprints for your SFTP server. If you encounter errors with your SFTP delivery, it could indicate that the SFTP fingerprints are invalid. In this case, contact your Looker admin.

If you receive the error Java::JavaLang::NullPointerExceptions when delivering data to an SFTP server, see the Help Center article on how to deal with this Java error.

Delivery options for third-party integrations

The Scheduler will display any actions that have been enabled by your Looker admin. Depending on the service, there may be additional destination-specific fields. These fields provide the integrated service with additional information required to perform the selected action with your data. See more about delivering data from integrations in the Delivering dashboard or query data section of the Sharing data through an action hub documentation page.

To see a description of the information each service requires, find your service destination in one of the lists below, and browse to the URL shown in the How to Use This Destination column.

The following list shows all integrated services where you can deliver a Look or the results of an Explore:

Choosing the data format

For deliveries to email, the option to select a data format is not available if your Looker admin has set your Looker instance's emailed data policy to Send Link Only.

Looks and Explores present different formatting options depending on the delivery destination. To choose the format for your delivery, select the appropriate icon in the Format data as section of the Scheduler.

See the table below for an explanation of how each format is delivered to each destination.

Format Email Webhook Amazon S3 SFTP
Data Table The data table in the body of the email in HTML format Not available for this destination Not available for this destination Not available for this destination
Visualization The visualization in the body of the email as a PNG image Not available for this destination Not available for this destination Not available for this destination
CSV The data table as a comma-separated text-file attachment The data table as a comma-separated text-file attachment The data table as a comma-separated text-file attachment The data table as a comma-separated text-file attachment
XLSX The data table as an Excel file attachment The data table as an Excel file attachment The data table as an Excel file attachment The data table as an Excel file attachment
JSON — Simple The data table as a JSON file attachment. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label. The data table as a JSON file attachment. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label. The data table as a JSON file attachment. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label. The data table as a JSON file attachment. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label.
JSON — Label Not available for this destination The data table in JSON format. In this format, Looker uses field labels as its rendered value in its JSON output. Not available for this destination Not available for this destination
JSON — Simple, Inline Not available for this destination The data table submitted directly in JSON format. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label. Not available for this destination Not available for this destination
JSON — Detailed, Inline Not available for this destination The data table submitted directly in JSON format, with additional details such as field metadata, cache information, the time when the query was completed, and how long it took the query to run. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label. The data table submitted directly in JSON format, with additional details such as field metadata, cache information, the time when the query was completed, and how long it took the query to run. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label. The data table submitted directly in JSON format, with additional details such as field metadata, cache information, the time when the query was completed, and how long it took the query to run. In this format, Looker uses a dimension or measure’s field name as its rendered value rather than the field’s label.
Text The data table as a tab-delimited text-file attachment The data table as a tab-delimited text-file attachment The data table as a tab-delimited text-file attachment The data table as a tab-delimited text-file attachment
HTML The data table as an HTML file attachment The data table as an HTML file attachment The data table as an HTML file attachment The data table as an HTML file attachment

Triggering delivery

You will not see this option if sending an Explore or a one-time delivery of a Look.

When scheduling recurring deliveries, you have two options to trigger deliveries:

Specifying the datagroup trigger

You will not see this option if sending an Explore, a one-time delivery of a Look, or if you have specified a repeating interval trigger for your recurring delivery.

To use a datagroup trigger, select Datagroup update in the Trigger section of the Scheduler. Then choose the source datagroup from the Select Datagroup pull-down:

To schedule content using a datagroup trigger, the model file on which the content is based needs to include a datagroup. Looker lists all datagroups defined in the models included in the given Look or dashboard tile, even if the datagroups are not used to handle caching for queries or PDTs.

Schedules based on datagroups are only triggered to deliver once the regeneration process has completed for all PDTs that are persisted with that datagroup, ensuring that your delivery includes the most up-to-date data.

Specifying the delivery recurrence

You will not see this option if sending an Explore, a one-time delivery of a Look, or if you have specified a datagroup update trigger for your recurring delivery.

For deliveries that use a repeating interval, you can customize the timing of your schedule in the Deliver this schedule section. Select Repeating interval in the Trigger section of the Scheduler. The timing options change depending on whether you choose Daily, Weekly, Monthly, Hourly, or By minute. You can adjust the time zone for the schedule in Advanced options section.

The end time for Hourly and By minute intervals is not inclusive. The last delivery will be sent at the last selected interval prior to the specified end time. For example, if content is scheduled Hourly between 12:00 a.m. and 11:00 p.m., it will be sent on the hour, every hour, from 12:00 a.m. to 10:00 p.m. If content is scheduled By minute every 30 minutes between 12:00 a.m. and 11:00 p.m., the last delivery in that timeframe will be sent at 10:30 p.m.

Applying filters to the delivery

You will not see this option if sending an Explore.

If you are delivering a Look or dashboard that has filters, you can modify the filter conditions to further filter the results delivered.

Click Filters to see and modify the filters associated with this Look or dashboard for your delivery. Changing these filter options in the Scheduler does not change the filters in your Look or dashboard. If a dashboard filter requires a filter value and the schedule filter is blank, a schedule will display no results upon delivery.

If you change field names that serve as filters in your Looks or dashboards, be sure to review the Filters section of your scheduled Looks and dashboards and update the filters as needed to reflect your changes. If a scheduled content delivery includes filters that no longer function (for example, if the referenced field has changed), the scheduled delivery could expose unfiltered data.

To further customize deliveries, you can use the matches a user attribute filter option (if your Looker admins have configured user-specific values called user attributes). Setting a filter to one of these attributes automatically customizes the results for each user, meaning that you can send customized results to many users even if you send a one-time delivery. You can read more about this on the User attributes documentation page.

Applying advanced delivery options

The Advanced options section provides additional customization for your delivery. Click the arrow next to Advanced options to expand this menu. The options available depend on the selected destination and format of your delivery, and whether you’re delivering a dashboard, a Look, or an Explore. The links in the table below direct to a description of each option that is available for deliveries of Looks or Explores to Looker’s native destinations. Deliveries to third-party integrations may have unique advanced options available.

Format Email Webhook Amazon S3 SFTP
Data Table
Send this schedule if Not available for this destination Not available for this destination Not available for this destination
Limit
Email options Run schedule as recipient
Include links
Format options Apply visualization options
Formatted data values
Timezone
Visualization
Limit Not available for this destination Not available for this destination Not available for this destination
Email options Run schedule as recipient
Include links
Table resolution
Timezone
CSV
Send this schedule if Send this schedule if Send this schedule if Send this schedule if
Limit Limit Limit Limit
Email options Run schedule as recipient Not available for this destination Not available for this destination Not available for this destination
Include links
Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options
Formatted data values Formatted data values Formatted data values Formatted data values
Timezone Timezone Timezone Timezone
XLSX
Send this schedule if Send this schedule if Send this schedule if Send this schedule if
Limit Limit Limit Limit
Email options Run schedule as recipient Not available for this destination Not available for this destination Not available for this destination
Include links
Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options
Formatted data values Formatted data values Formatted data values Formatted data values
Timezone Timezone Timezone Timezone
JSON — Simple; JSON – Label; JSON — Simple, Inline
Send this schedule if Send this schedule if Send this schedule if Send this schedule if
Limit Limit Limit Limit
Email options Run schedule as recipient Not available for this destination Not available for this destination Not available for this destination
Include links
Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options
Formatted data values Formatted data values Formatted data values Formatted data values
Timezone Timezone Timezone Timezone
JSON — Detailed, Inline Not available for this destination Limit Limit Limit
Not available for this destination Timezone Timezone Timezone
Text
Send this schedule if Send this schedule if Send this schedule if Send this schedule if
Limit Limit Limit Limit
Email options Run schedule as recipient Not available for this destination Not available for this destination Not available for this destination
Include links
Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options
Formatted data values Formatted data values Formatted data values Formatted data values
Timezone Timezone Timezone Timezone
HTML
Send this schedule if Send this schedule if Send this schedule if Send this schedule if
Limit Limit Limit Limit
Email options Run schedule as recipient Not available for this destination Not available for this destination Not available for this destination
Include links
Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options Format options Apply visualization options
Formatted data values Formatted data values Formatted data values Formatted data values
Timezone Timezone Timezone Timezone

Send this schedule if

For recurring deliveries of Looks, you can customize the schedule to deliver the Look content only when certain conditions are met. Alerts provide a similar function for dashboard tiles.

In the Send this schedule if drop-down, specify whether you want to deliver the Look content only if there are results, only if there are no results, or if there are either results or no results. For example, you can user filters to create conditions for situations you want to monitor, such as items that are below a certain quantity of inventory, expenditures that are above a certain value, and so forth, and then deliver the content only if that condition has been reached.

You can also specify there to be a delivery only if the query results have changed since the last data delivery was sent by checking the box next to and results changed since last run. This option is not available if you want to use the All Results limit option.

Limit

You can limit the size of your delivery by selecting one of the following limit options for your data:

If you choose Results in Table, Looker will obey whatever row limitations you've set up in the saved Look or the Explore. If you choose All Results, Looker will return all the rows of the query, regardless of any saved Look settings, and regardless of Looker's typical 5,000 row limit. This can be desirable for retrieving very large datasets, but you should use caution to ensure the query is not too large for your database.

Limit options for email

When sending Looks and Explores, you can limit the size of your email to stay within your email server's message size limitations. Select one of the following limit options for your data:

To verify that you are within the row or data limit for scheduled emails, you can enter your own email address as the recipient and click Send Test to send the data to yourself immediately. If you do not receive the email, it is likely that you have reached the row limit or the data limit for emails.

Email options

Deliveries to email have additional delivery options as described below.

Run schedule as recipient

This option is available only for the email destination.

The Run schedule as recipient option allows admins to specify a list of users who will each receive the content delivery as if they ran the query, based on their permissions. Non-admin users may also enter their own email address to receive a delivery as if they had queried the content, based on their permissions. This means that each user's access filters and user attributes will be applied to the data included in each email.

For example, say that a Looker admin needs to schedule the following report to a series of users, and each user has different access filter values:

User A has an access filter set as users.state = 'California'. When Run schedule as recipient is selected, the scheduled query will apply the access filter users.state = 'California' and send the following filtered results to user A:

This option takes into account the permissions of the user creating the schedule as well as the types of email addresses added to the Who should it be emailed to? text field.

In some cases, the Run schedule as recipient option is not available:

  1. When a non-admin adds an email address other than their own
  2. When a Looker admin adds the email of a disabled user
  3. When a Looker admin adds an email that does not belong to a Looker user (a Looker account is indicated by a Looker icon next to the recipient):

In these situations, the order in which the option was selected and the email address was added is important:

In the special case where a user is listed as a recipient on a schedule that has Run schedule as recipient enabled and then that user's account is disabled, the schedule will fail to deliver to the disabled user starting the next time it runs. If that user's account is deleted, the entire schedule will fail to deliver to any recipients. A Looker admin or user with the see_schedules permission will be able to diagnose this failure in the Scheduler History page in the Admin panel.

Include links

If your Looker admin has set your Looker instance's emailed data policy to Send Links and Data, the Scheduler will display an option to Include links. When this option is checked, email data deliveries include a link back to Looker that says "View full report" for delivered Looks and Explores and "View full dashboard" for delivered dashboards.

This link lets the email recipients further explore the data on your Looker instance. Recipients must log in to Looker and have permissions to access the model on which the delivered content is based to view that content in Looker. If you want to remove this link from your data delivery emails, uncheck the Include Links checkbox.

Format options

Deliveries not using the Visualization format have additional delivery options as described below.

Apply visualization options

This option is not available for Look or Explore deliveries in Visualization format.

You can configure whether you want the data delivery to use the same options as your visualization:

Formatted data values

This option is not available for Look or Explore deliveries in Visualization format.

You can configure the data's formatting:

Table resolution

When delivering content to email in Visualization format, you can customize the width of your visualization by using the Table resolution drop-down menu. Your width options are:

If you choose Wide and the visualization width exceeds the limit set by your email client, email delivery recipients may need to scroll horizontally to see the entire visualization.

Timezone

By default, Looker uses the time zone associated with your account to determine when to send your data delivery. If you don't have a time zone associated with your account, Looker uses your Application time zone. If you want to specify a different time zone, select Use custom timezone. The time zone you select does not affect the data in your Look or dashboard, just the timing of the delivery.

Testing the delivery

Click the Send Test button to send a one-time test delivery to the specified destination.

Saving the delivery

A summary of your delivery settings is displayed at the bottom of the Scheduler.

For one-time deliveries, when you are finished configuring delivery options, click the Send button to deliver your content immediately to your specified destination.

For recurring deliveries, when you are finished configuring delivery options, click the Save All button to save your schedule and close the window. The content will be delivered according to your delivery settings. If you reopen the Scheduler, your saved schedule appears in the left panel. You have the option of duplicating or deleting the schedule by clicking the Duplicate or Delete icon, respectively.

Your saved schedule will also appear on the Schedules You've Created page in your user profile and the Schedules and Schedule History pages in the Admin panel. See the Viewing deliveries section on this page for more information.

Viewing deliveries

You can view the schedules that you have created and, given the appropriate permissions, all the schedules for the Looker instance.

Viewing deliveries that you created

You can see a list of all schedules that you have created on the Schedules You've Created page, which you can reach by clicking on your user profile icon and selecting Schedules. See the Viewing Your Scheduled Data Deliveries page for more information about viewing and managing the schedules that you've created.

Viewing deliveries created by other users

If your Looker admin has granted you permissions to view the Schedules and Schedule History admin pages, you can see the list of all schedules for the entire Looker instance. You will not be able to edit or delete those schedules, however.

Things to know

At times a scheduled email delivery could fail to reach one or more of its recipients. This could happen if the underlying model has an error, if the recipient does not have access to the data, or if there are rendering problems or page errors.

A few other challenges can arise:

Top