22.20
changed Starting in Looker 22.20, custom fields are generally available and admins no longer need to enable a Labs feature in addition to granting permissions to let users create, edit, or delete custom fields. changed The Render Long Tables Labs feature is now out of Labs and generally available. All PDF and PNG rendered tables now use the faster React-based component. changed The WYSIWYG Text Tiles Labs feature is now out of Labs and generally available. Dashboard creators and editors can create new Text tiles with a visual editing experience. changed The Prerender Iframes (before data loads) for custom visualizations Labs feature is now a Beta feature rather than an Experimental feature. changed Starting in Looker 22.20, the Link to Data Studio from Explore feature is generally available and admins no longer need to enable a Labs feature to let users open Explore queries in a Looker Studio report. changed The Open in Data Studio Explore actions gear menu option has been renamed to Open in Looker Studio. changed The Revert to Legacy Dashboards legacy flag has been removed as of Looker 22.20. This means that users can no longer use the dashboards UI to downgrade a dashboard to a legacy dashboard. changed Stacked chart visualizations for queries that have Row Totals selected will 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 on the row totals column gear menu. changed 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 now need to change New User Groups to non-externally managed groups before making any changes to the existing configuration.changed You can now hide individual pivots from visualizations. added The Labs feature Full Screen Visualizations has been added to allow visualizations to be viewed at full screen within dashboards.
added Connected Sheets for Looker is generally available as of Looker 22.20. This feature must be enabled using a new Admin setting, and is available only for Looker instances that are hosted on Google Cloud. added 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. added The Looker iOS mobile app now includes drilling support that users can leverage to drill data similar to Looker Web. In addition, 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. added Data History Playback produces a time-based animation of the tile's query, displaying the changes in data for that query over time. Data History Playback is available for tiles that contain data from an Explore that contains a time field, even if the time field is not present in the query the tile is based on. If a tile is based on an Explore that contains no time fields, Data History Playback is unavailable and disabled in the three-dot Tile actions menu. Data History Playback is also unavailable for merged results tiles. added You can now use the Cluster Points option to group many data values into blocks, which can help improve the readability of your visualization when your data appears in high-density groupings. added You can now zoom into and enlarge a specific part of any Cartesian visualization. added You can now enable any visualization on a dashboard to be expanded and viewed in full screen. fixed Previously, the SQL Runner query tab was not resizing correctly when other tabs were opened or closed. This issue has been resolved. fixed Cancelling an attempt to unsubscribe from receiving scheduled content deliveries no longer erroneously unsubscribes you from those deliveries. fixed Looker will no longer hold locks forever under certain embed use case scenarios. fixed The format of subtotals in the PDF rendering context has been fixed. fixed 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.22.18
changed The majority of API 4.0 beta endpoints have been promoted to stable and are marked as such to correctly reflect their status. Endpoints still marked as beta remain beta endpoints and are still subject to breaking changes. Stable endpoints are not subject to breaking changes, so code that is written to use those endpoints should not break in subsequent Looker releases. Looker recommends API 4.0 for all customers who use the API. changed Dashboard buttons linking to other Looker pages will keep the /embed prefix if the Looker page is coming from an embedded dashboard. changed The Custom buttons for dashboards Labs feature is now generally available and the Labs feature has been removed. changed The Dashboard filter location Labs feature is now generally available and the Labs feature has been removed. added External API coverage: The application timezone setting can now be set with the setting API. added The In-page Table Calculations Labs feature lets users create and edit table calculations directly in an Explore's Data section instead of using either the Create table calculation or Edit table calculation pop-up. fixed Previously, the SQL Runner query tab was not resizing correctly when other tabs were opened or closed. This issue has been resolved. fixed When LookML code is being inspected with SQL Runner or a System Activity dashboard, public Looks should now record thelook_id
with which the Looks are associated.
fixed
Previously, filters on Yes/No dimensions would incorrectly generate "Yes" and "No" SQL statements instead of "true" and "false". This issue has been fixed.
fixed
An issue with the New LookML Runtime feature has been fixed. Previously, using always_filter
on a parameter field would return an error that stated that a blank value was not allowed. Now, suggestions can properly run if full_suggestions
is turned on.
fixed
The --no-force-cdn
flag behavior has been corrected to appropriately disable the use of CDN.
fixed
Running queries should now appear near the top of the Enhanced Query Admin page.
fixed
An issue has been fixed where previously hard-deleted dashboards and Looks were not showing as "Moved to Trash."
22.16
changed If the Data Studio integration is enabled, the Link to Data Studio from Explore Labs feature lets users use the Open in Data Studio Explore gear menu option to open Explore queries that are run on supported Google database dialects in Data Studio. changed Looker is removing browser support for Internet Explorer 11. changed Chat support is available on Looker instances that are running an officially supported Looker version. Instances hosted by Looker are automatically updated to supported releases. If your Looker instance is customer-hosted and is running an unsupported Looker version, update your Looker instance to a supported Looker version to gain access to chat support. changed 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. changed Error responses from Looker API calls now include adocumentation_url
value that provides a specific link to the API error returned when an error occurs. These links now resolve to specific http error code documents, or endpoint-specific error code documents rather than the main looker documentation page.
changed
The Forecasting in visualizations feature is now generally available.
changed
Google Maps visualizations are now generally available.
changed
The new Marketplace experience is now generally available. The New Marketplace Experience toggle on the Marketplace page under the Platform section of the Admin menu has been removed.
added
The Query Performance Metrics Explore in System Activity provides detailed breakdowns of each query that is run from your Looker instance. The Performance Recommendations dashboard uses these query metrics to surface opportunities to improve performance on your Looker instance.
added
Accessible Data Table Visualizations is a new Looker Labs feature that, when enabled, causes the data table to behave slightly differently in order to be fully accessible for all viewers. Currently, this feature does not support double-clicking on table cells, which previously was used to select the text manually and unpin the row number column from the left side of the visualization.
added
Starting in Looker 22.16, Looker admins can enable the Enhanced Query Admin experimental Labs feature to enhance the Queries page. This Labs feature improves performance on the Queries page, and it lists 500 paginated queries, rather than 50.
added
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."
added
Literal aggregates are now supported for the JDBC server.
added
The format for the Format preview for custom fields option has been changed to improve readability. The value is now 1000.12 instead of 1234.56.
added
A new Labs feature, Smart Single Value Text Size, enables the fonts on single value visualizations to be resized to better fit the bounds of their containers. Single value visualization font sizes will increase and decrease to a greater extent than previously.
fixed
The New LookML Runtime feature now renders base 64 images in the HTML code of a dimension as expected, even if the block inline image Admin setting is not enabled.
fixed
Single record visualizations now render full field names and custom HTML correctly.
fixed
Dashboard elements with multiple y-axes will be displayed correctly when extended.
fixed
Dependency issues for hive2-based dialects that use Kerberos have now been fixed.
22.14
changed Sorting behavior has been changed for bin custom fields on an Explore, such that they are sorted according to the tier number instead of alphabetically on the bin column. added Stricter Liquid parsing has been added to the New LookML Compiler in order to ensure the proper syntax formatting is used. Example: use{% parameter foo %}
instead of {% parameter.foo %}
. If the incorrect syntax is used an error or warning will be thrown.
added
Persistent derived tables (PDTs) are now supported for Google BigQuery connections that use OAuth. See Enabling PDTs for Looker connections to BigQuery with OAuth for more information.
fixed
If a custom dimension produces a "Nesting too deep" error, the error will occur only if the dimension is actually selected, regardless of which LookML Runtime feature, Legacy or New, is used.
fixed
A New LookML Runtime feature bug, which caused errors with Liquid conditional statements in SQL blocks, has been fixed.
fixed
A bug in the New LookML Runtime feature, which prevented derived tables that used Liquid parameters from running, has been fixed.
fixed
A TOTP authentication edge-case issue, which was incorrectly returning a 403 error, has been fixed.
fixed
An issue has been fixed where location coordinates were unintentionally being rounded when they were used as a cross-filter using the New LookML Runtime feature.
fixed
Issues with bloated LookML dashboard compilation have been fixed.
22.12
changed Query context comments no longer include ahistory_id
value. Use history_slug
instead.
changed
To enhance rendering performance, Looker now prioritizes rendering jobs from tasks such as downloading content above rendering jobs from tasks such as delivering content.
changed
Content Validator will no longer display errors for broken dynamic fields that are not included in any dashboards or Looks.
changed
The Forecasting Labs feature now has a separate permission that lets admins control which users and groups can create or edit forecasts in visualizations.
changed
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.
added
The new WYSIWYG Text Tiles Labs feature lets users create a new kind of dashboard text tile that has a more intuitive and visual editing experience.
added
LookML dashboards with preferred viewer
set to dashboards-next
now support grid, tile and static layout types for viewing and rendering. However, tile and static dashboards cannot be converted to user-defined dashboards.
added
You can now use the _explore._dashboard_url
Liquid variable to obtain the URL for the dashboard from which an Explore or Look is running.
added
A new Marketplace experience is available and enabled by default. To switch between the new and legacy experiences, use the New Marketplace Experience toggle on the Marketplace page under the Platform section of the Admin menu.
added
The SAML response size limit is now configurable.
fixed
Column headers and pivot headers no longer inherit value formats for the dimension or measures that are listed below them in XLSX downloads.
fixed
A bin custom field type that contains the maximum specified numerical value to infinity is inclusive of the maximum specified numerical value as expected.
fixed
The Scheduler now displays the form for action destinations for saved scheduled deliveries as expected.
fixed
The Scheduler now displays the list of scheduled plans based on a user's permissions as expected.
22.10
changed The Whitelabel page and feature have been renamed to Private Label. changed The New Explore Visualizations Labs feature now applies its changes to Looks, embedded Looks, and embedded Explores, in addition to the content it already affects. changed The SAML, LDAP, and OpenID Connect features are enabled by default for instances created on or after Looker 22.10. added To address potential Content Security Policy (CSP) violations, there is a new, enhanced loading mechanism for the Looker extension framework. There is a new Enhanced Extension Loading toggle on the Platform > Extension Framework panel that Looker admins can use to disable the enhanced loading mechanism if it causes errors when existing extensions are loaded. fixed A problem was occurring where thePercent of Successful Builds
measure in the PDT Event Log Explore was showing incorrect results due to integer arithmetic. This issue has been resolved.
22.8
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 The Legacy Query Streaming legacy feature has been removed. changed A dashboard will now re-run if its query parameters are updated through a redirect from a link on a dashboard. changed The Custom buttons for dashboards Labs feature is now enabled by default. changed Theclear_cache_refresh
Labs feature has now moved to general availability.
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.
added
The Firebolt dialect now supports symmetric aggregates.
added
The Looker IDE now flags duplicate field labels in a view.
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
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 thenew_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 Amazon RDS for MySQL 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
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
PostgreSQL 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
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
Snowflake 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 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
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 toset 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.
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.