User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
Scheduling Deliveries Using Webhooks

Webhooks are a modern, 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.

To set up a webhook, go to your web service to do the following:

The exact procedure differs depending on what web service and destination application you’re using to deliver the data. See this Community topic for guidelines on setting up another application to receive the webhook data from Looker.

Once these elements are in place, you can schedule periodic delivery of a Look or dashboard to a webhook. With the webhook delivery option, Looker prompts you for the webhook address, as described below.

Depending on how your Looker admin has configured your permissions, the default delivery destination may be email, and this setting may not be visible.

Creating and Editing Schedules

After starting a schedule, Looker displays a dialog box with your scheduling choices. Here is an example Schedule dialog box for a dashboard:

The following sections explain each scheduling setting for a webhook destination. For a description of all scheduling options, see the main scheduling documentation page.

Naming Your Delivery

Give the content a unique title in the Give your schedule a name field. The title is included in the webhook payload under the Title field.

Delivering to Webhook

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

Formatting the Data

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

For dashboards, you can choose:

Using Advanced Options for Webhooks

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

Scheduling Conditions

For all Look formats other than JSON—Detailed, Inline, you can add conditions for when the data will be delivered:

Scheduling Limits

When scheduling Looks, 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. If you choose All Results, Looker will return all the rows of the query, regardless of the 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 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.

Timezone

By default, Looker will use 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 will use 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.

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.

Other Scheduling Options

To learn more about other types of data delivery, see the page for each destination option: email, Amazon S3 bucket, SFTP, or one of several integrated services.

Top