Amazon S3 buckets are a common way to store large amounts of data. If you have created an S3 bucket with Amazon, Looker will let you send data to it directly.
You can immediately send data from an Explore, Look, or dashboard to your Amazon S3 bucket using the Send option from the gear menu of an Explore, Look, or dashboard. 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 Amazon S3 in the Where should this data go section. You’ll see the following options:
Naming Your Delivery
Give the content a unique title in the Title field. The title is used in the file name of the data delivery, and in any error emails that are sent to you in case of any problems delivering the data to your Amazon S3 bucket.
Delivering to S3
In Where should this data go, choose Amazon S3. The S3 Details section appears and prompts you for information about your Amazon S3 bucket:
- Bucket: The name of your Amazon S3 bucket.
- Optional Path: The folder that you want to save your data to, if any.
- Access Key: The Access Key ID to your S3 bucket, provided by Amazon.
- Secret Key: The Secret Access Key to your S3 bucket, provided by Amazon.
- Region: The Amazon services region where your S3 bucket is hosted.
Check out this Community topic for more details about delivering data using an Amazon S3 bucket.
To learn more about other types of data delivery, see the page for each destination option: email, SFTP server, applications using a webhook, or one of several integrated services.
Formatting the Data
In Format data as, choose the format for the data in your delivery.
For dashboards, you can choose:
- PDF: Your dashboard in PDF format. The default layout displays tiles as they are arranged in the dashboard, but other layout and sizing options are available under Advanced Options.
- Visualization: A visualization of your dashboard in a single image file. The default layout displays tiles as they are arranged in the dashboard, but other layout options are available under Advanced Options.
- CSV ZIP File: The unformatted data from your dashboard, delivered as a collection of comma-separated values (CSV) files in a zipped directory.
For Looks and Explores, you can choose:
- CSV: The data table as a comma-separated text file attachment.
- XLSX: The data table as an Excel file attachment.
- JSON — Simple: The data table as a JSON file attachment.
- JSON — Detailed, Inline: 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.
- Text: The data table as a tab-delimited text file attachment.
- HTML: The data table as an HTML file attachment.
Using Advanced Options
The Advanced options section provides additional customization for your delivery. Click the arrow next to Advanced options to expand this menu.
When sending Looks and Explores, you can limit the size of your delivery. Select one of the following limit options for your data:
- Results in Table: Data is sent as a single delivery.
- All Results: Data is streamed (see more in this Help Center article). This is useful for large datasets, as it bypasses file-size, browser, and memory limitations.
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.
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:
Select Apply visualization options to apply some of the visualization settings to your delivery, causing your delivery to appear similar to a table chart. Any of the following settings in the Plot, Series, and Formatting menus that are configured for the visualization will be applied to the data delivery:
- Show Row Numbers
- Hide Totals
- Hide Row Totals
- Limit Displayed Rows to a maximum of 500 rows shown or hidden.
- Show Full Field Name
- Custom labels for each column (note that JSON files will always use raw field names, not the field label)
- Conditional Formatting for deliveries of table chart visualizations in Excel format
Conditional formatting will display in Excel deliveries of Looks and Explores with table chart visualizations only if the Along a scale rule is applied.
- Unselect Apply visualization options if you do not want these visualization options applied. Looker sends the data as it appears in the Data section of the Look or a dashboard tile's Explore from Here window.
Formatted Data Values
For Looks, Explores, and the CSV format of dashboards, you can configure the data's formatting:
- Select Formatted data values if you want the data to appear more similar to the Explore experience in Looker, although some features (such as linking) aren't supported by all file types.
- Unselect Formatted data values if you do not want to apply any special formatting of your query results, such as rounding long numbers or adding special characters your Looker developers may have put in place. This is often preferred when data is being fed into another tool for processing.
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.
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.
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.