## 21.20

Changed The **Use old dashboards routes** [legacy feature](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt) now defaults to off.

<br />

Changed After [saving an Explore to a dashboard](https://docs.cloud.google.com/looker/docs/creating-user-defined-dashboards.md.txt#adding_query_tiles_from_an_explore), users who click the dashboard link from the confirmation banner will enter the dashboard in [edit mode](https://docs.cloud.google.com/looker/docs/editing-user-defined-dashboards.md.txt#entering_edit_mode_in_dashboards).

<br />

Changed When a user attempts to navigate away from a dashboard that has unsaved changes, the user will [now see a **Discard changes?** warning dialog](https://docs.cloud.google.com/looker/docs/editing-user-defined-dashboards.md.txt#entering_edit_mode_in_dashboards).

<br />

Changed A new legacy feature, **Use old navigation and legacy routing** , allows you to disable enhanced navigation, which is now the default navigation experience. The **Use old navigation and legacy routing** [legacy feature](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt#legacy_feature_schedule) will be removed starting in Looker 22.2.

<br />

Changed The default [alerts](https://docs.cloud.google.com/looker/docs/alerts-overview.md.txt) experience now includes all the features and capabilities of enhanced alerts without the need to enable a [Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs).

<br />

Changed In order to address a vulnerability, Looker no longer recognizes self-closing XHTML tags in custom visualizations. Enabling a new legacy feature, **Allow XHTML-style Empty Tags in Custom Visualizations** , causes self-closing XHTML tags to be recognized in custom visualizations, but also exposes the vulnerability. For more information, see the [Allowing XHTML-style empty tags in custom visualizations](https://docs.cloud.google.com/looker/docs/best-practices/how-to-use-allow-xhtml-style-empty-tags-in-custom-visualizations-legacy-feature.md.txt) Best Practices page.

<br />

Added Looker has improved **Dark Mode** visualization styling for [single value](https://docs.cloud.google.com/looker/docs/single-value-options.md.txt), Cartesian, [pie](https://docs.cloud.google.com/looker/docs/pie-options.md.txt), and [donut multiples](https://docs.cloud.google.com/looker/docs/donut-multiples-options.md.txt) charts.

<br />

Added A new [details panel](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt#dashboard_details) is available for dashboards, including a new area where you can add a description for the dashboard. Metadata that shows the user who created and updated the dashboard, along with the number of favorites and views, also appears.

<br />

Added The new **Guided analyses in System Activity** [Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#guided_analyses_in_system_activity) provides the option to leverage a question-and-answer format for [performing analyses](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#guided_analysis) in the **History** System Activity Explore.

<br />

Added The **Dashboard** System Activity Explore now includes the `preferred_viewer` parameter and also mitigates an issue where the `is_legacy` field was not accounting for nulls.

<br />

Added Looker now supports the [`approximate`](https://docs.cloud.google.com/looker/docs/reference/param-field-approximate.md.txt) parameter for the Google BigQuery Standard SQL dialect.

<br />

Added The **LookML New Runtime (Aragonite)** Labs toggle enables the option to use Aragonite on the Looker instance. When this Labs feature is enabled (the default), LookML developers can turn on Aragonite for individual LookML projects on the instance by adding the `aragonite: yes` statement to a project's manifest file.

<br />

Added A new error message warns users when they attempt to use Liquid templates in the `value_format` parameter.

<br />

Added The **Dashboard Details** description in the new [Dashboard Details panel](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt#dashboard_details) uses the same API as previous descriptions.

<br />

Added Looker dialect MySQL 8.0.12+ now supports [incremental PDTs](https://docs.cloud.google.com/looker/docs/incremental-pdts.md.txt).

<br />

Added A new endpoint to the Looker SDK lets users request a dependency graph for a PDT.

<br />

Added Looker has introduced a new LookML parameter, `interval_trigger`. The `interval_trigger` parameter specifies an interval at which a derived table is triggered for rebuild. `interval_trigger` can be a subparameter of [`datagroup`](https://docs.cloud.google.com/looker/docs/reference/param-model-datagroup.md.txt#interval_trigger) or [`derived_table`](https://docs.cloud.google.com/looker/docs/reference/param-view-interval-trigger.md.txt), and it accepts an interval string that indicates a number of seconds, minutes, or hours (such as `"24 hours"`).

<br />

Added The [PDT details modal](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt#pdt_details_modal) now includes a **Show Dependency Graph** button that displays a relationship diagram with the names and statuses of any [cascading derived tables](https://docs.cloud.google.com/looker/docs/derived-tables.md.txt#cascading_derived_tables) that the PDT depends on.

<br />

Fixed In a [nested menu](https://looker-open-source.github.io/components/latest/?path=/docs/docs-menu--docs), the parent menu item now remains highlighted.

<br />

Fixed Clicking a [menu item](https://looker-open-source.github.io/components/latest/?path=/docs/docs-menu--docs) with a nested menu will not close both menus.

<br />

Fixed An issue has been fixed where previously LDAP groups that were prefixed with `#` were causing errors.

<br />

Fixed An error message in beta users pages that stated `"user never logged in"` for users who had logged in via SAML has been fixed.

<br />

Fixed Performance issues with the group selector on the user edit pages have been fixed. This required a slight change to the design, but the overall UX is the same.

<br />

Fixed Looker now accepts any valid certificate trust path when verifying SSL/TLS certificates, rather than failing if there is an invalid and valid path in the same chain presented from the server.

<br />

Fixed Erroneous dates, such as `January 1900`, no longer appear in query results when a user downloads results in CSV format.

<br />

Fixed The `run_query` API endpoint now renders an empty result set instead of returning an error stating that `"The response body could not be parsed"`.

<br />

Fixed Using the parameter `value_format_name` now rounds to the specified floating point precision.

<br />

Fixed Downloading results in XLSX format no longer renders numbers using exponential notation.

<br />

Fixed An issue has been fixed that caused certain System Activity queries from the **History** Explore to return a primary key error.

<br />

Fixed An issue has been fixed that allowed the `system_activity` model to be selected while model sets were being edited.

<br />

## 21.18

Changed **Deleted Date** has been changed to **Moved to Trash Date** in the Look and Dashboard usage views of the System Activity Content Usage Explores to differentiate between soft deletion (trash) and hard deletion (absolute).

<br />

Changed The **Revert to Legacy Dashboards** [legacy feature](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt#enabling_and_disabling_legacy_features) has been [extended](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt#legacy_feature_schedule) until Looker 22.0.

<br />

Changed For Looker connections to [Microsoft SQL Server (MSSQL)](https://docs.cloud.google.com/looker/docs/db-config-microsoft-sql-server.md.txt), [Microsoft Azure Synapse Analytics](https://docs.cloud.google.com/looker/docs/db-config-microsoft-azure-synapse-analytics.md.txt), and [Microsoft Azure SQL Database](https://docs.cloud.google.com/looker/docs/db-config-microsoft-azure-sql-database.md.txt), if you need to specify a non-default port other than 1433 and your database requires using a comma instead of a colon, you can add `useCommaHostPortSeparator=true` in the [**Additional Params**](https://docs.cloud.google.com/looker/docs/connecting-to-your-db.md.txt#additional_params) field of Looker's **Connection Settings** page. This allows you to specify a non-default port other than 1433 in the [**Remote Host:Port** field](https://docs.cloud.google.com/looker/docs/connecting-to-your-db.md.txt#remote_host:port).

<br />

Changed The border color for the [`Button`](https://looker-open-source.github.io/components/latest/components/actions/button) component has been updated to improve contrast.

<br />

Changed The border color for input [components](https://looker-open-source.github.io/components/latest/components/) has been updated to improve contrast.

<br />

Added The following Looker Marketplace Blocks have been converted to a new structure that utilizes [LookML refinements](https://docs.cloud.google.com/looker/docs/lookml-refinements.md.txt) rather than [extends](https://docs.cloud.google.com/looker/docs/reusing-code-with-extends.md.txt) and are available for instances on Looker 21.8 or later: Retail Analytics, Google Ads Transfer, Jira, Shopify, Amazon Redshift Admin, Hubspot Marketing, Zendesk, Braintree Payments, Community Mobility, Campaign Manager 360, GitHub, Google Analytics 360, Search Ads 360, Chronicle, Google Cloud Audit Logs, Census Data, and BigQuery Info Schema. If your Looker instance has a version of one of these block installed that uses extends and you would like to install the version of the block that uses refinements, you can follow these instructions to [migrate any customizations](https://docs.cloud.google.com/looker/docs/marketplace-customize-blocks.md.txt) your extends-based block may have.

<br />

Added Looker now prevents schedules from re-running indefinitely if a schedule job is interrupted. Looker will attempt to re-run the job up to 10 times.

<br />

Added A new Labs feature, **URL Links in Boards** , allows editors of boards to [add links to any URL](https://docs.cloud.google.com/looker/docs/presenting-content.md.txt#adding_links_to_a_board) on a board alongside their existing Looks and dashboards.

<br />

Added Users can now group alerts by alert owner or dashboard name on the [**Manage Alerts** user page](https://docs.cloud.google.com/looker/docs/user-alerts.md.txt#grouping_alerts) and the [**Alerts** admin page](https://docs.cloud.google.com/looker/docs/admin-panel-alerts-and-schedules-alerts.md.txt#grouping_alerts).

<br />

Added Looker instances created with Looker 21.18 and later have the [`see_pdts`](https://docs.cloud.google.com/looker/docs/admin-panel-users-roles.md.txt#see_pdts) permission added to the **Developer** [default permission set](https://docs.cloud.google.com/looker/docs/admin-panel-users-roles.md.txt#default_permission_sets).

<br />

Added The option to **Convert Project to New LookML** has been re-introduced to the LookML IDE to allow users to [convert their YAML LookML to LookML](https://docs.cloud.google.com/looker/docs/best-practices/how-to-convert-yaml-to-new-lookml.md.txt).

<br />

Added Dremio and Dremio 11+ now support timezone conversions.

<br />

Added Firebolt now supports in-database pivoting.

<br />

Added Google ripple animation has been added to the `IconButton`, `Checkbox`, `Radio`, and `ToggleSwitch` components. The ripple is not visible when content is embedded.

<br />

Added Within a Looker instance, [private embeds](https://docs.cloud.google.com/looker/docs/private-embedding.md.txt) can now use the [Google OAuth](https://docs.cloud.google.com/looker/docs/admin-panel-authentication-google.md.txt) and [OpenID Connect](https://docs.cloud.google.com/looker/docs/admin-panel-authentication-openid-connect.md.txt) authentication flows to authenticate a user.

<br />

Fixed A bug has been resolved where incremental PDTs with a `timezone` parameter would previousy generate timezone conversion incorrectly in the `WHERE` clause of an incremental PDT update.

<br />

Fixed A bug has been resolved that previously caused text within a ` <link> ` tag in inline documentation to not be formatted with blue text.

<br />

Fixed A bug has been resolved that previously caused the swatch in an [`InputColor`](https://looker-open-source.github.io/components/latest/components/forms/input-color) component to be incorrect when the field was disabled.

<br />

Fixed A bug has been resolved for the Labs beta feature **LookML Dashboard Organization** that would cause LookML dashboards to not show up in the LookML dashboards folder if a customer had previously deleted LookML projects that contained LookML folders.

<br />

## 21.16

Changed The [**Enhanced Navigation**](https://docs.cloud.google.com/looker/docs/navigating-looker.md.txt) Labs feature is now on by default for all customer instances.

<br />

Changed The [**Custom Fields**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#custom_fields) Labs feature has moved from experimental to beta.

<br />

Changed When formatting is enabled for query downloads, JSON numeric values must be enclosed in quotes.

<br />

Changed For PDTs that are persisted as [materialized views](https://docs.cloud.google.com/looker/docs/reference/param-view-materialized-view.md.txt) on your database, the [**PDT Admin**](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt) page displays "Materialized View" under the PDT name in the PDT table, and displays "Materialized View" as the [persistence rule](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt#persistence_rule) in the PDT table and the [**PDT Details** modal](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt#pdt_details_modal).

<br />

Changed The legacy field picker toggle has been removed.

<br />

Changed A non-admin user can now be granted the [`see_alerts`](https://docs.cloud.google.com/looker/docs/admin-panel-users-roles.md.txt#see_alerts) permission, which enables access to the [**Alerts** management page](https://docs.cloud.google.com/looker/docs/admin-panel-alerts-and-schedules-alerts.md.txt) and the [**Alert History** page](https://docs.cloud.google.com/looker/docs/admin-panel-alerts-and-schedules-alert-history.md.txt) in the **Admin** section of Looker. From the **Alerts** management page, they can view, follow, edit, self-assign, or delete any alert on the Looker instance.

<br />

Changed Display-name-related attributes for alert owners and followers have been re-added to the public alert API.

<br />

Added When enabled, a new experimental Labs toggle option, [**LookML Dashboard Organization**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#lookml_dashboard_organization), lets users organize LookML dashboards into other folders besides the default folder, **LookML dashboards** .

<br />

Added The [**Enhanced Navigation**](https://docs.cloud.google.com/looker/docs/navigating-looker.md.txt) Labs feature allows [folders](https://docs.cloud.google.com/looker/docs/navigating-looker.md.txt#folders) to be expanded in the [new enhanced left navigation panel](https://docs.cloud.google.com/looker/docs/navigating-looker.md.txt#new_enhanced_navigation_changes). When the feature is enabled, the [**Admin**](https://docs.cloud.google.com/looker/docs/navigating-looker.md.txt#for_admins:_accessing_the_admin_panel) menu is now an option in the left navigation panel instead of in the gear menu on the top navigation bar.

<br />

Added The [stepped funnel visualization option](https://docs.cloud.google.com/looker/docs/funnel-options.md.txt#stepped_funnel) has been re-introduced in new dashboards.

<br />

Added New [dashboard settings](https://docs.cloud.google.com/looker/docs/editing-user-defined-dashboards.md.txt#default_filters_view), **Expanded** and **Collapsed** , now let you choose the default appearance for dashboard filters.

<br />

Added Users can now can copy a dashboard from within the dashboard itself using the [dashboard's three-dot menu](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt#copying_dashboards).

<br />

Added [Cross-filtering](https://docs.cloud.google.com/looker/docs/cross-filtering-dashboards.md.txt) is now available for touchscreen devices. When cross-filtering is enabled for a dashboard, the **touch and hold** behavior will apply the filter.

<br />

Added [**Always Retry Failed PDT Builds**](https://docs.cloud.google.com/looker/docs/connecting-to-your-db.md.txt#always_retry_failed_pdt_builds) is a new checkbox in Looker's [connection settings](https://docs.cloud.google.com/looker/docs/connecting-to-your-db.md.txt). When the **Always Retry Failed PDT Builds** setting is enabled, the [Looker regenerator](https://docs.cloud.google.com/looker/docs/derived-tables.md.txt#the_looker_regenerator) will attempt to rebuild [trigger-persisted tables](https://docs.cloud.google.com/looker/docs/glossary.md.txt#trigger-persisted-table) that failed in the previous regenerator cycle, even if a PDT's trigger value has not changed since the previous trigger check. **Always Retry Failed PDT Builds** is disabled by default.

<br />

Added **Embed Users** credentials (for embed roles) and **Looker Support** credentials (for support roles) are now classified and displayed accordingly in the [**Edit Group**](https://docs.cloud.google.com/looker/docs/admin-panel-users-groups.md.txt#editing_groups) page.

<br />

Added [Legacy dashboards scheduled for delivery from within a folder](https://docs.cloud.google.com/looker/docs/delivering-legacy-dashboards#opening_the_scheduler_from_a_folder) will now use the same interface as new dashboards and alerts. The changes to the folders UI are cosmetic only; functionality is unchanged.

<br />

Fixed The 12:00:00 PM timestamps now display as expected for XLSX downloads that use the new query streamers.

<br />

Fixed Streamed queries no longer return a totals row if there are no results.

<br />

Fixed Sorting the pivot keys of `type:long` using new query streamers now works as expected.

<br />

Fixed Users can now see better performant filter suggestions when creating a new filter.

<br />

Fixed The EULA statement is now readable on all instances as expected.

<br />

Fixed The `Never logged in` label is now added correctly to SAML logins if the **New Users Page** experimental Labs feature is enabled.

<br />

Fixed Connection tests no longer appear canceled when they contain errors.

<br />

Fixed Users with custom email domains can now be added as expected using the `Add Users` setting in **New Users** page.

<br />

## 21.14

Changed Starting in Looker 21.14, the **Syntax Tolerant Liquid** legacy feature flag will be disabled for all users by default. Looker admins can continue to turn this warning off and on until October 2021, when the toggle will be removed.

<br />

Changed The [**New Explore Visualizations** Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#new_explore_visualizations) is now enabled by default.

<br />

Changed The [Looker API](https://docs.cloud.google.com/looker/docs/api-intro.md.txt) 4.0 is now designated as **beta** rather than **experimental** .

<br />

Changed [Native derived tables](https://docs.cloud.google.com/looker/docs/derived-tables.md.txt#native_derived_tables) that use the [`dev_filters`](https://docs.cloud.google.com/looker/docs/reference/param-view-explore-source.md.txt#dev_filters) parameter are rebuilt in Development Mode only if a production version that satisfies the query does not exist.

<br />

Changed MemSQL has been rebranded to **SingleStore** .

<br />

Changed Starting August 13, 2021, [GitHub requires token authentication for all Git operations](https://github.blog/2020-12-15-token-authentication-requirements-for-git-operations/). For all LookML projects that use [GitHub with password authentication](https://docs.cloud.google.com/looker/docs/setting-up-git-connection.md.txt#connecting_to_git_using_https), to successfully commit you need to [reset your Git connection in your project settings](https://docs.cloud.google.com/looker/docs/setting-up-git-connection.md.txt#configuring_https_git_authentication) to use a personal access token.

<br />

Changed When a user is deleted, any alerts they own are also deleted automatically and immediately.

<br />

Added **Enhanced Alerts** is a [Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#enhanced_alerts) that, when enabled, displays a new UI on the alert management pages for [users](https://docs.cloud.google.com/looker/docs/user-alerts.md.txt) and [admins](https://docs.cloud.google.com/looker/docs/admin-panel-alerts-and-schedules-alerts.md.txt), allows users to see more [details](https://docs.cloud.google.com/looker/docs/user-alerts.md.txt#alert_details_page) about an alert, and enables Looker to sync an alert with [most changes](https://docs.cloud.google.com/looker/docs/effect-of-dashboard-edits-on-alerts.md.txt) made to the alert's dashboard content.

<br />

Added The [**Forecasting**](https://docs.cloud.google.com/looker/docs/forecasting-in-visualizations.md.txt) Labs feature enables analysts to project analyses into the future without derived tables, table calculations, or custom code.

<br />

Added [**Clear cache and refresh permission**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#clear_cache_and_refresh_permission) is an experimental Labs feature that enables the `clear_cache_refresh` permission, which controls users' abilities to clear cache and refresh internal and embedded content.

<br />

Added **Introducing [API Explorer](https://docs.cloud.google.com/looker/docs/api-explorer.md.txt)** , our all new interactive API reference documentation that replaces the [**API Docs**](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt#current_legacy_features) feature. Starting in 21.14, API Docs is a legacy feature; however, it can still be accessed with the **Require Authentication to Retrieve API Specifications** toggle.

<br />

Added Users can now use the [**Bin**](https://docs.cloud.google.com/looker/docs/custom-fields.md.txt#custom_binning) custom dimension type to create custom bins, or tiers, on numeric dimensions without the need to write complex LEXP expressions.

<br />

Added The LookML dimension type [`bin`](https://docs.cloud.google.com/looker/docs/reference/param-dimension-filter-parameter-types.md.txt#bin) has been introduced as an alias of the type [`tier`](https://docs.cloud.google.com/looker/docs/reference/param-dimension-filter-parameter-types.md.txt#tier).

<br />

Added Users can now use the [**Get link** option](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt#getting_a_dashboards_link) under the dashboard **Actions** menu to easily share content and copy the correct URL.

<br />

Added [Google Cloud Spanner](https://docs.cloud.google.com/looker/docs/db-config-cloud-spanner.md.txt) is now a supported Looker dialect and no longer requires a JDBC driver to connect to the Spanner instance. It now supports query time zones, symmetric aggregates, and multiple `DISTINCT` columns in a single `SELECT` statement.

<br />

Added In the [**PDT details** modal of the **Persistent Derived Tables**](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt#pdt_details_modal) admin page, users can now see the SQL that was used for the last build of a PDT.

<br />

Added Admins can now create permission sets for users to include or exclude the ability to clear cache and refresh. By default, Looker users will have this permission enabled.

<br />

Fixed The first tab of XLSX files that are downloaded with the new query streaming pipeline now show `Sheet1` as their sheet name.

<br />

Fixed Using any time-related fields in the custom measure filter condition no longer creates unnecessary time zone conversions and works as expected.

<br />

Fixed The [`sql_quote` Liquid filter](https://docs.cloud.google.com/looker/docs/liquid-variable-reference.md.txt#require_sql_quote) now accepts arrays as input.

<br />

Fixed For [document files](https://docs.cloud.google.com/looker/docs/other-project-files#document_files) in your Looker project, the IDE preview will now render the files in the same way that the files appear to your users. Before, the IDE preview corrected errors in HTML so that the preview might have looked correct even if the file had HTML errors that would have been visible in the final version. Now, if your document files have errors, the errors will be visible in the IDE preview.

<br />

Fixed For projects with [advanced deploy mode](https://docs.cloud.google.com/looker/docs/advanced-deploy-mode.md.txt), the [Git button](https://docs.cloud.google.com/looker/docs/git-command-reference.md.txt) in the Looker IDE now shows [**Pull from Primary Branch**](https://docs.cloud.google.com/looker/docs/git-command-reference.md.txt#pull_primary) when a development branch is behind the production branch and [**Merge to Primary Branch**](https://docs.cloud.google.com/looker/docs/git-command-reference.md.txt#merge_primary) when there are unmerged commits on the developer branch.

<br />

## 21.12

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?`

<br />

Changed In the System Activity [**User** Explore](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#user), 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.

<br />

Changed SQL Runner buttons will no longer be surfaced for [System Activity Explores](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt).

<br />

Changed [Required filters](https://docs.cloud.google.com/looker/docs/filters-user-defined-dashboards.md.txt#requiring_a_filter_value) that are type **popover** or **advanced** will now show `Value required` instead of `Any value`.

<br />

Changed Users with the [`save_content`](https://docs.cloud.google.com/looker/docs/admin-panel-users-roles.md.txt#save_content) permission now have the ability to add tiles to dashboards.

<br />

Changed The **Make public...** keyboard shortcuts Command-Shift-P (Mac) and Ctrl+Shift+P (Windows) have been removed from Explores and Looks.

<br />

Changed Fields of type `YesNo` will have user-written SQL wrapped in parentheses when the fields are used in a SQL filter.

<br />

Changed The [**Render Long Tables**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#render_long_tables) Labs setting for visualizations is now enabled by default. Additionally, for tables with more than 20,000 cells, [cell visualizations](https://docs.cloud.google.com/looker/docs/table-options.md.txt#cell_visualization) as well as [conditional formatting](https://docs.cloud.google.com/looker/docs/table-options.md.txt#enable_conditional_formatting) options other than **Background color** no longer appear in downloads or deliveries when the **Expand Tables to Show All Rows** option is selected.

<br />

Changed To prevent merge conflicts, the Looker IDE does not present the [**Pull from (production branch)**](https://docs.cloud.google.com/looker/docs/git-command-reference.md.txt#pull_prod) option to developers when the current developer branch has uncommitted changes.

<br />

Added The new [**Redux DevTools** Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#redux_devtools) enables debugging application state.

<br />

Added New Quick Start analyses are now available for the [**History**](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#history) and [**Dashboard**](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#dashboard) System Activity Explores.

<br />

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.

<br />

Added Users are now able to [add Looks](https://docs.cloud.google.com/looker/docs/adding-saved-content-to-dashboards-legacy-feature) directly to dashboards with the **Add Looks to dashboards** [legacy feature](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt#current_legacy_features) toggle enabled.

<br />

Added [Two new integrations](https://docs.cloud.google.com/looker/docs/admin-panel-platform-actions.md.txt#list_of_integrated_services) 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.

<br />

Added [**Auto Install**](https://docs.cloud.google.com/looker/docs/admin-panel-platform-marketplace.md.txt#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).

<br />

Added The Looker [extension framework](https://docs.cloud.google.com/looker/docs/extension-framework.md.txt) is out of Labs and now generally available under the [Admin \> Platform](https://docs.cloud.google.com/looker/docs/admin-panel-platform-extension-framework.md.txt) settings. The extension framework is a development framework that significantly reduces the effort and complexity of building data applications with Looker.

<br />

Added Admins now have the ability to move content to the trash in bulk in the **Unused Content** page.

<br />

Added A new Labs feature, [Enhanced Navigation](https://docs.cloud.google.com/looker/docs/navigating-looker.md.txt), simplifies user workflows with unified left-hand navigation and more performant routing between common pages and content.

<br />

Added The [**Upgraded Explore Field Picker**](https://docs.cloud.google.com/looker/docs/exploring-data#new_explore_field_picker) Labs feature is out of Labs and now generally available. The [**Legacy Explore Field Picker**](https://docs.cloud.google.com/looker/docs/legacy-field-picker.md.txt) is available as a Legacy feature until Looker 21.16.

<br />

Added The [**Custom Fields**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#custom_fields) Labs feature introduces new [**Quick Calculation**](https://docs.cloud.google.com/looker/docs/table-calculations.md.txt#quick_calculations) and [**Group**](https://docs.cloud.google.com/looker/docs/custom-fields.md.txt#custom_grouping) functionalities.

<br />

Added A new Labs feature, [**Improved LookML Generation**](https://docs.cloud.google.com/looker/docs/generating-a-model.md.txt#improved_lookml_generation), adds auto-generated measures and inline comment explanations to new LookML projects that are [generated from your database](https://docs.cloud.google.com/looker/docs/generating-a-model.md.txt#automatically_generating_a_model_from_your_database).

<br />

Added The new Experimental Labs feature, [**Prerender iframes (before data loads) for custom visualizations**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#prerender_iframes) has been added and is disabled by default.

<br />

Added The new **PDT Development Mode visibility** feature enables developers to see the state of their Development Mode PDTs [in the IDE](https://docs.cloud.google.com/looker/docs/derived-tables.md.txt#checking_for_unbuilt_pdts_in_development_mode) and [on the PDT Admin page](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt#production_and_development_tabs) while the user is in Development Mode.

<br />

Added A new LookML parameter, [`fields_hidden_by_default: yes`](https://docs.cloud.google.com/looker/docs/reference/param-view-fields-hidden-by-default.md.txt), allows users to hide all fields in a view from being displayed in an Explore field picker.

<br />

Added Aggregate awareness now recognizes when a dashboard filter is applied to a tile. When [getting aggregate table LookML from a dashboard](https://docs.cloud.google.com/looker/docs/reference/param-explore-aggregate-table.md.txt#getting_aggregate_table_lookml_from_a_dashboard), Looker will add the filter's dimension to the tile's aggregate table so the aggregate table can be used for the tile.

<br />

Added A new LookML parameter, [`dev_filters`](https://docs.cloud.google.com/looker/docs/reference/param-view-explore-source.md.txt#dev_filters), allows a developer to reduce the size of the dataset for a native derived table in Development Mode.

<br />

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.

<br />

Fixed The `dashboard_element.result_source` field no longer contains incorrect conditional logic for merge queries in the System Activity [**Dashboard** Explore](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#dashboard).

<br />

## 21.10

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](https://docs.cloud.google.com/looker/docs/admin-panel-alerts-and-schedules-scheduled-emails.md.txt#send_link_only). Looker will now warn users who attempt to enable the **Send Link Only** policy that the setting may cause some schedules to not work.

<br />

Changed Visual design improvements to the **Upgraded Explore Field Picker** [Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#upgraded_explore_field_picker) enable users to more easily differentiate views from groups, and more easily identify when fields are pivoted or filtered.

<br />

Changed The [incremental PDTs](https://docs.cloud.google.com/looker/docs/incremental-pdts.md.txt) feature is now out of Labs and is generally available.

<br />

Changed In the System Activity [**User**](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#user) Explore, the `history.query_run_count` measure now filters out history records where the `history.status` value is `cache_only_miss`.

<br />

Changed Looker components 2.0.0 is now available. To reduce the package size of [`@looker/components`](https://github.com/looker-open-source/components), all the date picker and date functions are now in a new package, [`@looker/components-date`](https://github.com/looker-open-source/components/tree/main/packages/components-date).

<br />

Added The [search experience](https://docs.cloud.google.com/looker/docs/exploring-data#search_bar) for the **Upgraded Explore Field Picker** [Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#upgraded_explore_field_picker) now includes support for [search modifiers](https://docs.cloud.google.com/looker/docs/exploring-data#entering_a_search_modifier_into_the_search_bar) to narrow the scope of the field list.

<br />

Added The `LookML Link ID` dimension is now available in the System Activity **Content Usage** , **Dashboard** , **Dashboard Performance** , **History** , **Scheduled Plan** , and **User** [Explores](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt). If a user-defined dashboard was created from a LookML dashboard, this field will contain the ID of the source LookML dashboard.

<br />

Added A new CLI feature for extension development is now available as the [`create-looker-extension`](https://docs.cloud.google.com/looker/docs/extension-intro-to-building.md.txt#using_create-looker-extension_to_create_an_extension_template).

<br />

Added The `Custom Fields` dimension is now available in the System Activity **Dashboard** , **History** , **Look** , **Merge Query** , and **Scheduled Plan** [Explores](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt). This dimension provides a JSON string of any table calculations, custom measures, or custom dimensions that are used in a query.

<br />

Added [Dashboards](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt) 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.

<br />

Added Users can now reset all filters to their default state from the [dashboard three-dot menu](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt#resetting_filter_values) or by using the Command-Option-R (for Macs) or Ctrl+Alt+R (for Windows) [keyboard shortcut](https://docs.cloud.google.com/looker/docs/keyboard-shortcuts.md.txt#shortcuts_when_viewing_dashboards).

<br />

Added New Looker expression function [`case(when(), when(), else)`](https://docs.cloud.google.com/looker/docs/functions-and-operators.md.txt#case-when) allows for sequential conditional statements without the need to nest those statements across multiple `if` functions.

<br />

Added When [getting aggregate table LookML from a dashboard](https://docs.cloud.google.com/looker/docs/reference/param-explore-aggregate-table.md.txt#getting_aggregate_table_lookml_from_a_dashboard), Looker determines whether a generated aggregate table could be used for more than one tile and, if so, drops any redundant aggregate tables that can be used for fewer tiles.

<br />

Added Looker now supports the Firebolt database dialect.

<br />

Added [Materialized views](https://docs.cloud.google.com/looker/docs/reference/param-view-materialized-view.md.txt) 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](https://docs.cloud.google.com/looker/docs/reference/param-view-materialized-view.md.txt#dialect_support).

<br />

Added The Looker Marketplace now supports LookML blocks [that are built with refinements syntax](https://docs.cloud.google.com/looker/docs/marketplace-customize-blocks.md.txt#marketplace_blocks_that_use_refinements). 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.

<br />

Added A new file, [`marketplace_lock.lkml`](https://docs.cloud.google.com/looker/docs/marketplace-customize-blocks.md.txt#block_file_structure), maintains metadata about a Marketplace block installation's version number, models, and LookML constant values.

<br />

Fixed You can now create [data actions](https://docs.cloud.google.com/looker/docs/reference/param-field-action.md.txt) without defining a form parameter. These actions will show a pending, a success, and an error state.

<br />

Fixed Look [schedules that are delivered through webhook](https://docs.cloud.google.com/looker/docs/delivering-looks-explores.md.txt#delivery_options_for_webhooks) now send a Look title and link back to Looker content, as expected.

<br />

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.

<br />

Fixed Schedules that contain tables with location dimensions now send as expected.

<br />

Fixed Editing a scheduled plan will now open with the schedule's previously saved state.

<br />

Fixed LookML that was generated for a derived table now escapes underscores in filters, as expected.

<br />

Fixed Custom filters with `type: yesno` dimensions now generate correct SQL.

<br />

Fixed The LookML validator no longer crashes when it encounters an extra closing bracket.

<br />

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

<br />

## 21.8

Changed The Looker EULA for trial instances has been updated.

<br />

Changed The [**LookML Model Explore**](https://docs.cloud.google.com/looker/docs/reference/looker-api/latest/methods/LookmlModel/lookml_model_explore.md.txt) 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.

<br />

Changed The color contrast in data tables has been increased, which improves the accessibility of data tables in [Explores](https://docs.cloud.google.com/looker/docs/exploring-data).

<br />

Changed The **Clear Cache \& Refresh** option for [embedded dashboards and tiles](https://docs.cloud.google.com/looker/docs/viewing-embedded-items.md.txt#viewing_embedded_dashboards) has been removed.

<br />

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](https://docs.cloud.google.com/looker/docs/legacy-features).

<br />

Changed On the System Activity [**Performance** dashboard](https://docs.cloud.google.com/looker/docs/system-activity-dashboards.md.txt#database_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`.

<br />

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.

<br />

Added The Looker mobile app now supports the same 22 languages that the Looker web app supports.

<br />

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.

<br />

Added The **SQL Text** field is now available in the System Activity [**History** Explore](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#history). You can access this field by selecting **Show SQL Text** in the drill menu in the **History ID** field.

<br />

Added The following improvements have been made to the System Activity [**Content Usage** Explore](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#content_usage): 8 Quick Start analyses 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.

<br />

Added [**Search Service**](https://docs.cloud.google.com/looker/docs/finding-content.md.txt#improved_search) is a new beta [Labs](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#search_service) 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.

<br />

Added [Drill links](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt#drilling_into_data_points) in new dashboards now open in a new tab if you click the links in combination with the Control or Command keys.

<br />

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.

<br />

Added **New Explore Visualizations** is a beta Labs feature that creates parity between the visualizations shown on a new dashboard and Explores.

<br />

Added Introducing new embed **Save** [events](https://docs.cloud.google.com/looker/docs/embedded-javascript-events.md.txt) when a look is edited, saved or deleted. Developers can leverage these events to take action in the parent pages of their applications.

<br />

Added The [`application` parameter](https://docs.cloud.google.com/looker/docs/reference/param-manifest-application.md.txt) now includes an `sri_hash` subparameter, which lets you specify a [Subresource Integrity (SRI)](https://developer.mozilla.org/en-US/docs/Web/Security/Subresource_Integrity) hash, and a new `use_clipboard` entitlement, which specifies whether an extension is allowed to write to the system clipboard.

<br />

Added [**API Explorer**](https://docs.cloud.google.com/looker/docs/api-explorer.md.txt) 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.

<br />

Added UI-based [filtered measures](https://docs.cloud.google.com/looker/docs/custom-fields.md.txt#adding_a__filter_to_a_custom_measure) have been added to the existing [**Custom Fields**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#custom_fields) experimental Labs feature.

<br />

Added The `rootUrl` JDBC parameter can now be used to customize the destination of BigQuery API requests.

<br />

Added An admin user can now alter the IP address for BigQuery connections in the **Additional Params** options of the database connection settings.

<br />

Fixed The LookML Validator now validates custom fields for LookML dashboards.

<br />

Fixed LookML dashboards with non-ASCII characters in their titles can be scheduled, rendered, or downloaded as expected.

<br />

Fixed Schedules saved for a single day per week no longer result in an error.

<br />

Fixed Schedules with the **Visualization** format no longer check for `explore` permission.

<br />

Fixed Schedules with **Send if there are results** selected will correctly check for results, even if table calculations and pivots are both used.

<br />

Fixed Downloads with **Results In Table** selected now correctly download only selected rows, even if the row limit is blank.

<br />

Fixed Dashboards can now be scheduled to send based on datagroup update, as expected.

<br />

Fixed The **scheduled_plan.updated_at** field now has a datatype of `TIMESTAMP` instead of `INT64`.

<br />

Fixed Advanced filter tier controls now work with parameter fields that contain underscores.

<br />

## 21.6

Changed The [metadata panel](https://docs.cloud.google.com/looker/docs/lookml-metadata.md.txt) of the Looker IDE is now out of Labs and is generally available.

<br />

Changed The **Trend Lines in Visualizations** [Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#trend_lines_in_visualizations) is now out of Labs and is generally available.

<br />

Changed The [Looker extension framework](https://docs.cloud.google.com/looker/docs/intro-to-extension-framework.md.txt) can be used to create iframes if [`use_iframes`](https://docs.cloud.google.com/looker/docs/reference/param-manifest-application.md.txt#use_iframes) entitlement is added to the extension. Extensions that have the [`use_embeds`](https://docs.cloud.google.com/looker/docs/reference/param-manifest-application.md.txt#use_embeds) entitlement are automatically granted the `use_iframes` entitlement.

<br />

Changed All Looker [custom visualizations](https://docs.cloud.google.com/looker/docs/admin-panel-platform-visualizations.md.txt) now use a sandboxed iframe to promote security. Unsandboxed custom visualizations are no longer supported in Looker.

<br />

Changed Adding an external email address to scheduled content no longer automatically switches off the [**Run schedule as recipient**](https://docs.cloud.google.com/looker/docs/managing-business-user-features.md.txt#sending_content_as_recipient) toggle. Instead, an error will be displayed stating that you cannot save an external recipient with that option enabled.

<br />

Changed A syntax warning is returned if the keyword `bigquery_datetime_as_timestamp` is included in a model.

<br />

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

<br />

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.

<br />

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

<br />

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.

<br />

Changed In the **Connections** drop-down, users can no longer see connections that they do not have SQL Runner access to.

<br />

Changed The Looker Dialect BlinkDB has been deprecated and is no longer available.

<br />

Changed Looker no longer supports the IBM DB2 Warehouse on Cloud (dashDB) dialect. Instead, for DB2 databases, you can use [IBM DB2 on AS400](https://docs.cloud.google.com/looker/docs/db-config-ibm-db2-on-as400.md.txt) or [IBM DB2 for Linux, UNIX, and Windows (LUW)](https://docs.cloud.google.com/looker/docs/db-config-ibm-db2-for-luw.md.txt).

<br />

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.

<br />

Added Users can now navigate to LookML objects using the Looker IDE [**Jump to object or file**](https://docs.cloud.google.com/looker/docs/manage-projects.md.txt#search_for_and_jump_to_lookml_objects_or_project_files) icon or the keyboard shortcut Command-J (Mac) or Ctrl+J (Windows).

<br />

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.

<br />

Added Columns in the data table in [Explore queries](https://docs.cloud.google.com/looker/docs/exploring-data) now show helpful hints when users [add multiple sort orders](https://docs.cloud.google.com/looker/docs/exploring-data#sorting_data). This allows users to see the order in which sort orders are executed as well as any limitations that may be present.

<br />

Added [Custom fields](https://docs.cloud.google.com/looker/docs/custom-fields.md.txt) and [table calculations](https://docs.cloud.google.com/looker/docs/table-calculations.md.txt#adding_a_table_calculation_with_custom_fields_enabled) now support descriptions.

<br />

Added [The search experience](https://docs.cloud.google.com/looker/docs/exploring-data#search_bar) for the **Upgraded Explore Field Picker** [Labs feature](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#upgraded_explore_field_picker) has been improved.

<br />

Added Starting in Looker 21.6, Looker is launching a [new Liquid parser](https://docs.cloud.google.com/looker/docs/best-practices/how-to-use-the-liquid-syntax-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**](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt#current_legacy_features), which is enabled by default, ensures that all errors are categorized as informational.

<br />

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

<br />

Added A new JDBC parameter, `rootUrl`, can be used to customize the destination of BigQuery API requests.

<br />

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.

<br />

Added If the [Incremental PDTs](https://docs.cloud.google.com/looker/docs/incremental-pdts.md.txt) Labs feature is enabled, the [**PDT Details**](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt#pdt_details) pop-up in the [Persistent derived tables](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt) 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.

<br />

Added The **New Users Page (beta)** Labs feature allows users to see a redesigned, user-friendly, and more performant [user list page](https://docs.cloud.google.com/looker/docs/admin-panel-users-users.md.txt#new_users_page).

<br />

Added The [**Embedded Content Navigation**](https://docs.cloud.google.com/looker/docs/viewing-embedded-items.md.txt#viewing_folders_on_embedded_dashboards) 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`](https://docs.cloud.google.com/looker/docs/admin-panel-users-roles.md.txt#embed_browse_spaces) permission.

<br />

Added Four new embed JavaScript message events are available for embedded dashboards and Looks: [`dashboard:save:complete`](https://docs.cloud.google.com/looker/docs/embedded-javascript-events.md.txt#dashboard:save:complete), [`dashboard:delete:complete`](https://docs.cloud.google.com/looker/docs/embedded-javascript-events.md.txt#dashboard:delete:complete), [`look:save:complete`](https://docs.cloud.google.com/looker/docs/embedded-javascript-events.md.txt#look:save:complete), and [`look:delete:complete`](https://docs.cloud.google.com/looker/docs/embedded-javascript-events.md.txt#look:delete:complete).

<br />

Added Two new entitlements have been added for extensions that are built using the [Looker extension framework](https://docs.cloud.google.com/looker/docs/extension-framework.md.txt): [`use_downloads`](https://docs.cloud.google.com/looker/docs/reference/param-manifest-application.md.txt#use_downloads), which specifies whether an extension is allowed to download files, and [`use_iframes`](https://docs.cloud.google.com/looker/docs/reference/param-manifest-application.md.txt#use_iframes), which specifies whether the extension is allowed to create an iframe.

<br />

Added Added support for the [Databricks](https://docs.cloud.google.com/looker/docs/db-config-databricks.md.txt) dialect.

<br />

Fixed Users can schedule dashboards and send to integrations only if granted permissions to see dashboards as well as the [`send_to_integration` permission](https://docs.cloud.google.com/looker/docs/admin-panel-users-roles.md.txt#send_to_integration), as expected.

<br />

Fixed New Looker instances will use `/browse` as the default homepage.

<br />

Fixed Users can create scheduled plans to enabled [Looker Action Hub destinations](https://docs.cloud.google.com/looker/docs/admin-panel-platform-actions.md.txt#list_of_integrated_services) from a folder, as expected.

<br />

Fixed Improvements have been made to value formatters.

<br />

## 21.4

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 '(?)'`

<br />

Changed The [`DataTable`](https://looker-open-source.github.io/components/latest/components/content/data-table) Looker component has been updated to be more accessible for screen readers, with better labeling on columns, rows, and cells.

<br />

Changed The [`List`](https://looker-open-source.github.io/components/latest/components/content/list) component is now enriched with additional features. Additionally, there are two new components for lists: [`OrderedList`](https://looker-open-source.github.io/components/latest/components/text/ordered-list) and [`UnorderedList`](https://looker-open-source.github.io/components/latest/components/text/unordered-list).

<br />

Changed Look and dashboard view counts are now updated asynchronously; therefore, data changes may not be reflected immediately.

<br />

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

<br />

Changed Errors in a project manifest file will surface correctly even if there are no models in the LookML project.

<br />

Changed Admins can configure [user attributes referenced by access filters](https://docs.cloud.google.com/looker/docs/reference/param-explore-access-filter.md.txt#even_admins_must_have_filter_values_set_in_the_ui) 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](https://docs.cloud.google.com/looker/docs/aggregate_awareness.md.txt) (projects with an aggregate table defined), but is now the behavior for all Looker projects with these user attribute settings.

<br />

Changed The `--scheduler-threads=<i>` [startup flag](https://docs.cloud.google.com/looker/docs/startup-options.md.txt) can no longer be used to determine alert runs or to disable alerts. For these tasks, use the `--alerts-scheduler-threads=<i>` flag.

<br />

Changed The `create_query` API endpoint now accepts filter values of only `type: string`.

<br />

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.

<br />

Changed Looker Dialect Vertica 6 has been deprecated. [Vertica](https://docs.cloud.google.com/looker/docs/db-config-vertica.md.txt) remains a fully supported Looker dialect.

<br />

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.

<br />

Changed Because of several Slack API endpoint deprecations, users must upgrade to [Lookerbot version 0.0.16 or higher](https://github.com/looker/lookerbot) for [Lookerbot](https://docs.cloud.google.com/looker/docs/best-practices/how-to-use-lookerbot-for-slack.md.txt) to function properly.

<br />

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.

<br />

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.

<br />

Added While in [edit mode](https://docs.cloud.google.com/looker/docs/editing-user-defined-dashboards.md.txt#entering_edit_mode_in_dashboards) on dashboards, users now have the ability to discard their changes using the **Cancel** button.

<br />

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.

<br />

Added Dashboards that include a tile based on a [System Activity Explore](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt) can now use the fields from the Explore to create dashboard filters. System Activity filters cannot be added to legacy dashboards.

<br />

Added The [metadata panel](https://docs.cloud.google.com/looker/docs/lookml-metadata.md.txt) of the Looker IDE, which is enabled by the **IDE Metadata Sidebar** Labs feature, now shows primary key information in [view metadata](https://docs.cloud.google.com/looker/docs/lookml-metadata.md.txt#metadata_for_views). In addition, the metadata panel includes metatdata for [imported projects](https://docs.cloud.google.com/looker/docs/lookml-metadata.md.txt#metadata_for_imported_projects).

<br />

Added The [LookML Model Diagram (beta)](https://docs.cloud.google.com/looker/docs/lookml-diagram-using.md.txt) 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.

<br />

Added Cross-filtering now supports [range selection](https://docs.cloud.google.com/looker/docs/cross-filtering-dashboards.md.txt#using_range_selection) on visualizations.

<br />

Added For LookML projects [automatically generated](https://docs.cloud.google.com/looker/docs/generating-a-model.md.txt#automatically_generating_a_model_from_your_database) from a BigQuery database, Looker will autopopulate the LookML field [`description`](https://docs.cloud.google.com/looker/docs/reference/param-field-description.md.txt#definition) values with the descriptions from the BigQuery column metadata, if any.

<br />

Added For projects using a BigQuery connection with [aggregate awareness](https://docs.cloud.google.com/looker/docs/aggregate_awareness.md.txt), 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.

<br />

Added [Fetch Information Schema for SQL Writing](https://docs.cloud.google.com/looker/docs/connecting-to-your-db.md.txt#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.

<br />

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](https://docs.cloud.google.com/looker/docs/legacy-feature-schedule.md.txt#current_legacy_features), including support for ECMA-376 format codes.

<br />

Added Users should now see significant performance improvements to the **PDT Admin** page.

<br />

Added A new beta Labs feature, [Incremental PDTs](https://docs.cloud.google.com/looker/docs/incremental-pdts.md.txt), enables Looker to append fresh data to a PDT instead of rebuilding the entire table.

<br />

Added The [**PDT Activity** dashboard](https://docs.cloud.google.com/looker/docs/admin-panel-database-pdts.md.txt#pdt_activity_dashboard) has been added to the **System Activity** model and is now accessible from the **Persistent Derived Tables** page under **Admin** .

<br />

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.

<br />

Added The [`Tree`](https://looker-open-source.github.io/components/latest/components/content/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.

<br />

Added A new experimental Labs toggle option, [**Render Long Tables**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#render_long_tables), can be enabled to reduce the PDF or PNG rendering time for long tables.

<br />

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)`.

<br />

Added A new API 4.0 beta endpoint, `api_spec`, can be used to retrieve a Looker API specification from the Looker server.

<br />

Added The new [`embed_save_shared_space` permission](https://docs.cloud.google.com/looker/docs/single-sign-on-embedding#embed_save_shared_space) 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.

<br />

Added [SAP HANA version 2](https://docs.cloud.google.com/looker/docs/db-config-sap-hana.md.txt) and [Apache Spark 3+](https://docs.cloud.google.com/looker/docs/db-config-apache-spark.md.txt) are now supported Looker dialects.

<br />

Added Vertica dialect now supports **percentile** , a LookML measure type.

<br />

Added Japanese characters can now be entered into the [Looker Data Dictionary](https://docs.cloud.google.com/looker/docs/using-looker-data-dictionary.md.txt) extension context data.

<br />

Added Now available in the [Looker Marketplace](https://docs.cloud.google.com/looker/docs/marketplace.md.txt), **Force-Directed Graph** is a new custom visualization that you can use to show relationships among entities in your data.

<br />

Added Gerrit is now a supported Git repository.

<br />

Added Microsoft Azure is now available as a hosting environment for Looker-hosted instances. Instances are currently hosted in the [Virginia, USA region](https://docs.cloud.google.com/looker/docs/enabling-secure-db-access.md.txt#instances_hosted_on_microsoft_azure).

<br />

Fixed Targets of the `link` parameter that use an absolute link will now open in a new browser tab as expected.

<br />

Fixed Users can [create dashboard filters](https://docs.cloud.google.com/looker/docs/filters-user-defined-dashboards.md.txt#adding_dashboard_filters) that filter twice on the same field, as long as each filter is applied to different dashboard tiles.

<br />

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.

<br />

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.

<br />

Fixed Aggregate awareness used with filter values of `NULL` and `not NULL` works as expected.

<br />

Fixed [Visual drilling defined in the LookML](https://docs.cloud.google.com/looker/docs/reference/param-field-link.md.txt#example:_using_link_to_customize_drill_visualizations) is now supported on dashboards that use the new dashboard experience.

<br />

Fixed Customers with access to the **System Activity** Explores can now add filters on those fields as expected when creating dashboards.

<br />

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.

<br />

Fixed Users can now select a TLS version on the **Custom SMTP settings** page as expected.

<br />

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.

<br />

Fixed Embed SSO URL validation errors will now appear within the [validation area on the **Admin Embed**](https://docs.cloud.google.com/looker/docs/admin-panel-platform-embed.md.txt#embed_uri_validator) page as expected.

<br />

Fixed One-time [SFTP deliveries](https://docs.cloud.google.com/looker/docs/delivering-looks-explores.md.txt#delivery_options_for_sftp_servers) can be created, modified, and saved as expected.

<br />

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.

<br />

## 21.0

Changed The **Year to Date** control option on the [`timeframes`](https://docs.cloud.google.com/looker/docs/filters-user-defined-dashboards.md.txt#dashboard_filter_controls) filter, used to filter from the beginning of the year to the current date, has been temporarily removed.

<br />

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](https://docs.cloud.google.com/looker/docs/filters-user-defined-dashboards.md.txt#displaying_dashboard_filters).

<br />

Changed Some filter control types now have [only one possible display orientation](https://docs.cloud.google.com/looker/docs/filters-user-defined-dashboards.md.txt#displaying_dashboard_filters). 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.

<br />

Changed The [cross-filtering](https://docs.cloud.google.com/looker/docs/cross-filtering-dashboards.md.txt) feature is now generally available without having to enable a Labs feature. Cross-filtering must be enabled on each dashboard.

<br />

Changed [SQL Runner](https://docs.cloud.google.com/looker/docs/sql-runner-create-queries-and-explores.md.txt) queries can no longer be [merged](https://docs.cloud.google.com/looker/docs/merged-results.md.txt) to Explore queries and saved to dashboards.

<br />

Changed When you launch a [Quick Start](https://docs.cloud.google.com/looker/docs/exploring-data#quick_start_analyses) analysis, the visualization pane will automatically be opened. Quick Start analyses now respect applied sorting.

<br />

Changed When you [clear fields](https://docs.cloud.google.com/looker/docs/exploring-data#removing_fields_from_the_in_use_tab) from an Explore query, custom fields will be deselected instead of removed.

<br />

Changed On the [**In Use**](https://docs.cloud.google.com/looker/docs/exploring-data#in_use_tab_field-specific_icons_and_actions) tab of an Explore, users can now switch the timeframe of a selected `date` or `duration` field without going into the full field list.

<br />

Changed The upgraded Explore field picker defaults to the [**All Fields**](https://docs.cloud.google.com/looker/docs/exploring-data#all_fields_tab) tab instead of the [**In Use**](https://docs.cloud.google.com/looker/docs/exploring-data#in_use_tab) tab when an existing query is open.

<br />

Changed If the [**New Query Streaming**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#new_query_streaming) experimental Labs feature is enabled and the query is streamable, the scheduler will use the new query streaming feature.

<br />

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

<br />

Changed A [custom visualization](https://docs.cloud.google.com/looker/docs/reference/param-manifest-visualization.md.txt) that uses JavaScript no longer requires third-party cookies to be enabled for it to load.

<br />

Changed The Looker Data Dictionary [field profiler](https://docs.cloud.google.com/looker/docs/using-looker-data-dictionary.md.txt#using_the_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.

<br />

Changed The ability to join to the sessions table has been removed from drill queries on tiles in the [**User Activity** dashboard](https://docs.cloud.google.com/looker/docs/system-activity-dashboards.md.txt#user_activity_dashboard) under the **System Activity** section of the **Admin** panel.

<br />

Changed Extension code can be split into multiple bundles for faster load time.

<br />

Changed As with previous versions of Looker, when the last remaining recipient of a scheduled content delivery [unsubscribes](https://docs.cloud.google.com/looker/docs/glossary.md.txt#unsubscribe), 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?`

<br />

Changed To generate LookML that better handles nested records, improvements have been made to the LookML generator and **Create View from Table** page.

<br />

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.

<br />

Changed Looker's [managed database service](https://docs.cloud.google.com/looker/docs/connecting-to-your-db.md.txt#looker_managed_database) 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).

<br />

Changed Support for JDK 11 has been temporarily suspended.

<br />

Added A new visualization type, **Histogram Visualization** , is now available from the [Looker Marketplace](https://docs.cloud.google.com/looker/docs/marketplace.md.txt).

<br />

Added Users can now create a custom measure from a [custom dimension](https://docs.cloud.google.com/looker/docs/custom-fields.md.txt#using_the_dimensions_gear_menu) in the field picker.

<br />

Added Cross-filtering is now [supported](https://docs.cloud.google.com/looker/docs/cross-filtering-dashboards.md.txt#supported_and_unsupported_visualization_types) on the **Funnel Chart** and **Timeline Chart** visualization types and for custom visualizations.

<br />

Added [**Fast Value Formatting**](https://docs.cloud.google.com/looker/docs/admin-panel-general-labs#fast_value_formatting) is a new beta Labs feature that significantly improves value formatting performance.

<br />

Added Subheaders identifying the type and name of an object are now populated in the [metadata panel](https://docs.cloud.google.com/looker/docs/lookml-metadata.md.txt), 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](https://docs.cloud.google.com/looker/docs/lookml-metadata.md.txt#metadata_for_views), which provide context for how the view is used in your project.

<br />

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.

<br />

Added Embedded images (base64-encoded) can be viewed in query results if the **Block Inline Embedded Images in Query Results** admin setting is disabled.

<br />

Added [Alerts](https://docs.cloud.google.com/looker/docs/alerts-overview.md.txt#setting_alert_frequency) 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.

<br />

Added The [role, model set, and permission set](https://docs.cloud.google.com/looker/docs/admin-panel-users-roles.md.txt) listing page is now paginated and searchable.

<br />

Added Admins for instances with whitelabeling enabled can now access product messaging.

<br />

Added Users can now [view and adjust time zones](https://docs.cloud.google.com/looker/docs/viewing-dashboards.md.txt#temporarily_changing_the_dashboard_time_zone) within dashboards using the new dashboard experience, as long as [User Specific Time Zones](https://docs.cloud.google.com/looker/docs/using-time-zone-settings.md.txt#user_specific_time_zones) is enabled.

<br />

Added Users can now add and save [comments](https://docs.cloud.google.com/looker/docs/using-looker-data-dictionary.md.txt#using_field_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](https://docs.cloud.google.com/looker/docs/marketplace.md.txt).

<br />

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**](https://docs.cloud.google.com/looker/docs/git-options.md.txt#git_production_branch_name) field in the **Project Settings** . The default Git production branch is **master** .

<br />

Added Amazon Redshift is now a supported SQL Dialect for distinct counts with [aggregate awareness](https://docs.cloud.google.com/looker/docs/aggregate_awareness.md.txt).

<br />

Added Dremio 11+ is now a [supported Looker dialect](https://docs.cloud.google.com/looker/docs/dialects.md.txt) and includes support for [symmetric aggregates](https://docs.cloud.google.com/looker/docs/reference/param-explore-symmetric-aggregates.md.txt).

<br />

Added Dialects Cloudera Impala 3.1+ and Cloudera Impala with Native Diver 3.1+ now support [symmetric aggregates](https://docs.cloud.google.com/looker/docs/reference/param-explore-symmetric-aggregates.md.txt).

<br />

Added In the experimental Looker API (v4), the `all_users` endpoint can optionally request user count.

<br />

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.

<br />

Added A new measure, **Dashboards Run Count** , has been added to the [System Activity history view](https://docs.cloud.google.com/looker/docs/usage-reports-with-system-activity-explores.md.txt#history).

<br />

Added The Google Chronicle Security Block, for analysis of Chronicle datasets in Google BigQuery, is now available from the [Looker Marketplace](https://docs.cloud.google.com/looker/docs/marketplace.md.txt).

<br />

Fixed The upgraded Explore field picker result set no longer displays erratic scrolling and now has improved accessibility support.

<br />

Fixed The list of available options for the values of parameters now renders as expected.

<br />

Fixed Visualizations no longer have issues with y-axis labels and tick mark values overlapping.

<br />

Fixed Resizing columns on transposed tables works as expected.

<br />

Fixed Sorting in the [upgraded field picker](https://docs.cloud.google.com/looker/docs/exploring-data#new_explore_field_picker) is based on the [`group_item_label`](https://docs.cloud.google.com/looker/docs/reference/param-field-group-item-label.md.txt), as expected.

<br />

Fixed The table header shows up as expected when a [table calculation](https://docs.cloud.google.com/looker/docs/table-calculations.md.txt) is added to a table before any dimensions or measures.

<br />

Fixed SSO Embed users will no longer be shown a logout pop-up.

<br />

Fixed Embedded dashboards that use the new dashboard experience no longer generate spurious `page:changed` and `dashboard:filters:changed` messages.

<br />

Fixed Performance improvements on the **Admin \> Connections** and **Admin \> Groups** pages result in faster page loads.

<br />

Fixed Users no longer require `explore` permissions to [download drill data](https://docs.cloud.google.com/looker/docs/exploring-data#drilling_deeper_) in PNG format.

<br />

Fixed [System Activity](https://docs.cloud.google.com/looker/docs/system-activity-pages.md.txt) is now returned with `all_lookml_models()`, including `lookmlmodel(system_activity)`, if the user has `see_system_activity` permissions.

<br />

Fixed Downloads to the XLSX format using the **New Query Streaming** feature work as expected for queries with value formatting and measures.

<br />

Fixed Links using Liquid variables work as expected.

<br />

Fixed When Looker's [Slack integration](https://docs.cloud.google.com/looker/docs/scheduling-slack.md.txt) is enabled, the `/looker select` command is included as expected in the [list of supported commands](https://docs.cloud.google.com/looker/docs/scheduling-slack.md.txt#using_slash_commands_to_retrieve_looker_information_in_slack) shown when you type the `/looker help` command into Slack.

<br />

Fixed [Time series alerts](https://docs.cloud.google.com/looker/docs/best-practices/how-to-set-alerts-based-on-time-series-data.md.txt) will fire as expected if values in any pivoted column meet or exceed the alert conditions.

<br />