home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Looker documentation will be moving to cloud.google.com in mid-2022!
All the information you rely on will be migrated and all docs.looker.com URLs will be redirected to the appropriate page.
Looker 22 changelog

22.8

22.8 May 11, 2022
CHANGED
Looker legacy encryption is no longer supported. Customer-hosted instances must be migrated to GCM encryption prior to upgrade. Looker-hosted instances are not affected.
CHANGED
Compound primary keys have been added to the SQL derived tables in the System Activty dashboards.
CHANGED
Looker will no longer print sensitive authentication information for Redis connections to the log.
CHANGED
The Legacy Query Streaming legacy feature has been removed.
CHANGED
The Groups and Users pages have been redesigned and reimplemented in React. This includes the changing of UI flows for better UX and performance.
CHANGED
A dashboard will now re-run if its query parameters are updated through a redirect from a link on a dashboard.
ADDED
Error messages that are returned on database connection failures have been improved.
ADDED
The Looker Action Hub will now use the IP addresses 104.196.138.163 and 34.74.228.162 as endpoints. These IPs will be added to an invisible allowlist behind the scenes.
ADDED
The Forecasting Labs feature, which allows users to 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.
ADDED
Looker dashboard editors can now configure the dashboard filter location to be on the right for a particular dashboard.
ADDED
Looker project tab titles will now show more specific default text.
FIXED
Conditional formatting for XLSX should work as expected if the conditional formatting metadata references a non-existent field.
FIXED
A Schedule dialog that includes no prior plans, when opened from a context other than a dashboard, will show its own dashboard's filter rather than that of the previously opened dashboard.
FIXED
New query streamers should output identical HTML to the legacy query streamers.
FIXED
Pivoted JSON downloads with multiple aggregate fields should now nest correctly.
FIXED
A bug has been fixed in the System Activity Dashboards Explore where, previously, legacy dashboard links were incorrectly hardcoded to dashboards-next.
FIXED
XLSX downloads should now set the date type correctly.
FIXED
Previously, a PDT would try to rebuild into the same name as a previous attempt when that previous attempt had failed with a QueryKilled exception. This issue has been resolved.
FIXED
The cronstring parse logic has been modified so that minutes recurrence schedules with one-hour intervals are correctly displayed in the Admin Schedules panel. Previously, in such one-hour interval minutes recurrence schedules, the end-hour being set was incorrectly using using the default value for the end-hour (6pm). The logic has now been changed so that, for such one-hour intervals, the end-hour = start-hour + 1.
FIXED
LookML fields of type: date should format correctly in downloads.
FIXED
Cached Ruby dates should now be parsable by Kotlin XLSX streamers.
FIXED
A previous issue with Support Access settings could cause an unhandled state to lock users out of the instance. This issue has been resolved.
FIXED
Personal, group, and shared icons in the embedded Looker UI are now arranged vertically instead of horizontally.

22.6

22.6 April 14, 2022
CHANGED
A new legacy feature, Legacy LookML Runtime, disables New LookML Runtime by default for all LookML projects. This feature 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.
CHANGED
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.
CHANGED
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.
CHANGED
A maximum of 500 total bins can be created for each Bin custom field type.
CHANGED
Radio button filters will now have any value at the top instead of any option.
CHANGED
Looker Dialect HyperSQL has been downgraded to integration support level.
CHANGED
The Legacy Query Streaming toggle deprecation has moved to Looker 22.8, and the Legacy Value Formatting toggle has been removed.
ADDED
Advanced filter controls can be created to either allow multiple filter values or allow only a single filter value on dashboards.
ADDED
We have added support for a one-hour interval for minutes recurrence schedule. Now the interval field does not collapse when you select a one-hour interval with a minutes recurrence in the schedule plan dialog box.
ADDED
In addition to linking to Looks and dashboards, you can now add links to any URL from a board, making it easy to access destinations inside or outside of Looker.
ADDED
The PDT details modal of Looker's Persistent Derived Tables admin page now contains a link that lets users open PDT dependency graphs in a new tab.
ADDED
While in edit mode, dashboard creators can select the option to move a tile to the top or bottom of a dashboard.
ADDED
Amazon Aurora database connections now support a Cost Estimate option. This option enables cost estimates for Explore queries, cost estimates for SQL Runner queries, and computation savings estimates for aggregate awareness queries on the connection. Also in Looker 22.6, cost estimates are always enabled for MySQL connections and MySQL on Amazon RDS connections.
ADDED
We have introduced a beta Labs feature, Custom buttons for dashboard. When this feature is enabled, users can add URL links as buttons on dashboards.
ADDED
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.
ADDED
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.
ADDED
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.
ADDED
Dashboard tiles can be made very small to increase information density. You can even hide the title of a tile to take full advanage of the feature.
FIXED
Filters with options will now correctly show the selected values when the options contain special characters like a backslash, caret, or trailing whitespace.
FIXED
In some cases, inconsistent names were previously used in XLSX downloads. This behavior has been corrected; now "sheet1" is used as the name of the sheet.
FIXED
In some cases, raw date fields and Boolean values with run_look in JSON format were inconsistent. This behavior has been corrected via the new streamers.
FIXED
A change to the schedule modal enables action destinations forms to be displayed for saved schedule plans.
FIXED
Cached queries streamed through the new query streamers against Snowflake with the QUOTED_IDENTIFIERS_IGNORE_CASE setting enabled should now output data as expected.
FIXED
Multiple aggregate fields in a cached streamed query should now be visible in downloads.
FIXED
Conditional formatting with font and background colors using three-digit hex codes should now work for XLSX downloads.
FIXED
In some cases, type: date LookML fields were formatted incorrectly in downloads. This behavior has been corrected.
FIXED
Year and month dates should now display correctly in XLSX downloads when you use the legacy query streamers.
FIXED
An issue where users could not set or update their HTTPS credentials for remote project import has been fixed.

22.4

22.4 March 14, 2022
CHANGED
Transport Layer Security (TLS) 1.0 and 1.1 will be deprecated on September 19, 2022. Looker-hosted customers don't need to take any action. Self-hosted customers will need to update their internal database to a version that supports TLS 1.2+. For MySQL, version 5.6.46+ supports TLS 1.2+.
CHANGED
Filenames in a LookML project can no longer contain the % character. Existing files that contain % characters will display an error and a tooltip that explains why the files need to be renamed to remove the character. See the naming conventions for more information.
CHANGED
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.
CHANGED
The User Activity dashboard has been updated to use a compliance_user_permissions table to ensure that user counts displayed in the dashboard show the latest results from this table.
CHANGED
The User Activity dashboard has been updated to match contractual verbiage for User type descriptions ("Content Creator" is now "Standard"; "Data-Consumer" is now "Viewer").
CHANGED
The logic of user_facts.is_looker_employee has been adjusted to count only support agents.
ADDED
Looker now supports MySQL 8.0 as an internal database. Looker-hosted customers don't need to take any action. Self-hosted customers who use MySQL as their internal database may update their internal database version.
ADDED
The Looker API 4.0 is now generally available.
ADDED
There is now a separate permission for creating and editing custom fields: create_custom_fields. This permission lets admins control which users can create or edit custom fields, while letting them create and edit table calculations with create_table_calculations. Users who had the create_table_calculations permission on instances with the Custom Fields Labs feature enabled prior to Looker 22.4 will automatically be granted the create_custom_fields permission.
ADDED
Unencoded % characters in URLs cause some Looker pages, such as Explores, to not load. Previously Looker did not prevent the use of % characters in IDE filenames, and customers were not warned that using these characters in filenames might break certain pages. This change prevents the use of the % character in filenames in the Looker IDE when files are created or renamed; additionally, an error and a tooltip now appear in the IDE file browser when these filenames are present, explaining that these files should be renamed.
ADDED
To address potential Content Security Policy (CSP) violations, there will be a new loading mechanism for the Looker extension framework. With this release, there is a method for developers to test their extensions with the new loader to fix any potential issues before the new loader goes live.
ADDED
PostgresSQL and Amazon Redshift connections now support a Cost Estimate option. This option enables cost estimates for Explore queries, cost estimates for SQL Runner queries, and computation savings estimates for aggregate awareness queries on the connection.
ADDED
A new configuration has been introduced: --max-scheduled-plans allows admins to limit the number of active scheduled plans if necessary. Not enforced by default.
ADDED
The schedule editor modal now supports pre-population of the secret key for Amazon S3 schedules. This means that the user won't need to manually enter the secret key while editing an Amazon S3 schedule.
ADDED
An Add button on the Connections page in the Admin panel now displays a popover that contains a copy-able list of the available egress IPs.
ADDED
Configurable cost estimate support has been added for Redshift. The new setting is @cost_estimate_style = :configurable. The configurable cost estimate feature is gated behind the Cost Estimate connection setting.
ADDED
The API Usage Explore has been added to the Explore menu UI.
ADDED
The Permission Set Type dimension has been added to the Permission Set view.
FIXED
The Test As User functionality on the New Connection page was not working. This behavior has been corrected.
FIXED
Custom embed themes applied from a URL are now considered part of dashboard-next schedules.
FIXED
Customers shared scratch schemas across instances where PDT maintenance was being run less frequently than once per week, which was causing one instance to drop all the others' tables because of an inactive registration key. This behavior has been corrected with a dynamically set registration key, whose lifetime is greater than the maximum PDT maintenance interval.
FIXED
Under certain circumstances, Looker would render dates from Explores and Looks into XLS and CSV incorrectly. This behavior has been corrected.

22.2

22.2 February 11, 2022
CHANGED
Errors that occur before any data is streamed will now be injected into XLSX downloads.
CHANGED
When a table chart column is resized, the contents of the header row automatically wrap to multiple lines, if necessary, so the content is clearly readable. This can be configured with the new Truncate Column Names table chart option.
ADDED
A new API endpoint, import_lookml_dashboard, copies a LookML dashboard as a user-defined dashboard and saves it in a folder.
ADDED
Starting in Looker 22.2, Looker supports OpenJDK 11, and Looker-hosted deployments will use OpenJDK 11 by default. Customer-hosted deployments can upgrade to OpenJDK 11.
ADDED
When you add a new tile to a dashboard, any existing dashboard filters will automatically be applied to filterable fields on the tile.
ADDED
ADDED
A new Enable PDT API Control connection setting enables three new API calls: start_pdt_build, check_pdt_build, and stop_pdt_build.
ADDED
When you hover over a column header in a table chart, a tooltip now displays the full name of the column header.
ADDED
You can now move LookML dashboards into folders other than the LookML Dashboards folder.
FIXED
Queries that are executed with a username that is specified from user_attributes will no longer be incorrectly identified as zombie queries and killed.
FIXED
All C0 escape characters are now properly escaped for downloaded reports.
FIXED
Users who do not have access to any boards will no longer see endless loading when they attempt to add a dashboard to a board.
FIXED
Previously, a folder that had a trailing space in its name and that was created with the API could not be deleted. This behavior has been corrected.
FIXED
Previously, Group custom field types that were created on dimension_group fields could fail to activate necessary joins in SQL. This behavior has been corrected.
FIXED
Previously, users could not create a Group custom field type on existing custom fields. This behavior has been corrected.
FIXED
An issue was found where $$ was shown as $ on Explore tables. This behavior has been corrected.
FIXED
An issue was found with Aragonite and localized LookML models where labels in downloads showed their raw values rather than their localized values. This behavior has been corrected.
FIXED
An issue was found with the Aragonite beta feature where invalid field references in a sql_distinct_key in LookML could cause LookML Validator to crash. This behavior has been corrected.
FIXED
An issue was found where using dimension fill on a field with datatype: date could crash the new Aragonite runtime. This behavior has been corrected.
FIXED
An issue was found where Aragonite caused a 500 error to be returned in the case where a query that contained a custom measure was filtering on a field that no longer existed. This behavior has been corrected.
FIXED
An issue was found with the new Aragonite runtime where, after a LookML change or restart, some queries on a dashboard might fail to load but would then load on refresh. This behavior has been corrected.
FIXED
An issue was found where Aragonite would crash on an invalid filter on a measure of type: list. This behavior has been corrected.
FIXED
An issue was found with Aragonite where a Median custom field type could cause a 500 error. This behavior has been corrected.

22.0

22.0 January 13, 2022
CHANGED
A new save flow available from the Explore page lets users include, as dashboard filters, filters that are on the first query users save to a dashboard.
CHANGED
Users now have better visibility into server errors when using Explores.
CHANGED
Private embed users can now be granted browse access to the Shared folder.
CHANGED
The URL Links in Boards Labs feature is now on by default for all customer instances.
CHANGED
Support access is disabled by default for all instances. Customers now must use an allowlist to grant specific people access to their instance.
CHANGED
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.
CHANGED
Updates to custom fields and table calculation field picker menu options include renaming Quick Calculations to Calculations, renaming the List and Count custom field types to, respectively, List of unique values and Count distinct, and other small changes.
CHANGED
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.
CHANGED
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).
CHANGED
Max scheduled job age is now configurable with env var SCHEDULED_JOB_MAX_AGE_DAYS=20.
CHANGED
A new legacy feature, Allow double click to select text in textarea in Table Visualizations, lets users double-click on table cell values to manually select text. The legacy feature will be removed starting in Looker 22.20.
CHANGED
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.
ADDED
Looker administrators now have the ability to make all users' personal folders private by default using the Default Private Personal Folders option from Looker's general settings page.
ADDED
The GET /folder/:id API endpoint (in all API versions) now returns LookML dashboards that have been moved into the folder using the LookML Dashboard Organization feature.
ADDED
Spartan-specific links are now generated for spartan users.
ADDED
The Embed Content Management Labs feature is now in open beta. This feature enables content management features such as moving, copying, and deleting content from the new embed navigation page.
ADDED
The Cookieless Login Labs feature is now in open beta. This feature enables limited SSO embedding functionality for browsers that block third-party cookies.
ADDED
The left navigation menu can now be toggled using a keyboard shortcut (Command+; on Mac or Ctrl+; on Windows).
ADDED
Table Calculations can be added by using the Add Calculations button on the Data bar when the Custom Fields Labs feature is enabled, and users now have access to shortcut calculations when the Custom Fields labs feature is not enabled.
ADDED
The new At a Glance section on the PDT Admin page provides key PDT monitoring information in a condensed format.
ADDED
For a small subset of Looker customers, query holding can be a significant bottleneck. For cases with heavy dynamic attributes usage, it may be preferable to toggle off held queries entirely. If Looker is started with the command line argument
--experimental-features=query-holding-opt-out, queries will not be held.
ADDED
A field has been added to let customers add their preferred key exchange algorithm to the SFTP scheduled plan destination.
ADDED
Users can now sort on columns in a drill overlay.
FIXED
Using the LookML Dashboards Organization feature sometimes caused certain dashboard menu options to be unavailable. This behavior has been corrected.
FIXED
Conditional formats now work correctly on the new XLSX streamer.
FIXED
If a dashboard had two tiles that had the same queries/SQL but that were hiding different fields from visualization, two queries with the same SQL were sent to the database instead of just one. This behavior has been corrected.
FIXED
Conditional formatting colors differed when content was downloaded in Excel format. This behavior has been corrected.
FIXED
Special characters were not escaped in API JSON responses. This behavior has been corrected.
FIXED
Double-pivoted Looks that were scheduled or sent in CSV format with all results only showed the second pivot in the header. This behavior has been corrected.
FIXED
In some scenarios, a query that was in a complete state would allow clients to fetch the results but encounter issues if the results contained error messages. Because these results had not been written to the cache, they would sometimes be reported as “missing.” This behavior has been corrected.
FIXED
In some scenarios, customers could see extended render times for dashboards when using HSQL. This behavior has been corrected.
FIXED
In some cases, a customer could exceed the Looker database primary key size. This behavior has been corrected.
FIXED
Looker has addressed some cases that were impacting LookML dashboards' folder movement and loading.
Top