Labs overview
Looker Labs features are new, in-progress features whose details may change over time. Labs features are split into two categories:
- Beta: These features are expected to remain in the product, and errors are expected to be resolved at some point. However, these features may change in detail, and errors may not be fixed with the same speed as with normal features. You can see the list of current beta Labs features in the Beta features section on this page.
- Experimental: These 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 and to get your feedback. You can see the list of current experimental Labs features in the Experimental features section on this page.
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.
Custom Fields
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 that is 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:
- Create semi-permanent measures and dimensions for a one-time or an infrequent analysis
- Create semi-permanent measures and dimensions without needing an analyst
For more information, see the Adding custom fields documentation page.
Database Connection Pooling
This Labs feature is disabled by default.
This feature 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.
Embed Content Management
New in Looker 22.0 is the Embed Content Management Labs feature.
This Labs feature is disabled by default.
This feature enables content management features like moving, copying, and deleting content from the new embed navigation pane.
Forecasting
This Labs feature is disabled by default.
This feature enables forecasting in visualizations.
Improved LookML Generation
This Labs feature is disabled by default.
This feature improves the LookML generation experience and adds new features like auto-generated measures and inline comment explanations to new LookML projects that are generated from your database.
LookML New Runtime (Aragonite)
This Labs feature is enabled by default.
The Aragonite runtime provides faster LookML validation and content validation, more performant loading of Explores and dashboards, and faster SQL query writing, among other performance improvements.
The LookML New Runtime (Aragonite) Labs toggle enables the option to use Aragonite on the Looker instance. When the LookML New Runtime (Aragonite) Labs feature is enabled (which is the default), LookML developers can then turn on Aragonite for individual LookML projects on the instance by adding the aragonite: yes statement to a project’s manifest file.
When Aragonite is enabled for a project, LookML validation may return a greater number of errors for the project. This is because Aragonite allows for improved validation capabilities, which means that previously overlooked errors may surface.
A Looker admin can disable the LookML New Runtime (Aragonite) Labs feature, which means that Aragonite cannot be used for LookML projects on the Looker instance. When the LookML New Runtime (Aragonite) Labs feature is disabled, all LookML projects on the instance will use the legacy runtime, even if the project has the aragonite: yes statement in its manifest file.
New Explore Visualizations
The New Explore Visualizations Labs feature is enabled by default.
When this feature is enabled, the Explore page and the dashboard tile edit window display the same style of funnel chart, 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.
Render Long Tables
This Labs feature is enabled by default.
This feature reduces the dashboard PDF rendering times for dashboards that contain tables with many rows, by displaying an experimental faster table.
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:
- Customizations to background colors and font sizes are removed from column headers and subtotal rows.
- Tables appear in the white theme.
- The sort icon does not appear on pivoted tables that were not manually sorted.
- Tables with Size Columns to Fit enabled stretch to the full width of the tile.
Additionally, for tables with more than 20,000 cells, the following differences may be noticeable in the PDF:
- Conditional formatting options other than Background color no longer appear.
- Cell visualizations on numeric columns no longer appear.
SQL Runner Vis
This Labs feature is disabled by default.
This feature adds the ability to visualize ad hoc queries from SQL Runner.
URL Links in Boards
This Labs feature is enabled by default.
When this feature is enabled, users may add any URL to a board, in addition to Looks and dashboards. This makes it convenient to access destinations inside or outside of Looker from a board.
Visual Drilling
This Labs feature is enabled by default.
The Visual Drilling Labs feature is not supported by dashboards. For these dashboards, visual drilling is possible through the use of the link parameter without the need to enable the Lab feature.
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
This Labs feature is enabled by default.
When the Labs feature is enabled, the clear_cache_refresh permission determines users’ abilities to clear cache and refresh embedded and internal dashboards, legacy dashboards, dashboard tiles, Looks, and Explores.
The Labs feature enables the use of the clear_cache_refresh permission, the presence of which in a permission set allows users to clear cache and refresh.
If the Labs feature is disabled, clear cache and refresh functionality is unchanged from previous releases. Users can clear cache and refresh internal dashboards, legacy dashboards, dashboard tiles, Looks, and Explores. Embedded users can clear cache and refresh embedded Looks and Explores. Embedded users are not able to clear cache and refresh embedded dashboards, legacy dashboards, and dashboard tiles.
The clear_cache_refresh permission can be granted regardless of whether the Labs feature is enabled or disabled, but the permission will have no effect if the Labs feature is disabled.
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.
Embed Cookieless Authentication
New in Looker 22.0 is the Embed Cookieless Authentication Labs feature.
This Labs feature is disabled by default.
This feature enables limited SSO embedding functionality for browsers that block third-party cookies.
Enhanced Action Hub Service
Looker’s Enhanced Action Hub Service architecture improves reliability and performance.
This feature is available only for GCP-hosted Looker instances. Looker instances already utilizing the Looker Action Hub’s static egress IP addresses must add a new IP address to their allowlist.
This feature is disabled by default.
Guided analyses in System Activity
When enabled, the History System Activity Explore displays guided analysis options to leverage a question-and-answer format for performing analyses.
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
This Labs feature is disabled by default.
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.
LookML Dashboard Organization
This Labs feature is disabled by default.
When this feature is enabled, LookML dashboards can be moved outside of the LookML dashboards folder. Rather than creating a user-defined dashboard copy of the LookML dashboard, this feature allows LookML dashboards to reside alongside user-defined dashboards in shared folders and personal folders.
Users can move a LookML dashboard out of the LookML dashboards folder only if they have the see_lookml_dashboards permission. Also, users can move the LookML dashboard only into folders for which they have the Manage Access, Edit folder access level.
The option to move LookML dashboards outside of the LookML dashboards folder will not be shown while Development Mode is on. Instead, an Import option will be shown, which converts the LookML dashboard to a user-defined dashboard.
A folder that contains both user-defined dashboards and LookML dashboards will display the LookML dashboards in a LookML Dashboard section. Users can move LookML dashboards to other locations in the same way that they can move user-defined dashboards. Users can also pin LookML dashboards to a board. However, unlike user-defined dashboards, LookML dashboards may not be copied, upgraded, renamed, scheduled, or moved to the trash from a folder.
Once a LookML dashboard has been moved out of the LookML dashboards folder, it no longer appears in that folder. To instead copy a LookML dashboard as a user-defined dashboard and save the copy outside of the LookML dashboards folder, see the Converting from LookML to user-defined dashboards documentation page.
Disabling this Labs feature returns all LookML dashboards to the LookML dashboards folder. Changing the value of a LookML dashboard’s dashboard parameter also returns it to the LookML dashboards folder.
New Groups Page
This Labs feature is disabled by default.
The Groups page in the Users section of the Admin menu lists and lets you manage all the user groups on your Looker instance.
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
This Labs feature is disabled by default.
The updated Users page in the Users section of the Admin menu lets you manage all the users on your Looker instance.
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
This Labs feature is disabled by default.
This feature reduces the custom visualization loading time by starting to render the iframe even before query data has been loaded.
Reduce Filter Queries
This Labs feature is disabled by default.
This feature reduces the number of queries that are 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.
Redux DevTools
This Labs feature is disabled by default.
This feature enables Redux DevTools for debugging application state.