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.12

21.12 July 15, 2021
CHANGED
The error-message format has been enhanced for value_format_name and value_format parameter mismatches. Example: Invalid 'value_format'. Error: 'decimal_1' is invalid for the 'value_format' parameter. Did you mean to use the 'value_format_name' parameter?
CHANGED
In the System Activity User Explore, the Sessions view now applies a default filter to remove "ephemeral" sessions that are used for rendering. This can be overridden, if necessary, by filtering on the session.credential_type dimension.
CHANGED
SQL Runner buttons will no longer be surfaced for System Activity Explores.
CHANGED
Required filters that are type popover or advanced will now show Value required instead of Any value.
CHANGED
Users with the save_content permission now have the ability to add tiles to dashboards.
CHANGED
The New Explore Visualizations Labs feature is now the default for all instances. This feature unifies the visualizations that appear in Explores and on dashboards.
CHANGED
The Make public... keyboard shortcuts Command-Shift-P (Mac) and Ctrl+Shift+P (Windows) have been removed from Explores and Looks.
CHANGED
Fields of type YesNo will have user-written SQL wrapped in parentheses when the fields are used in a SQL filter.
CHANGED
The View Only Grid setting for visualizations is now enabled by default.
ADDED
The new Redux DevTools Labs feature enables debugging application state.
ADDED
New Quick Start queries are now available for the History and Dashboard System Activity Explores.
ADDED
The Role List measure is now available in the Role view in the System Activity model. It provides an aggregated list of the role.name field.
ADDED
Users are now able to add Looks directly to dashboards with the Add Looks to dashboards legacy feature toggle enabled.
ADDED
Two new integrations are available from the Looker Action Hub: Google Ads Customer Match and Google Analytics Data Import. See the Actions page in the Admin panel to enable these actions. These actions are available for instances on Looker 7.4 and later.
ADDED
Auto Install is a new toggle setting that has been introduced to the Marketplace settings. Auto Install allows for the auto installation of a suite of fundamental Looker-built applications (for example, API Explorer).
ADDED
The Looker extension framework is out of Labs and now generally available under the Admin > Platform settings. The extension framework is a development framework that significantly reduces the effort and complexity of building data applications with Looker.
ADDED
Users now have the ability to move content to the trash in bulk in the Unused Content page.
ADDED
A new Labs feature, Enhanced Navigation, simplifies user workflows with unified left-hand navigation and more performant routing between common pages and content.
ADDED
The Upgraded Explore Field Picker Labs feature is out of Labs and now generally available. The Legacy Explore Field Picker is available as a Legacy feature until 21.16.
ADDED
The Custom Fields Labs feature introduces new Quick Calc and Grouping functionalities.
ADDED
A new Labs feature, Improved LookML Generation, adds auto-generated measures and inline comment explanations.
ADDED
The new PDT Development Mode visibility feature enables developers to see the state of their Development Mode PDTs in the IDE and on the PDT Admin page while the user is in Development Mode.
ADDED
A new LookML parameter, fields_hidden_by_default: yes, allows users to hide all fields in a view.
ADDED
Aggregate awareness now recognizes if a dashboard filter is applied to a tile. This allows the filter's dimension to be added to the tile's aggregate table so the aggregate table can be used for the tile.
ADDED
A new LookML parameter, dev_filters, allows a user to restrict the size of the dataset in LookML for an NDT in Development Mode.
FIXED
Several issues with the new query streamer have been addressed, related to aggregations, escaping characters for JSON and Markdown formats, and conditional formatting of numeric fields.
FIXED
The dashboard_element.result_source field no longer contains incorrect conditional logic for merge queries in the System Activity Dashboard Explore.

21.10

21.10 June 10th, 2021
CHANGED
For schedules that had Include links disabled, Looker no longer sends blank emails if the Looker instance is updated to use the Send Link Only emailed data policy. Looker will now warn users who attempt to enable the Send Link Only policy that the setting may cause some schedules to not work.
CHANGED
Visual design improvements to the Upgraded Explore Field Picker Labs feature enable users to more easily differentiate views from groups, and more easily identify when fields are pivoted or filtered.
CHANGED
The incremental PDTs feature is now out of Labs and is generally available.
CHANGED
In the System Activity User Explore, the history.query_run_count measure now filters out history records where the history.status value is cache_only_miss.
CHANGED
Looker components 2.0.0 is now available. To reduce the package size of @looker/components, all the date picker and date functions are now in a new package, @looker/components-date.
ADDED
The search experience for the Upgraded Explore Field Picker Labs feature now includes support for search modifiers to narrow the scope of the field list.
ADDED
The LookML Link ID dimension is now available in the System Activity Content Usage, Dashboard, Dashboard Performance, History, Scheduled Plan, and User Explores. If a user-defined dashboard was created from a LookML dashboard, this field will contain the ID of the source LookML dashboard.
ADDED
A new CLI feature for extension development is now available as the create-looker-extension.
ADDED
The Custom Fields dimension is now available in the System Activity Dashboard, History, Look, Merge Query, and Scheduled Plan Explores. This dimension provides a JSON string of any table calculations, custom measures, or custom dimensions that are used in a query.
ADDED
Dashboards will now include more specific error messages on tiles. The error messages will provide context, links to more details, and documentation to help troubleshoot issues.
ADDED
Users can now reset all filters to their default state from the dashboard three-dot menu or by using the Command-Option-R (for Macs) or Ctrl+Alt+R (for Windows) keyboard shortcut.
ADDED
New Looker expression function case(when(), when(), else) allows for sequential conditional statements without the need to nest those statements across multiple if functions.
ADDED
Aggregate table LookML now generates dimensions from dashboard filters.
ADDED
Looker now supports the Firebolt database dialect.
ADDED
Materialized views can now be used to create persistent derived tables that leverage your database's persistence functionality. This is available for database dialects that support materialized views.
ADDED
The Looker Marketplace now supports LookML blocks that are built with refinements syntax. These refinement-style blocks will create a local project that generates a refinements.lkml file for adding refinements or additional customizations to the remotely imported CORE project that is managed by Looker. The project also generates a read-only model file that includes the refinements.lkml file and all views, Explores, and dashboards from the remote CORE project.
ADDED
A new file, marketplace_lock.lkml, maintains metadata about a Marketplace block installation's version number, models, and LookML constant values.
FIXED
You can now create data actions without defining a form parameter. These actions will show a pending, a success, and an error state.
FIXED
Look schedules that are delivered through webhook now send a Look title and link back to Looker content, as expected.
FIXED
When you're creating a one-time content delivery, the schedule's filter options will default to dashboard filters rather than to the saved schedule plan filter options, as expected.
FIXED
Schedules that contain tables with location dimensions now send as expected.
FIXED
Editing a scheduled plan will now open with the schedule's previously saved state.
FIXED
LookML that was generated for a derived table now escapes underscores in filters, as expected.
FIXED
Custom filters with type: yesno dimensions now generate correct SQL.
FIXED
The LookML validator no longer crashes when it encounters an extra closing bracket.
FIXED
The view_name parameter that is returned from the lookml_model_explore API endpoint is now the name of the base view that is used for the Explore. Previously, if the Explore name was aliased with either the from or the view_name parameter, the endpoint would return the aliased name (which was the same as the Explore name).

21.8

21.8 May 13th, 2021
CHANGED
The Looker EULA for trial instances has been updated.
CHANGED
The LookML Model Explore API endpoint now returns an original_view attribute for the fields in the Explore. The attribute value is the original view name where the field was defined.
CHANGED
The color contrast in data tables has been increased, which improves the accessibility of data tables in Explores.
CHANGED
The Clear Cache & Refresh option for embedded dashboards and tiles has been removed.
CHANGED
New query streamers are enabled by default for all non-cached streamable queries. Admin users may opt to use the old streamers by enabling the Legacy Query Streaming legacy feature.
CHANGED
On the System Activity Performance dashboard, the history source for data_download_api has changed from api to system, and the history source for authenticated_download has changed from system to action_hub.
CHANGED
Looker dialects that use the MariaDB JDBC driver will default to using enabledSslProtocolSuites=TLSv1,TLSv1.1,TLSv1.2.

The affected dialects are MySQL, MariaDB, Google Cloud MySQL, Amazon Aurora MySQL, Clustrix, MemSQL, and MongoDB Connector for BI. For these dialects, if your database does not support TLS 1.2, your database connection will break unless you explicitly set the following in the Additional Params field of your connection settings:
enabledSslProtocolSuites=TLSv1,TLSv1.1

To check if your database's SSL library supports TLS 1.2, you can run
SHOW GLOBAL VARIABLES LIKE 'tls_version';

ADDED
Looker now supports BigQuery BIGNUMERIC columns.
ADDED
The Looker mobile app now supports the same 22 languages that the Looker web app supports.
ADDED
Admins can update settings to enforce user authentication every time a user opens the Looker mobile app. Users will also have the option to set up biometric logins.
ADDED
The SQL Text field is now available in the System Activity History Explore.
ADDED
The following improvements have been made to the System Activity Content Usage Explore: 8 Quick Start queries have been added as starting points for analysis; the required filter for including or not including deleted Looks or dashboards has been added; additional context has been added to existing descriptions of 14 fields; 7 unused or discontinued fields have been hidden; and common fields under group labels have been nested.
ADDED
Search Service is a new beta Labs feature that improves the experience and results when users search for content within Looker. The Search Service Labs feature is available only on instances hosted on Kubernetes.
ADDED
Drill links in new dashboards now open in a new tab if you click the links in combination with the Control or Command keys.
ADDED
Filters of type date_hour, date_minute, and date_second will now show a time drop-down next to fields of type date, when applicable.
ADDED
New Explore Visualizations is a beta Labs feature that creates parity between the visualizations shown on a new dashboard and Explores.
ADDED
Introducing new embed Save events when a look is edited, saved or deleted. Developers can leverage these events to take action in the parent pages of their applications.
ADDED
The application parameter now includes an sri_hash subparameter, which lets you specify a Subresource Integrity (SRI) hash, and a new use_clipboard entitlement, which specifies whether an extension is allowed to write to the system clipboard.
ADDED
API Explorer is a new beta Labs feature that provides a new and integrated experience for exploring the various API methods and types on the Looker platform.
ADDED
UI-based filtered measures have been added to the existing Custom Fields experimental Labs feature.
ADDED
The rootUrl JDBC parameter can now be used to customize the destination of BigQuery API requests.
ADDED
An admin user can now alter the IP address for BigQuery connections in the Additional Params options of the database connection settings.
FIXED
The LookML Validator now validates custom fields for LookML dashboards.
FIXED
LookML dashboards with non-ASCII characters in their titles can be scheduled, rendered, or downloaded as expected.
FIXED
Schedules saved for a single day per week no longer result in an error.
FIXED
Schedules with the Visualization format no longer check for explore permission.
FIXED
Schedules with Send if there are results selected will correctly check for results, even if table calculations and pivots are both used.
FIXED
Downloads with Results In Table selected now correctly download only selected rows, even if the row limit is blank.
FIXED
Dashboards can now be scheduled to send based on datagroup update, as expected.
FIXED
The scheduled_plan.updated_at field now has a datatype of TIMESTAMP instead of INT64.
FIXED
Advanced filter tier controls now work with parameter fields that contain underscores.

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 Labs feature is enabled, the PDT Details pop-up in the Persistent derived tables admin page now has an Increment Build Added/Removed Rows field, which shows the number of rows that were added or removed in the table's last increment.
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 discontinued 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