home User Guide Getting Started Help Center Documentation Community Training Certification
Looker keyboard_arrow_down
language keyboard_arrow_down
Sending Data to an Integrated Service

In addition to Looker’s native data delivery destinations (email, Amazon S3 bucket, SFTP, or applications using a webhook), this page discusses how to send one-time data deliveries to services integrated with Looker that have been enabled by your Looker admin from the Looker Action Hub.

Depending on how your Looker admin has configured your permissions, the default delivery destination may be email, and additional delivery options may not be visible. Looker admins can specifically give permissions for users and embed users to send and schedule data to third-party integrations.

These integrations, also called actions, are usually served through the Looker Action Hub. However, Looker admins should consider setting up a local action hub server if their instance does not fulfill the requirements to use the Looker Action Hub.

Delivering to an Integrated Service

Open the Send or Schedule pop-up from your Explore, Look, or dashboard. (You must save an Explore as a Look before you can schedule it for delivery.) In the Where should this data go? section, choose the service that you want to use. The services are set up by your Looker admins.

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:

The following list shows all integrated services where you can deliver a dashboard:

To learn more about other types of data delivery, see the page for each destination option: email, Amazon S3 bucket, SFTP server, or applications using a webhook.

Naming Your Delivery

Give the content a unique title in the Give your schedule a name field. The title is included in the filename of the data delivery.

Formatting the Data

In the Format data as section of the pop-up, choose the format for the data in your delivery.

Formats for Dashboards

Formats for Looks and Explores

The data formats available depend on your chosen delivery destination.

In JSON — Label format, if available for the destination, Looker uses a dimension or measure’s label in its JSON output. The JSON — Simple, JSON — Simple, Inline, and JSON — Detailed, Inline formats use a dimension or measure’s field name as its rendered value rather than the field’s label.

See the Change in JSON Formatting Looker Community topic for more information about how Looker renders fields in JSON format.

Applying Filters to the Delivery

If you are delivering a Look or dashboard that has filters, you can filter the results delivered to each set of recipients. For example, you might send regional teams results that are filtered for their states of interest:

Click Filters to see and modify the filters associated with this Look or dashboard for your data delivery. Changing these filter options in the Send or Schedule window 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 make custom deliveries even easier, 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 select Send only once. You can read more about user attributes here.

Using Advanced Options

The Advanced options section provides additional customization for your delivery. Click the arrow next to Advanced options to expand this menu.

Sending Limits

When sending Looks and Explores, you can limit the size of your delivery. Select 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.

By default, email data deliveries include a link that reads "View this data in Looker":

This link lets the email recipients further explore the data on your Looker instance. If you want to remove this link from your data delivery emails, set Include Links to No.

Streaming Query Results

Streaming refers to Looker's ability to process data in chunks, rather than all at once. If Looker can stream a result set, then unlimited downloads are possible and you can send All Results. In addition to the format requirements mentioned above, there are two cases where streaming is not possible:

  1. Table Calculations: Table calculations cannot be streamed. Therefore, to download unlimited results for a query, you must remove table calculations from the query.
  2. Database Limitations: Some databases cannot stream if pivots are included in the query. For these databases, you must remove pivots to download unlimited results. Some databases can't stream any results, which means that unlimited downloads are not possible. Below is a list of what databases support streaming, as well as databases that support streaming with pivots applied:

Format Options

Apply Visualization Options

For Looks, CSV-formatted dashboards, and Explores (if sending a one-time delivery), you can configure whether you want the data delivery to use the same options as your visualization:

Formatted Data Values

For Looks, Explores, and the CSV format of dashboards, you can configure the data's formatting:

Single Column Layout

For dashboard deliveries in PDF or Visualization format, you have the option to print your PDF in a single column layout, which displays dashboard tiles in a single vertical column. Check the Use single column layout box to use this option, or leave the box unchecked to show the tiles as they are arranged in the dashboard.

Expand Tables

To display all rows of a data table — rather than just those rows that display in the dashboard tile thumbnail — in a PDF dashboard delivery or download, check the Expand tables box. If you do not see the Expand tables option, talk to your Looker admin about installing the appropriate version of the Chromium renderer for your Looker instance.

Paper Size

You have the option to specify the optimal size and orientation of dashboard PDFs by selecting from the Paper size drop-down menu. Large visualizations or groups of overlapping dashboard tiles may need to be resized to fit cleanly on a PDF page. If you do not see the Paper size option, talk to your Looker admin about installing the latest version of the Chromium renderer for your Looker instance.

Sending Your Content

When you have selected all the options for your delivery, click the Send button to send your content.