home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Labs

Labs overview

Looker Labs features are new, in-progress features whose details may change over time. Labs features are split into two categories:

You can choose to use these features or leave them disabled. You’ll see a list of these features on the Labs page in the General section of the Admin panel.

Each feature has a short description underneath it explaining the functionality that it adds to or changes in Looker.

Enabling and disabling Labs features

To enable or disable a feature, click the switch next to the feature name.

Use caution when disabling a Labs feature. If users or developers have relied on the feature to create a certain behavior, disabling the feature will break that functionality.

Current Labs features

Looker supports the following beta and experimental Labs features.

Beta features

Beta Labs features are expected to remain in the product, and errors are expected to be resolved at some point. However, their details may change, and errors may not be fixed with the same speed as they would be for normal features.

Database Connection Pooling

Enables the use of preconfigured database connection pools on the Amazon Redshift, PostgreSQL, and Snowflake database dialects.

This option lets Looker use pools of connections through the JDBC driver. Database connection pooling enables faster query performance; a new query does not need to create a new database connection but can instead use an existing connection from the connection pool. The connection pooling capability ensures that a connection is cleaned up after a query execution and is available for reuse after the query execution ends. This Labs feature is disabled by default.

Enhanced Alerts

update

Update to Looker 21.14 to enable the Enhanced Alerts feature set, which includes a new way to view alert details and an updated UI on the Manage Alerts user page or the Alerts management page (for Looker admins) and synchronization between alerts and changes made to their underlying dashboard or tile.

Enhanced Navigation

update

Update to Looker 21.12 for a redesigned navigation experience that makes it easier for users to self-serve and organize their content.

Extension Framework

update

Update to Looker 21.12 for Looker’s extension framework to no longer be a Labs feature, and to enable or disable it in the Platform section of the Admin menu.

The Extension Framework switch allows developers to build and run Looker-hosted applications as well as install and run extensions from the Looker Marketplace, such as the Data Dictionary. Please note that developing on the Looker extension framework is free to use while in beta and will remain free for developers indefinitely. Terms and support will be finalized and introduced when this feature reaches General Availability. This Labs feature is disabled by default.

Pricing, terms, and other details for Marketplace content and extensions such as the Data Dictionary are listed within the relevant store page. Before users can install and use Marketplace extensions, a Looker admin must enable the Marketplace Labs feature.

Forecasting

update

Update to Looker 21.14 for the ability to quickly add data forecasting to new or existing Explore queries to help users predict and monitor specific data points.

Improved LookML Generation

update

Update to Looker 21.12 for an improved LookML generation experience with new features like auto-generated measures and inline comment explanations.

Incremental PDTs

Enables Looker to append fresh data to a persistent derived table (PDT) or an aggregate table where an increment_key is defined instead of rebuilding the entire table. This Labs feature is disabled by default.

Marketplace

update

Update to Looker 21.12 for Looker’s Marketplace to no longer be a Labs feature, to enable or disable it in the Platform section of the Admin menu, and to have the option to automatically install and update select Looker-built applications.

The Looker Marketplace is a central location for finding, deploying, and managing any type of Looker content, such as Looker Blocks, applications, visualizations, and plug-ins. This Labs feature is enabled by default.

You must enable the Local Project Import Labs feature to install Looker Blocks and any applications that contain a local_dependency parameter from the Marketplace. Presently, these applications leverage a local_dependency parameter:

New Explore Visualizations

When this feature is enabled, the Explore page and the dashboard tile edit window display the same style of funnel, timeline, single value, and table visualizations as those that appear on dashboard tiles, instead of the styles that appear in legacy dashboards and Looks.

Additionally, when you enable the New Explore Visualizations Labs feature, the drill overlay that appears when you drill into an Explore matches the style of the drill overlay that appears in dashboards, instead of the style that appears in legacy dashboards and Looks.

The New Explore Visualizations Labs feature is disabled by default.

New Query Streaming

SQL Runner Vis

Adds the ability to visualize ad hoc queries from SQL Runner. This Labs feature is disabled by default.

Upgraded Explore Field Picker

update

Update to Looker 21.10 for the ability to perform more general field searches in the field picker using search modifiers in the search bar.

The Upgraded Explore Field Picker Labs feature is enabled by default.

When this feature is enabled, an Explore will display an upgraded field picker with a smarter search capability, easy view and management of selected fields, Quick Start analyses for Explores with modeled queries, and other user experience improvements.

Visual Drilling

The Visual Drilling Labs feature is not supported by the new dashboard experience. Dashboards using the new dashboard experience support visual drilling through the use of the link parameter without the need to enable the Lab feature.

This Labs feature is enabled by default.

When Visual Drilling is turned off, the drill overlay always displays the data table.

When Visual Drilling is enabled, the drill overlays for Looks, Explores, and legacy dashboards select the best visualization based on the underlying data, which may be a table visualization or some other visualization type. Or, with Visual Drilling enabled, a drill visualization can be customized by using the link parameter, as shown on the link parameter documentation page and in the More powerful data drilling Help Center article. When the visualization from a drill is not a table, buttons allow the user to switch between the default visualization type and a data table.

For more information about visualization types, see the Visualization types documentation page.

Experimental features

Experimental Labs features may or may not remain in the product, and errors may or may not be corrected. These experimental features are intended to show you functionality that could be incorporated into Looker in the future. We always welcome your feedback.

Clear cache and refresh permission

update

Update to Looker 21.14 to use permission sets to control clear cache and refresh functionality for embedded and internal dashboards, legacy dashboards, dashboard tiles, Looks, and Explores.

Custom Fields

update

Update to Looker 21.14 for the ability to create ad hoc custom bins for numeric type dimensions with the Custom Fields Labs feature without needing to use logical functions in Looker expressions or needing to develop type: tier LookML fields.

update

Update to Looker 21.12 for the ability to create ad hoc custom groups for dimensions with the Custom Fields Labs feature without needing to use logical functions in Looker expressions or needing to develop CASE WHEN logic in sql parameters or type: case fields and, additionally, for the ability to use Quick Calculations to perform common calculations on numeric fields that are in an Explore’s data table without needing to use Looker functions and operators.

This Labs feature is disabled by default. When it’s enabled, this feature lets users with the create_table_calculations permission create additional, temporary fields on the Explore page that (unlike table calculations) become part of the query running in the database. Other users can see the new fields if they have the create_table_calculations permission themselves, if they are given the Explore query’s URL, or if they are given access to a Look or dashboard that uses that field.

Use the Custom Fields Labs feature if you want to let some of your business users have these capabilities:

For more information, see the Adding custom fields documentation page.

Dashboards in Drill Menus

Automatically suggests dashboards with matching filters.

Suggested dashboards will appear in the drill menu. In systems with many dashboards, this feature decreases dashboard performance.

Instant Dashboards

Dashboards display previous data while new queries are run.

If Instant Dashboards are enabled, when a dashboard loads, Looker pulls data from the cache to immediately display data from the previous run. The dashboard issues new queries that run in the background, and dashboard tiles are then updated as new data is retrieved. The spinner icon appears on the top right of each tile that is still loading, indicating that a query is running in the background and that the currently displayed data is from the last time the query was run. This has the advantage of users not seeing a blank dashboard while it’s loading, but the disadvantage of possibly showing stale data while the new queries run. Instant Dashboards are only supported by legacy dashboards.

Enabling Instant Dashboards also affects how long data is stored in the cache, since this feature relies on the existence of cached data to display.

Local Project Import

A LookML project can reference files in other locally maintained projects through the use of the local_dependency keyword in a manifest file. Enabling this Labs feature is not required to use the remote_dependency keyword. This Labs feature is disabled by default.

LookML Dashboard Organization

update

Update to Looker 21.16 to organize LookML dashboards outside the LookML Dashboard folder.

New Groups Page

The Groups page in the Users section of the Admin menu lists and lets you manage all the user groups on your Looker instance.

This Labs feature is disabled by default.

When New Groups Page is enabled, the Groups page displays a new, redesigned table and pagination that simplifies group management and increases performance on instances that have a large number of groups. For more information, see the New Groups page section of the Groups documentation page.

New Users Page

The updated Users page in the Users section of the Admin menu lets you manage all the users on your Looker instance.

This Labs feature is disabled by default.

When New Users Page is enabled, the Users page displays a new, redesigned table and pagination that simplifies user management and increases performance on instances that have a large number of users.

Prerender Iframes (before data loads) for custom visualizations

update

Update to Looker 21.12 to enable pre-rendering of custom visualization iframes before data is loaded.

Reduce Filter Queries

Reduce the number of queries sent by filters. This moves any filter that requests suggestions into a popover where it will not fetch suggestions until a user clicks on it.

This Labs feature is disabled by default.

Redux DevTools

update

Update to Looker 21.10 to enable the Redux DevTools Labs feature, which facilitates debugging application state.

Render Long Tables

update

Starting in Looker 21.12, the Render Long Tables Labs feature is supported as a beta rather than an experimental Labs feature and is enabled by default.

Reduces the dashboard PDF rendering times for dashboards that contain tables with many rows, by displaying an experimental faster table.

This Labs feature is disabled by default.

If Render Long Tables is enabled and the Expand Tables to Show All Rows download or schedule option is selected, dashboard tiles that contain table visualizations may look slightly different in downloaded or delivered PDFs than they do inside Looker. The following differences may be noticeable in the PDF:

Additionally, for tables with more than 20,000 cells, the following differences may be noticeable in the PDF:

Search Service

This Labs feature is available for Kubernetes-hosted Looker instances only.

This Labs feature is disabled by default. When enabled, Search Service enables a new content search function that returns better results and ranking.

Top