Looker 22 release highlights

Looker 22.20

Expected rollout start: Monday, November 14th, 2022
Expected final deployment and download available: Thursday, December 1st, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • The Use old dashboard routes legacy feature has been removed. This means that, in URLs and other dashboard file paths, /dashboards/ indicates a new dashboard experience dashboard, and /dashboards-legacy/ indicates a legacy dashboard.
  • The Can use Legacy Dashboards legacy feature has been added.
  • The Prerender iframes (before data loads) for custom visualizations Experimental Labs feature has moved to Beta.
  • The Data Studio feature has been removed from Labs. Users may link their Google account with their Looker account to access Looker instances with Looker Studio.
  • Stacked chart visualizations for queries that have Row Totals selected now include a series for row totals (previously this was supported for group charts, but not stacked charts). This may cause unexpected behavior in stacked chart visualizations for queries that include row totals, which previously excluded the row totals series from the visualization. To exclude this series from a visualization, either clear Row Totals from the Data bar, or select Hide from visualization in the Row totals column gear menu.
  • Area visualizations with null values that also have the Unpin Axis From Zero setting turned on and the Plot Null Values setting turned off will now behave as expected and unpin the y-axis from 0. An issue that has since been resolved was causing area charts to plot these visualizations from 0.
  • The Revert to Legacy Dashboards legacy feature was removed in Looker 22.20. You can no longer use the new dashboards UI to downgrade a dashboard to a legacy dashboard.
  • The configuration settings for SAML, LDAP, and OIDC authentication types have changed. When mirror LDAP/SAML/OIDC groups configuration is turned off under the Groups & Roles section for the respective authentication type, Looker can no longer use an externally managed group as the default group for new users when they first log in to Looker. Admins will need to change the New User Groups setting to a non-externally managed group before making any changes to the existing configuration.
  • Custom fields is now generally available.

New BI visualizations

New ways to visualize your BI data

Looker's new visualizations include the following:


Connected Sheets

Connected Sheets for Looker generally available as of 22.20

This feature must be enabled using a new Admin setting.

  • Connected Sheets for Looker lets you explore data from your LookML models through the familiar Google Sheets interface.
  • Looker admins must first enable the feature on the new BI Connectors admin page, which can be found in the Platform section of Looker's Admin menu

  • Connected Sheets for Looker and the new BI Connectors admin page are available only for Looker instances that are hosted on Google Cloud.


Looker iOS Mobile App

Drilling support and alerts in Looker iOS mobile app

Looker iOS mobile app now includes drilling support that users can leverage to drill data similar to Looker Web.

Looker users can now receive data alerts via push notifications on their iOS devices that will allow them to get those on the go and take timely action.


Legacy dashboards

Legacy dashboards are being removed

The Revert to Legacy Dashboards legacy flag has been removed as of Looker 22.20. This means that you can no longer use the new dashboards UI to downgrade a dashboard to a dashboards-legacy. The Can use Legacy Dashboards legacy feature has been added to enable users to view legacy dashboards until it is deprecated in Looker 23.6. For more information, see the Removing the legacy dashboard experience - a timeline from Looker 21.20 (November 2021) through Looker 23.6 (April 2023) Best Practices page.


Cookieless embeds

Modern cookieless embedding authentication preview

Cookieless Embed is an experimental Labs feature that allows an embed user session to be created without the use of cookies. This features will require some server side configuration. Please see the Looker JavaScript Embed SDK README for setup instructions. The Cookieless Embed feature is set to ON by default.

Looker 22.18

Expected rollout start: Monday, October 17th, 2022
Expected final deployment and download available: Thursday, October 27th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • The Dashboard Filters Location Labs feature is now out of Labs and is generally available.
  • The Custom buttons for dashboards Labs feature is now out of Labs and is generally available.
  • The Custom Fields Labs feature is enabled by default across Looker instances.
  • API 4.0 was made generally available (stable) in Q1 2022. The majority of the API endpoints were promoted to stable to correctly reflect their status. Endpoints marked as beta are still subject to breaking changes.
  • Dashboard buttons linking to other Looker pages will keep the /embed prefix if redirected from an embedded dashboard.

New ways to connect Looker and Looker Studio

New Labs options to view Looker data in Looker Studio

The Looker connector, now available in Public Preview, lets you view data from a Looker Explore in a Looker Studio report by connecting Looker as a data source. If you would like to view Looker data in a Looker Studio report, first enroll in the Public Preview by filling out a Looker Studio / Looker Integration Public Preview form. Once enrolled, you can:

The Looker connector and associated Labs features are available only for Looker instances that are hosted on Google Cloud.

Looker 22.16

Expected rollout start: Monday, September 19th, 2022
Expected final deployment and download available: Thursday, September 29th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • Transport Layer Security (TLS) 1.0 and 1.1 will be deprecated. Effective September 19, 2022, this will require customer-hosted users to update their internal database to a version of MySQL (5.6.46 or later) or to a version of an alternate DBMS that supports TLS 1.2 or later. Customers (both those who host their own databases and those for whom Looker hosts their databases) who use MySQL as a data source will also need to ensure that these databases are version 5.6.46 or later.
  • Key frontend dependencies for the Looker application will end support for IE11 in 22.16.
  • Customer-hosted instances using SendGrid. As of Looker 22.16, the SendGrid services on customer-hosted instances is deprecated as the default SMTP service. Customers can still configure their own managed SMTP services for their customer-hosted Looker instances.

Content Navigation for Embed

New Labs Option for Embed Content Navigation

A new Looker Labs feature Embed Content Navigation controls whether the new embed content navigation is available on an instance. This Labs feature will now default to on, with the option of being disabled. Enhanced content navigation is now available for embedded Looks and Explores.


Enhanced Query Admin UI

Query Admin UI update and pagination enhancement

A Looker Labs feature that migrates the Query Admin UI from Angular to React refreshes the look-and-feel with standard Looker components. In addition, pagination is available, as well as a separate tab for recent and complete queries, allowing customers with large history tables to effectively administer their instances.


General availability of Query Metrics in System Activity

Performance Recommendations dashboard is now GA

The Query Performance Metrics Explore and Performance Recommendations dashboard are now generally available.

Looker 22.14

Expected rollout start: Monday, August 15th, 2022
Expected final deployment and download available: Thursday, August 25th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • Sorting behavior has been changed for bin type custom fields on an Explore, such that they are sorted according to the tier number instead of alphabetically on the bin column.

New LookML Runtime is GA

New LookML Runtime is generally available and enabled by default across Looker instances.

  • The New LookML Runtime feature is now GA and enabled by default across Looker instances.
  • New LookML Runtime provides faster LookML validation and content validation, more performant loading of Explores and dashboards, and faster SQL query writing, among other performance improvements.
  • You can disable the New LookML Runtime feature for a specific project by adding new_lookml_runtime: no to the project's manifest file.
  • You can revert to legacy LookML runtime at the instance level by turning on the Legacy LookML Runtime legacy feature.

Persistent derived tables (PDTs) for Google BigQuery connections with OAuth

Persistent derived tables (PDTs) are now supported for Google BigQuery connections that use OAuth authentication.

For Google BigQuery connections that use OAuth, Looker can now access your database for PDT processes using a separate BigQuery service account that you specify in Looker's connection settings. See Enabling PDTs for Looker connections to BigQuery with OAuth for more information.


Looker Docs are migrating

Docs will be found at cloud.google.com/looker/docs beginning on August 22, 2022.

  • All documentation pages will be migrated.
  • Redirects will be put in place so that docs.looker.com URLs will arrive at the proper location.

Looker 22.12

Expected rollout start: Monday, July 18th, 2022
Expected final deployment and download available: Tuesday, August 2nd, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • To improve query performance, the history table has been split. As a result, query context comments and Google BigQuery job labels will no longer include a history_id value. Use history_slug instead. If you have a workflow that relies on running query data, this might be a breaking change for you. Please review your workflows for any potential impact.
  • The Add Looks to dashboards legacy feature has been removed. You can no longer add tiles based on saved content (also known as "Looks") to dashboards directly from the Add menu. See the Adding tiles from a Look section on the Creating user-defined dashboards documentation page for adding saved content to dashboards.**


Dashboards

Add a dashboard to one or more boards.

You can now add a dashboard to one or more boards by selecting the Add to boards button on the dashboard.

Looker 22.10

Expected rollout start: Monday, June 13th, 2022
Expected final deployment and download available: Thursday, June 23rd, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • There are no breaking changes with Looker version 22.12

Table Column Ordering

Manual column ordering is now respected in downloads for most cases.

Manual column ordering in table visualizations is now respected in most cases for downloaded data when With visualization options applied is selected in the download pop-up. Some exceptions apply: see the Downloading content page for more information.

Looker 22.8

Expected rollout start: Monday, May 16th, 2022
Expected final deployment and download available: Thursday, May 26th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • Beginning with Looker 22.8, Looker Legacy Encryption is no longer supported. Instances must be migrated to GCM Encryption prior to upgrade. AES-256 Galois/Counter Mode (GCM) encryption is now the default for customer-hosted installations. Admins of new customer-hosted installations will have to generate an encryption key before installing the Looker application.

Forecasting

A new Labs feature lets users automatically project a forecast on top of their Explore data.

The Forecasting Labs feature, which lets users add data projections to new or existing Explore queries to help users predict and monitor specific data points, is now enabled by default in preparation for general availability.

Looker 22.6

Expected rollout start: Monday, April 18th, 2022
Expected final deployment and download available: Thursday, April 28th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • AES-256 Galois/Counter Mode (GCM) encryption is now the default for customer-hosted installations. New customer-hosted installations will have to generate an encryption key before installing the Looker application. Looker Legacy Encryption will no longer be supported starting in Looker 22.8. Instances must be migrated to GCM Encryption prior to upgrade.
  • A new legacy feature, Legacy LookML Runtime, disables** New LookML Runtime** by default for all LookML projects. Can be overwritten by adding the new_lookml_runtime LookML parameter to a LookML project's manifest file.
  • A new legacy feature, Legacy Hosted Action Hub, allows all hosted action requests to instead use the Legacy Hosted Action Hub. The legacy feature will be removed starting in Looker 22.12.

Enhanced Action Hub is now GA

The Enhanced Action Hub Service offers improved reliability, performance, and scalability.

  • New actions offer integrations for sending data from Looker to Salesforce and Facebook for better targeting. With the Salesforce Campaigns Action, customers can send custom lists of leads or contacts from Looker to populate new or existing campaigns within Salesforce.
  • With the Facebook Custom Audiences Action, customers can use their first-party data within Looker to create, update, or replace customer lists in Facebook Custom Audiences.

New LookML Runtime

New LookML Runtime improves speed and performance.

new_lookml_runtime: yes

  • Offers faster LookML and content validation, more performant loading of Explores and dashboards, and faster SQL query writing.
  • Enabled by default. Can be disabled at the project level with the new_lookml_runtime LookML parameter, or at the instance level with the Legacy LookML Runtime legacy feature.

First Time User Experience

We've created an onboarding walkthrough for first-time users.

  • Admins logging in to new trial Looker instances for the first time will see guidance in the UI to help set up their instance and to connect to and explore their data.
  • These guides will show up only for new instances whose locale/language is set to English, starting with Looker 22.6.

Looker Marketplace

The updated Looker Marketplace offers an improved experience.

Looker Marketplace now offers improved performance and installation reliability.


PDT dependency graphs in a new tab

Lets users open PDT dependency graphs in a new tab from the PDT details modal.

Looker 22.4

Expected rollout start: Monday, March 14th, 2022
Expected final deployment and download available: Wednesday, March 30th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • Customers on Looker 22.4 need to update their mobile app version to the latest Looker mobile version (v1.2.3) to continue using Looker on iOS mobile devices.
  • Filenames in a LookML project can no longer contain a % character. Existing files that contain % characters will display an error and a tooltip explaining why the files need to be renamed to remove the character.

API 4.0

The new Looker API 4.0 is now GA.

  • This generally available Looker API version has multiple breaking and additive changes that promote multiple endpoints from beta to stable. Read more about these changes in this document.
  • The Looker API 3.1 and 3.0 versions are unaffected.
  • Looker and community-supported SDKs will be updated to support Looker API 4.0 GA endpoints.

Custom fields permission

Looker is introducing a standalone permission for custom fields used in Explores: create_custom_fields.

  • Grants users the specific permission to create and use custom fields in Explores.
  • Separates a user's ability to create custom fields from the user's ability to create table calculations.

Looker 22.2

Expected rollout start: Monday, February 15th, 2022
Expected final deployment and download available: Thursday, February 24th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • Errors that occur before any data is streamed will now be injected into XLSX downloads.
  • When a table chart column is resized, the content of the header row automatically wraps to multiple lines, if necessary, so the content is clearly readable. This can be configured with the new Truncate Column Names table chart option.

Organize LookML dashboards in folders

We've introduced the ability to add LookML dashboards to folders.

  • Lets users move LookML dashboards into folders other than the LookML Dashboards folder.
  • Brings parity to how user-defined dashboards can be organized.
  • Lets users place better access controls on LookML dashboards.

Looker 22.0

Expected rollout start: Tuesday, January 18th, 2022
Expected final deployment and download available: Thursday, January 27th, 2022

Potentially breaking changes

Check out these potentially breaking changes! Depending on which features or configurations you have implemented, all, some, or none of these changes may apply to your instance.

  • PrestoSQL and Trino now default to set SSLVerification=NONE (if Verify SSL is not set) or set SSLVerification=FULL (if Verify SSL is set). If you set your own value for SSLVerification, that value will be used.
  • Support access is disabled by default for all instances. Customers must use an allowlist to grant specific people access to their instance.
  • The following JDBC drivers have been updated: Firebolt (v.1.21), Microsoft SQL Server (v.9.4), Databricks Spark (v.2.6.21.1039), and Amazon Athena (v.2.0.25.1001).
  • Popular fields are no longer displayed in the field picker search bar. Admins can enable a legacy feature, Popular fields in explore search, to restore the Popular Fields drop-down to Explore searches. The legacy feature will be removed starting in Looker 22.20.
  • A new legacy feature, Allow double click to select text in textarea in Table Visualizations, allows users to double-click on table cell values to manually select text. The legacy feature will be removed starting in Looker 22.20.
  • A new legacy feature, Save as Look keyboard shortcut, allows users to save as Looks by using a keyboard shortcut. The legacy feature will be removed starting in Looker 22.14.

Dashboards updates

The Looker default dashboard experience has been improved.

  • A new save flow that is available from the Explore page lets users include filters that are on the first query they save to a dashboard as dashboard filters.
  • Dashboard creators can now create dashboard filters on fields from Explores that are not present on the dashboard by turning on the Advanced toggle in the filter creation flow.

PDTs at a glance

The new At a Glance section on the PDT Admin page lets you quickly view key PDT monitoring information.

A new At a Glance section on the PDT Admin page provides key PDT monitoring information in a condensed format.


Labs features updates

We've introduced a new Labs feature and updated some existing Labs features.

An admin user can enable the Enhanced Action Hub Service Labs feature to improve reliability and performance of the Looker Action Hub.