User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
Sending Data to an Integrated Service

In addition to Looker’s native data delivery formats (Amazon S3, email, SFTP, and webhook), you can also send data to a service that is integrated with Looker and has been enabled by your Looker admin.

You can send from an Explore, Look, or dashboard using the Send option. This lets you send data right away, without setting up a schedule. In the case of an Explore, you can send a query immediately, without having to save the query to a dashboard or a Look.

After choosing Send from the gear menu, choose the service you want to use in the Where should this data go section. You’ll see various options, depending on which choices you make:

Delivering to an Integrated Service

In Where should this data go, 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.

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.

Formatting the Data

This section describes all possible formats. The availability of the Format data as field and specific format options depend on the definition of the action.

In Format data as, choose the format for the data in your delivery.

For dashboards, you can choose:

For Looks and Explores, the data formats available depend on the data destination you choose.

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.

Format Options

Apply Visualization Options

For Looks, Explores, and CSV-formatted dashboards, 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 Expands tables option, talk to your Looker admin about installing 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 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.

Top