Under Construction: We are gradually adding more content to this page.
Various documentation pages discuss the business user features for exploring data and for finding, viewing, organizing, sharing, sending, scheduling, and downloading content. Many of those features must be enabled by a Looker admin or have Looker admin–specific or developer–specific functionality. This page organizes those business user–facing features onto one page for easy admin reference.
The Looker Browse menu includes two pages specific to Looker admins:
- Unused Content: Shows all Looks and dashboards that haven’t been viewed within a time range you select.
- Trash: Shows Looks and dashboards that users have deleted and that you can recover.
For details about these pages, see the Deleted and Unused Content for Admins documentation page.
This section includes admin-specific or developer-specific functionality and tips for creating dashboards, Looks, and Explores.
Using Custom Fields
Custom fields are a Labs feature so may change or be removed from the product.
Also, the custom fields feature is not a data security feature. Other users can still see the custom fields in shared queries, Looks, and dashboard tiles. They also can use Explore from here to create new queries with those fields.
Enable custom fields if you want to let some of your business users:
- Visualize unmodelled data using Instant Explore from the SQL Runner.
- Create semi-permanent measures and dimensions for a one-off or infrequent analysis.
- Create semi-permanent measures and dimensions without the need of an analyst.
Enabling Custom Fields
To enable using custom fields, a Looker admin needs to:
- Create a group called Custom Fields Beta Users
- Enable the Custom Fields Labs feature
- Add users to the Custom Fields Beta Users group
Creating a Group Called Custom Fields Beta Users
To create the Custom Fields Beta Users group:
- In the Looker Admin panel, click Groups to navigate to the Admin Panel's Groups page.
- Click Add Group.
- Create a group called Custom Fields Beta Users.
- Click Create.
Enabling the Custom Fields Labs Feature
To enable the Custom Fields Labs feature:
- In the Looker Admin panel, click Labs to navigate to the Admin Panel's Labs page.
- In the Experimental section, click the Custom Fields switch to turn the feature ON.
Add Users to the Custom Fields Beta Users Group
To add users or groups to the Custom Fields Beta Users group:
- Navigate to the Admin Panel's Groups page.
- Next to the Custom Fields Beta Users group, click Edit.
- Enter the name of a user or group that you want to add to the Custom Fields Beta Users group. Any users or groups you add should be assigned a role that has the
create_table_calculationspermission. Even Looker admins do not have access to custom fields unless added to this group.
- Click Add.
Users added to the Custom Fields Beta Users group will no longer see the Calculations button to create table calculations. In the Field Picker, they should expand Custom Fields. From there they can use and edit existing table calculations. They also can click New and select Table Calculation to create a new table calculation.
Custom Fields and the LookML Model
Although custom fields rely on the LookML model, they are not part of the modeling layer and do not appear in any view files. You cannot save or convert a custom field to a LookML field.
Consider using custom fields instead of LookML for fields that are only needed temporarily or only by your most sophisticated users.
You Can Create a Custom Field in SQL Runner
You can use custom fields to visualized unmodelled fields in SQL Runner, as described on the Using SQL Runner page.
Changing the Field Picker Choices Using LookML
To learn the various ways that a Looker developer can use LookML to create and modify the fields available in the Field Picker, see the Changing the Explore Menu and Field Picker page.
Sending and Sharing Content
This section includes admin-specific or developer-specific functionality and tips for sending and sharing data.
Sending and Scheduling Content
This section includes admin-specific or developer-specific functionality and tips for sending and scheduling data. In addition, check the Sending, Scheduling, or Downloading section below.
Sending Content as Recipient
You see this option only if a Looker admin has enabled the Run schedule as recipient Lab feature.
If the Run schedule as recipient Looker Labs feature is enabled and you are a Looker admin, you can check Run schedule as recipient to send data to multiple Looker users, each receiving the data they would see if they ran the query. This means that each user’s access filters and user attributes will be applied to the data included in each email.
For example, user A has an access filter set as
users.state = 'California', and the admin schedules the following report to user A:
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:
The Run schedule as recipient option is unavailable if an admin sender adds an email without a Looker account or if a non-admin sender schedules data to anyone other than themselves. A Looker icon next to the recipient in the Schedule dialog box indicates that the recipient is a Looker account:
Managing Sending and Scheduling
In the Admin section of Looker, admins can use the Scheduler Plans and Scheduler History pages to look up and resolve schedule issues. Admins should be careful about deleting or disabling a user who may be the owner of important scheduled deliveries, because the schedules are also deleted or disabled.
Rendering Emailed Images
The Easy to Read Email Images Labs feature lets the email client determine the optimal image size for images sent or scheduled in the body of emails. This Labs feature is on by default. If images appear distorted when delivered by email, your users’ email client may be incompatible with this feature. You may want to consider disabling the Labs feature.
Sending and Scheduling Data to Streamed Destinations with Action Hub
Looker hosts and provides a stateless server, Action Hub, that implements Looker’s Action API and exposes popular actions.
With the Looker Action Hub you can send and schedule data from within Looker to other SaaS tools automatically. Sending or scheduling data to destinations that support streaming relies on synchronous queries running between Action Hub and Looker’s executable server, or
.jar, file. For hosted Looker instances, these sources are configured to communicate.
If you host your Looker instance on premises, click here
Users of on-premises instances may experience hanging queries when sending or scheduling data to streamed destinations if the on-premises
.jar file from Looker is not able to communicate with Looker’s Action Hub.
One solution to address this potential issue is to host an on-premises Action Hub. Looker’s Action Hub service is open source so that you can contribute additional actions or host an instance of the service within your own infrastructure. Learn more about deploying Action Hub on premises on this page.
Another solution is to ensure that the executable server file is hosted in a public server so that Looker’s Action Hub can communicate with it.
This section includes admin-specific or developer-specific functionality and tips for downloading data. In addition, check the Sending, Scheduling, or Downloading section below.
Rendering Image-Based Data Formats for Downloads
When downloading data, you will need to enable the Enhanced Rendering Labs feature to better render these data formats:
- For dashboards: PDF (Tiled), PDF (Single Column)
- For Looks: HTML, PNG (Image of Visualization)
Downloading Data from Dashboard Tiles without Download Permission
Typically, a user requires a role that includes the
see_user_dashboards and either the
download_without_limits permissions to view and download data from tiles on a dashboard. There is a condition, however, where a user can see and download data from a model to which they do not have those permissions. It occurs when the following is true:
- A dashboard has tiles that are based on queries from more than one model.
- A user is assigned one role that includes the
view_dashboardand either the
download_without_limitspermissions to one of the models on which the dashboard is based.
- The user has a second role that has only the
access_datapermission to another model on which the dashboard is based.
In this case, that user can view and download data from the entire dashboard, including tiles based on models to which the user does not have permissions to view or download data.
Sending, Scheduling or Downloading
The following sections apply to both downloads and deliveries of data.
Rendering Image-Based Data Formats for Sending, Scheduling, or Downloading
When scheduling, sending, or downloading Looks and dashboards, Looker uses additional software to render certain data formats. This software is already installed for hosted Looker instances.
If you host your Looker instance on premises, click here
On-premises admins will need to install additional software to render these formats.
- For dashboards: PDF (Tiled), PDF (Single Column), Visualization (Tiled), Visualization (Single Column)
- For Looks: Visualization, HTML
Large Excel Files Hanging or Not Opening
For downloads or deliveries of large Excel files (files over 5 GB), the download or delivery screen may appear to freeze, or you may be unable to open the delivered file. Here are some conditions that can cause this behavior, and how you might fix it:
- Large Excel file data deliveries can time out while streaming. In this case, try sending or downloading your data in the CSV format, which you can then import into Excel.
- Large Excel files sometimes are delivered successfully, but are too large to open locally. In this case, break your data delivery into smaller CSV files so that they will load successfully by the destination client.
- You may need an increase in temporary storage space on your Looker instance. Please contact your Account Manager or firstname.lastname@example.org.
Preventing Injection of Malicious Code into CSV Files
CSV files can contain macros that can run on Microsoft Excel or Google Sheets. Macros can be used to inject malicious code into CSV files, making CSV files a possible security risk.
To remove this risk, Looker admins can request a license update that causes Looker to pad any value in a cell that could be executable code. When this is enabled, Looker will add a
' character to any cell value that begins with a special character (
@) when generating a CSV file. This disables all macros in Looker-generated CSV files.
Please contact your Account Manager or email@example.com if you want to update your license for this feature.
Public Sharing, Importing, and Embedding
To enable public access to Look URLs, including the ability to embed a Look, you must enable Public URLs in the General Settings page:
Please consider the security implications of this feature before enabling it. Although the URLs that Looker generates can’t be guessed or searched, anyone with the URL will be able to see the data. This means that anyone who receives the URL could share it with another person who was not intended to have access to your data. You should determine the privacy requirements of the data in question, evaluate your level of trust in anyone who receives a public URL, and clearly establish your expectations about whether — and, if so, how and with whom — it is to be shared.
Retrieving and Charting Data
This section includes admin-specific or developer-specific functionality and tips for retrieving and charting data.
This section gives a quick list of features that have additional on-premises considerations, with links to the relevant sections on this page.