Looker 22 release highlights

Stay organized with collections Save and categorize content based on your preferences.

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 with the exception of the API reference.
  • The API reference will now be found on the Looker Developer Portal (https://developers.looker.com/api/explorer/4.0/), which has faster, better formatted, more interactive pages.
  • 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 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. The legacy feature will be removed starting in Looker 22.20.
  • 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.