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 21 changelog

21.6

21.6 April 15th, 2021
CHANGED
The metadata panel of the Looker IDE is now out of Labs and is generally available.
CHANGED
The Trend Lines in Visualizations Labs feature is now out of Labs and is generally available.
CHANGED
The Looker extension framework can be used to create iframes if use_iframes entitlement is added to the extension. Extensions that have the use_embeds entitlement are automatically granted the use_iframes entitlement.
CHANGED
All Looker custom visualizations now use a sandboxed iframe to promote security. Unsandboxed custom visualizations are no longer supported in Looker.
CHANGED
Adding an external email address to scheduled content no longer automatically switches off the Run schedule as recipient toggle. Instead, an error will be displayed stating that you cannot save an external recipient with that option enabled.
CHANGED
A syntax warning is returned if the keyword bigquery_datetime_as_timestamp is included in a model.
CHANGED
The render_tasks API endpoint no longer supports the combination of result_format and dashboard_style and will return an error: 422, unprocessable entity.
CHANGED
Instead of returning a generic 404 error, the API now returns the error Problems parsing JSON for invalid JSON set in a user attribute.
CHANGED
Users can override the Looker default values for the Snowflake connection properties by setting the following parameters in the JDBC Additional Params field of a connection: TIMESTAMP_TYPE_MAPPING=TIMESTAMP_LTZ, JDBC_TREAT_DECIMAL_AS_INT=FALSE, TIMESTAMP_INPUT_FORMAT=AUTO, and AUTOCOMMIT=true.
CHANGED
When the Segment Group action is used, Looker's payload will no longer include a segment_anonymous_id and will only send the segment_group_id when the segment_group_id LookML tag is present.
CHANGED
In the Connections drop-down, users can no longer see connections that they do not have SQL Runner access to.
CHANGED
The Looker Dialect BlinkDB has been deprecated and is no longer available.
CHANGED
Looker no longer supports the IBM DB2 Warehouse on Cloud (dashDB) dialect. Instead, for DB2 databases, you can use IBM DB2 on AS400 or IBM DB2 for Linux, UNIX, and Windows (LUW).
ADDED
A user can now create a new board, add a board to, or remove a board from their favorites directly in the All Boards modal view.
ADDED
Users can now navigate to LookML objects using the Looker IDE Jump to object or file icon or the keyboard shortcut Command-J (Mac) or Ctrl+J (Windows).
ADDED
Users now have the ability to copy File or Folder Path settings in the IDE on file and folder items found in the overflow (three-dot) menu.
ADDED
Columns in the data table in Explore queries now show helpful hints when users add multiple sort orders. This allows users to see the order in which sort orders are executed as well as any limitations that may be present.
ADDED
Custom fields and table calculations now support descriptions.
ADDED
The search experience for the Upgraded Explore Field Picker Labs feature has been improved.
ADDED
Starting in Looker 21.6, Looker is launching a new Liquid parser. Because this parser introduces new checks for valid Liquid syntax, you may see new validation messages for existing Liquid syntax after you update to 21.6. The new legacy feature Syntax Tolerant Liquid, which is enabled by default, ensures that all errors are categorized as informational.
ADDED
Using make _filters[] Liquid referencing a string type filter with no sql_quote in derived table SQL will now warn the user to use sql_quote.
ADDED
A new JDBC parameter, rootUrl, can be used to customize the destination of BigQuery API requests.
ADDED
A new beta API endpoint, create_oauth_application_user_state, and a new stable endpoint, create_embed_user endpoint, have been introduced for OAuth authentication.
ADDED
If the Incremental PDTs (beta) Labs feature is enabled, the number of new rows added in the last increment is listed in the Incremental Build Added Rows field.
ADDED
The New Users Page (beta) Labs feature allows users to see a redesigned, user-friendly, and more performant user list page.
ADDED
The Embedded Content Navigation feature has been re-added to the new dashboard experience. For this feature to be enabled for a user, the user must be given the embed_browse_spaces permission.
ADDED
Four new embed JavaScript message events are available for embedded dashboards and Looks: dashboard:save:complete, dashboard:delete:complete, look:save:complete, and look:delete:complete.
ADDED
Two new entitlements have been added for extensions that are built using the Looker extension framework: use_downloads, which specifies whether an extension is allowed to download files, and use_iframes, which specifies whether the extension is allowed to create an iframe.
ADDED
Added support for the Databricks dialect.
FIXED
Users can schedule dashboards and send to integrations only if granted permissions to see dashboards as well as the send_to_integration permission, as expected.
FIXED
New Looker instances will use /browse as the default homepage.
FIXED
Users can create scheduled plans to enabled Looker Action Hub destinations from a folder, as expected.
FIXED
Improvements have been made to value formatters.

21.4

21.4 March 11th, 2021
CHANGED
In the case where two views are joined in a one_to_many join, if a view references a measure such as COUNT, SUM, or AVG from another view that doesn't have a primary key, Looker will now show a LookML model error: Field '(?)' depends on '(?)' which cannot be calculated because of a one_to_many or many_to_many join. Consider adding a primary key to '(?)'
CHANGED
The DataTable Looker component has been updated to be more accessible for screen readers, with better labeling on columns, rows, and cells.
CHANGED
The List component is now enriched with additional features. Additionally, there are two new components for lists: OrderedList and UnorderedList.
CHANGED
Look and dashboard view counts are now updated asynchronously; therefore, data changes may not be reflected immediately.
CHANGED
The LookML IDE renders the following new warning if the dashboard file declaration is invalid: Invalid dashboard declaration. Dashboard must be declared as: <dashboard_name>.
CHANGED
Errors in a project manifest file will surface correctly even if there are no models in the LookML project.
CHANGED
Admins can configure user attributes referenced by access filters so that these filters are dropped from the WHERE clause in Looker-generated SQL. The admin can set advanced type user attributes to %,NULL (for String Filter [advanced]) or <0,>=0,NULL (for Number Filter [advanced]). If the user attributes have these settings, Looker will drop these filters from the WHERE clause. This behavior was previously supported only for LookML projects with aggregate awareness (projects with an aggregate table defined), but is now the behavior for all Looker projects with these user attribute settings.
CHANGED
The --scheduler-threads=<i> startup flag can no longer be used to determine alert runs or to disable alerts. For these tasks, use the --alerts-scheduler-threads=<i> flag.
CHANGED
The create_query API endpoint now accepts filter values of only type: string.
CHANGED
The bigquery_datetime_as_timestamp legacy feature has been removed. Any field with datatype: datetime declared on a model using a BigQuery standard SQL connection will now be treated as a BigQuery datetime type field.
CHANGED
Looker Dialect Vertica 6 has been deprecated. Vertica remains a fully supported Looker dialect.
CHANGED
Users using Exasol, Hana, or Vertica dialects may see an error message alerting them to potentially malicious SQL execution in their PDTs. The error message offers a workaround if the SQL is safe.
CHANGED
Because of several Slack API endpoint deprecations, users must upgrade to Lookerbot version 0.0.16 or higher for Lookerbot to function properly.
CHANGED
The inline JSON format for actions has been updated to create consistency among action formats. Going forward, the query for the payload data will be returned in the attachment field instead of the data field, which will now contain any authentication token information.
ADDED
The Looker mobile app is now available for download on the Google Play Store (new iOS version is coming soon). The GA version is v1.1.0 and includes a new and improved dashboard experience. All instances will have mobile access enabled by default. Admins can manage access to the Looker Mobile app from the Mobile Application Access section of the Settings page in the Looker Admin panel.
ADDED
While in edit mode on dashboards, users now have the ability to discard their changes using the Cancel button.
ADDED
Dashboard themes with a dark background color have been significantly improved for embedded customers. Filters now use background and text colors, while filter labels, visualization labels, and icons use text color.
ADDED
Dashboards that include a tile based on a System Activity Explore can now use the fields from the Explore to create dashboard filters. System Activity filters cannot be added to legacy dashboards.
ADDED
The metadata panel of the Looker IDE, which is enabled by the IDE Metadata Sidebar Labs feature, now shows primary key information in view metadata. In addition, the metadata panel includes metatdata for imported projects.
ADDED
The LookML Model Diagram (beta) extension, which provides an entity relationship diagram for the objects within a LookML model, is now available in the Looker Marketplace. This extension lets users quickly assess a LookML model's state and make informed decisions about future developments.
ADDED
Cross-filtering now supports range selection on visualizations.
ADDED
For LookML projects automatically generated from a BigQuery database, Looker will autopopulate the LookML field description values with the descriptions from the BigQuery column metadata, if any.
ADDED
For projects using a BigQuery connection with aggregate awareness, if a query can use an aggregate table, the Explore window displays the estimated cost savings of using the aggregate table instead of the original table.
ADDED
Fetch Information Schema for SQL Writing is now a toggle option for database connections. This option enables SQL writing optimization when the schema is not cached; however, this will require that SQL writing be occasionally blocked while the information schema is fetched from the databases.
ADDED
The Fast Value Formatting Labs feature is now out of Labs and is generally available. The new value formatter is more performant and has the same support as the legacy value formatter, including support for ECMA-376 format codes.
ADDED
Users should now see significant performance improvements to the PDT Admin page.
ADDED
A new beta Labs feature, Incremental PDTs, enables Looker to append fresh data to a PDT instead of rebuilding the entire table.
ADDED
The PDT Activity dashboard has been added to the System Activity model and is now accessible from the Persistent Derived Tables page under Admin.
ADDED
A new validator warning occurs when a column that has not been explicitly added to an NDT definition is used in the sorts:[] parameter.
ADDED
The Tree component now supports the keyColor property, which imbues the Tree and any nested Trees or TreeItems with backgrounds that leverage the key color specified in the theme.
ADDED
A new experimental Labs toggle option, Render Long Tables, can be enabled to reduce the PDF or PNG rendering time for long tables.
ADDED
The following four new endpoints have been added to the experimental API v4.0 and can be used to move or copy an existing dashboard or Look to any specified folder: move_dashboard(dashboard_id, body, folder_id), copy_dashboard(dashboard_id, body, folder_id), move_look(look_id, body, folder_id), and copy_look(look_id, body, folder_id).
ADDED
A new API 4.0 beta endpoint, api_spec, can be used to retrieve a Looker API specification from the Looker server.
ADDED
The new embed_save_shared_space permission allows an embed user to save to the Shared folder without being assigned to an external group ID, provided the user has the save_content permission.
ADDED
SAP HANA version 2 and Apache Spark 3+ are now supported Looker dialects.
ADDED
Vertica dialect now supports percentile, a LookML measure type.
ADDED
Japanese characters can now be entered into the Looker Data Dictionary extension context data.
ADDED
Now available in the Looker Marketplace, Force-Directed Graph is a new custom visualization that you can use to show relationships among entities in your data.
ADDED
Gerrit is now a supported Git repository.
ADDED
Microsoft Azure is now available as a hosting envrionment for Looker-hosted instances. Instances are currently hosted in the Virginia, USA region.
FIXED
Targets of the link parameter that use an absolute link will now open in a new browser tab as expected.
FIXED
Users can create dashboard filters that filter twice on the same field, as long as each filter is applied to different dashboard tiles.
FIXED
A filter on a yes (or) no field no longer blocks aggregate awareness optimization from doing a UNION ALL rewrite unless the yes (or) no field is also in the query.
FIXED
An aggregate table can be used as expected even if its time filter is a superset of the query and the time dimension is more granular than that of the query.
FIXED
Aggregate awareness used with filter values of NULL and not NULL works as expected.
FIXED
Visual drilling defined in the LookML is now supported on dashboards that use the new dashboard experience.
FIXED
Customers with access to the System Activity Explores can now add filters on those fields as expected when creating dashboards.
FIXED
Schedules with datagroup triggers no longer return a 422 error. Users can now create a schedule with a datagroup trigger from dashboards that use the new dashboard experience as expected.
FIXED
Users can now select a TLS version on the Custom SMTP settings page as expected.
FIXED
Removing localization_settings from a manifest.lkml file will no longer cause errors or warnings generated by localization to disappear on subsequent LookML validations.
FIXED
Embed SSO URL validation errors will now appear within the validation area on the Admin Embed page as expected.
FIXED
One-time SFTP deliveries can be created, modified, and saved as expected.
FIXED
Creating a new branch with spaces in the branch name will no longer render an error but will instead automatically replace the spaces with hyphens.

21.0

21.0 January 20th, 2021
CHANGED
The Year to Date control option on the timeframes filter, used to filter from the beginning of the year to the current date, has been temporarily removed.
CHANGED
The Overflow option in the Location drop-down has been removed from the Edit Filter pop-up. Filters can be moved into overflow by dragging and dropping.
CHANGED
Some filter control types now have only one possible display orientation. For filters that have multiple display options, you can still switch between Popover and Inline. Other filter control types may be available for only one of those options. Any existing filters that had a display orientation that is no longer supported will now show the current default display orientation for that type of filter control. All filter control types can still be dragged into the More button.
CHANGED
The cross-filtering feature is now generally available without having to enable a Labs feature. Cross-filtering must be enabled on each dashboard.
CHANGED
SQL Runner queries can no longer be merged to Explore queries and saved to dashboards.
CHANGED
When you launch a Quick Start analysis, the visualization pane will automatically be opened. Quick Start analyses now respect applied sorting.
CHANGED
When you clear fields from an Explore query, custom fields will be deselected instead of removed.
CHANGED
On the In Use tab of an Explore, users can now switch the timeframe of a selected date or duration field without going into the full field list.
CHANGED
The upgraded Explore field picker defaults to the All Fields tab instead of the In Use tab when an existing query is open.
CHANGED
If the New Query Streaming experimental Labs feature is enabled and the query is streamable, the scheduler will use the new query streaming feature.
CHANGED
The Download Termination Error Handling feature has been removed from Labs. It is now configurable through an experimental feature CLI flag, download-termination-error-handling.
CHANGED
A custom visualization that uses JavaScript no longer requires third-party cookies to be enabled for it to load.
CHANGED
The Looker Data Dictionary field profiler now checks whether Count measures belong to the same view name, rather than view label, as the selected numeric dimension to display Distribution and Values calculations.
CHANGED
The ability to join to the sessions table has been removed from drill queries on tiles in the User Activity dashboard under the System Activity section of the Admin panel.
CHANGED
Extension code can be split into multiple bundles for faster load time.
CHANGED
As with previous versions of Looker, when the last remaining recipient of a scheduled content delivery unsubscribes, the schedule is deleted. In Looker 21.0, that user will now see the following confirmation message when attempting to unsubscribe: You're the only recipient for this schedule. If you unsubscribe from this delivery, the schedule will be deleted. Are you sure you want to unsubscribe?
CHANGED
To generate LookML that better handles nested records, improvements have been made to the LookML generator and Create View from Table page.
CHANGED
The api_server_url has been added to the /versions endpoints for the Looker API server. The https://my.looker.com/versions endpoint no longer requires authentication.
CHANGED
Looker's managed database service feature is disabled for all Looker versions on 21.0 and higher. To have the feature enabled, contact your Looker representative. The service will be deprecated entirely in Looker 21.12 (July 2021).
CHANGED
Support for JDK 11 has been temporarily suspended.
ADDED
A new visualization type, Histogram Visualization, is now available from the Looker Marketplace.
ADDED
Users can now create a custom measure from a custom dimension in the field picker.
ADDED
Cross-filtering is now supported on the Funnel Chart and Timeline Chart visualization types and for custom visualizations.
ADDED
Fast Value Formatting is a new beta Labs feature that significantly improves value formatting performance.
ADDED
Subheaders identifying the type and name of an object are now populated in the metadata panel, which is enabled by the IDE Metadata Sidebar Labs feature. If the object selected is a view, then the metadata panel populates the Base View of and Joined in sections, which provide context for how the view is used in your project.
ADDED
Since is a new status under the Regenerating and Building sections of the Persistent Derived Tables under Admin to show additional information on when the build started.
ADDED
Embedded images (base64-encoded) can be viewed in query results if the Block Inline Embedded Images in Query Results admin setting is disabled.
ADDED
Alerts can now be set to check for alert conditions more frequently and include an option to specify an interval during which alert checks will occur.
ADDED
The role, model set, and permission set listing page is now paginated and searchable.
ADDED
Admins for instances with whitelabeling enabled can now access product messaging.
ADDED
Users can now view and adjust time zones within dashboards using the new dashboard experience, as long as User Specific Time Zones is enabled.
ADDED
Users can now add and save comments on individual fields in the Data Dictionary extension. These comments live only in the Data Dictionary UI and are not propagated to the associated LookML model. Looker admins can assign users permissions to view or make comments; or they can toggle comments off entirely. To implement comments, update the Looker Data Dictionary app to version 2.0.0 or later from the Manage page in the Looker Marketplace.
ADDED
Users now have the ability to specify the target Git branch where Looker developer branches will be merged. Use the Git production branch name field in the Project Settings. The default Git production branch is master.
ADDED
Amazon Redshift is now a supported SQL Dialect for distinct counts with aggregate awareness.
ADDED
Dremio 11+ is now a supported Looker dialect and includes support for symmetric aggregates.
ADDED
Dialects Cloudera Impala 3.1+ and Cloudera Impala with Native Diver 3.1+ now support symmetric aggregates.
ADDED
In the experimental Looker API (v4), the all_users endpoint can optionally request user count.
ADDED
The /api/3.x/derived_table/graph/model/:model endpoint has been made publicly available to visualize PDT dependency graphs for troubleshooting PDT errors.
ADDED
A new measure, Dashboards Run Count, has been added to the System Activity history view.
ADDED
The Google Chronicle Security Block, for analysis of Chronicle datasets in Google BigQuery, is now available from the Looker Marketplace.
FIXED
The upgraded Explore field picker result set no longer displays erratic scrolling and now has improved accessibility support.
FIXED
The list of available options for the values of parameters now renders as expected.
FIXED
Visualizations no longer have issues with y-axis labels and tick mark values overlapping.
FIXED
Resizing columns on transposed tables works as expected.
FIXED
Sorting in the upgraded field picker is based on the group_item_label, as expected.
FIXED
The table header shows up as expected when a table calculation is added to a table before any dimensions or measures.
FIXED
SSO Embed users will no longer be shown a logout pop-up.
FIXED
Embedded dashboards that use the new dashboard experience no longer generate spurious page:changed and dashboard:filters:changed messages.
FIXED
Performance improvements on the Admin > Connections and Admin > Groups pages result in faster page loads.
FIXED
Users no longer require explore permissions to download drill data in PNG format.
FIXED
System activity is now returned with all_lookml_models(), including lookml_model(system__activity), if the user has see_system_activity permissions.
FIXED
Downloads to the XLSX format using the New Query Streaming feature work as expected for queries with value formatting and measures.
FIXED
Links using Liquid variables work as expected.
FIXED
When Looker's Slack integration is enabled, the /looker select command is included as expected in the list of supported commands shown when you type the /looker help command into Slack.
FIXED
Time series alerts will fire as expected if values in any pivoted column meet or exceed the alert conditions.
Top