Looker 6.12 Extended Support Release Notes

Anticipated Deployment Dates

ESR Staging: June 2, 2019 - July 2, 2019
ESR Production Release: July 3, 2019 - October 2, 2019


Release Highlights

In addition to general tweaks and enhancements, this release comes with new and improved features in the following categories. Read on for more detail.

Preparing for Release

Please take notice of items marked with a :zap: as they indicate changes to existing functionality and may require your attention. For more information see Features by Section below.

Experimental and Beta Features

The following new and improved experimental and beta features are marked with a :alembic::


Notable Features

Localized visualizations

Dashboards and visualizations can now be displayed in French, German, and Japanese, giving your content worldwide reach! Embedded content will pick up a user’s locale. Filters, Looker menu items, etc. will not be translated.

Import private repositories

The experimental Project Import Labs feature now supports references to private external repositories. Use it to reference and extend projects from elsewhere in your organization or code blocks anywhere you can access them!

Three (or four) New Visualizations

By popular request, we’ve added three new standard visualizations and a fourth Labs revamp of the table visualization. Use the new box plot to show distributions in value, use the waterfall to help understand the cumulative effect of positive and negative values, and highlight the most popular values with the new word cloud. The new table visualization has native subtotals and adjustable and freezable columns.


Features by Section

Dashboards, Visualizations, and Explore

  • Localized dashboards and visualizations. Visualizations and dashboards now support French, German, and Japanese. Application menu items, filters, etc. do not yet support translations. Learn more.
  • :zap: :alembic: To be consistent with how dashboards are handled, the beta API 3.1 no longer includes soft-deleted Looks in all_looks() calls. The call is not changed in API 3.0.
  • New visualizations!
  • Reverse the colors. Added an option to reverse the order of a color palette when multiple series are present in a visualization.
  • Visualization Improvements
    • Boxplot visualization. Now shows a shaded range between the max and min when 2 or 3 measures are selected. Learn more.
    • Waterfall visualization. Now supports having 1+ measure selected with no dimensions selected. Learn more.
    • :zap: Pie visualization. Refactored the pie visualization and added options to control the start and end angles. Learn more.

Platform and Administration

  • Introduced Oauth for the Action Hub. New actions may be built with OAuth, allowing users to authenticate as themselves to take action in another application.
  • :zap: New default password requirements. New and reset passwords will be subject to the following requirements: minimum length 10 characters, at least one uppercase and one lowercase letter, one numeric character, and one special character. Learn more.
  • New language support. Expanded current language support to include Spanish, Italian, Korean, Dutch, Portuguese, Brazilian Portuguese, and Russian. Learn more.
  • :alembic: System Activity model and dashboard improvements
    • Fields used in non-Look tiles are now tracked in the model and dashboards.
    • Added descriptions to the remaining fields in the model.
    • Improved drill fields in the System Activity model and dashboards.
  • :alembic: Promoted API 3.1 from “experimental” to “beta”.
  • Added the ability to disable Gravatar user account profile pictures. Learn more.
  • Added Javascript events that track when embedded content begins and completes loading data. Learn more.
  • :zap: Completely removed the “Show Full Field Name” Legacy Feature. Learn more.
  • System Activity. Added user role information to System Activity User explores.
  • Accessing the API. Looker hosted customers can now get to the API on the standard https port. Instead of defining the port like this: https://customer.region.looker.com:19999 we can now navigate to https://customer.api.region.looker.com. Learn more.

LookML and Development

  • :alembic: Remote project import for private repositories. The experimental Project Import feature now supports references to and extensions of private git repositories. Learn more.

  • Explicit LookML field type references. Introduced a new syntax for referencing LookML field types other than the default, for example you can now reference a datetime version of created_date with ${created_date::datetime}. Learn more.

    • :zap: As part of this change, field references to list measures are not supported and will produce errors.
  • The Content Validator is now a fully supported feature.

  • “Don’t Revalidate Unchanged LookML” has also graduated from Labs. Learn more.

  • Hyphens are now allowed in string file names.

  • Improved IDE performance for very large LookML projects.

  • The Content Validator now covers dashboard filters and listeners. Learn more.

  • LookML Constants. Constants are a new parameter that can be defined in a LookML manifest file that can be reused in other parts of LookML. Learn More.

Dialects

  • :zap: Removed the Google Cloud Spanner driver. Self-managed instance must implement a custom JDBC driver.
  • :zap: Removed MSSQL 2005 as an option when creating a new connection. Existing connections with this dialect will be unaffected.
  • :zap: Upgraded Snowflake driver (v3.7.2)

Security

  • Addressed a vulnerability that allowed for access to other users’ scheduled deliveries.
  • Addressed a vulnerability related to the sanitization of SQL Runner downloads.
  • Newly created instance will default to having “Clickjacking Protection” enabled on the Embed Admin page. Existing instances will retain their selected values.

General Tweaks and Bug Fixes

Dialects

  • Fixed an issue where Druid connections on clustered instances would produce Cannot run simple select querysimple SELECT query tests Java::OrgApacheCalciteAvatica::AvaticaClientRuntimeException: Remote driver error: ISE: Connection8b4d9fb4-2383-4aac-92e0-e2b5231aa0e1 already open errors.
  • Fixed an issue where Looker generated invalid SQL for Dremio.
  • Fixed an issue where Looker generated incorrect SQL for relative date filters on Druid.

LookML and Development

  • Fixed an issue where Looker did not escape commas in parameter field values.
  • Fixed an issue that produced “should be localized but has not been” IDE warnings for LookML dashboards when string files are present.
  • Fixed an issue where the LookML Validator failed to run when remote_dependencies did not have url and ref parameters.
  • Informational messages related to localization of LookML dashboards are now grouped in the IDE as “LookML Info Messages”. This addresses a previous issue that treated them as warnings even when permissive localization was enabled.
  • Added a link to the “import credentials” project settings tab when the LookML Validator warns that a dependency lacks credentials.
  • Fixed an issue that resulted in “Document Not Found” messages when selecting “View Document” to see a document outside of the IDE.
  • :alembic: Custom fields no longer unnecessarily trigger Symmetric Aggregates.
  • Fixed an issue where developers could not see certain models connected to local git repositories.
  • Fixed an issue where the Content Validator could group errors by the wrong space. - Fixed an issue where the Content Validator did not flag errors produced by fields being excluded using fields: [] at the join level.
  • Fixed an issue where the LookML Validator failed to detect inaccessible native derived table fields.
  • Added validation to properly protect against duplicative model names issues.
  • :alembic: Fixed an issue where project import would include all view files in a project when it should just include the root with include: "/*.view".
  • Addressed an issue that did not allow a project name change to include hyphens by automatically turning them into underscores. The hyphens are now honored.
  • Addressed an issue that was returning LookML validation errors for filter configurations of a LookML dashboard that was converted from a user-defined dashboard.
  • Addressed an issue that wasn't surfacing the expected LookML validator error when using a measure that referenced a field that was not included in the fields parameter of the explore.
  • Addressed an issue utilizing the liquid _view._name liquid variable in the sql parameter of a derived table returned the LookML validator error " _view is not available in this context."
  • Addressed an issue where a field specified in order_by_field parameter was surfaced in the explore even though it should be excluded by the fields parameter defined in the explore LookML.
  • Added the ability to replace model file names with special characters.
  • Returns an error if a field is utilizing type: time or type: duration and it isn't defined as a dimension group.

Scheduling and Downloading

  • Addressed an issue where a scheduled job would stay stuck in the UI after a restart of the instance.
  • Improved mailer stability by retrying schedules after a timeout period.
  • Fixed an issue that caused jobs to fail when cluster nodes listened on different ports.

Content Management and Discoverability

  • Fixed an issue that prevented enabling a closed system in the presence of orphaned Looks and dashboards.
  • Fixed an issue where the Explore picker drop down could be cut off on small windows.
  • Fixed a closed system issue where non-admin users could lose access to a Space when adding users to it.
  • Addressed issues that could cause broken Look and dashboard thumbnails to appear in Spaces.

Embedded Analytics

  • Fixed an issue where menu items produced 404 errors in the JavaScrip Console.

Platform and Administration

  • Improved the data validation of in API 3.0 and 3.1 so that it will not silently accept (and do nothing with) invalid inputs.
  • Addressed an issue where a markdown homepage wasn't loading when utilizing an IE browser.
  • Addressed an issue regarding PDT rebuilds returning the error: " java.io.IOException: Timed out waiting for copy job to complete"
  • Addressed an issue that was displaying more than two decimal places for data that doesn't have more than two decimal places.
  • Addressed an issue where invalid SQL was being generated due to SQL column names containing capitals in them.
  • Addressed an issue with updating the underlying field of a dashboard filter that comes from a view that is joined with an alias using the from parameter still returns an error via the content validator.
  • Addressed an issue with utilizing a median custom measure returned the following error: "SQL Dialect "redshift" does not support Symmetric Aggregates with percentiles, field ignored."
  • Addressed an issue where the LookML validator was returning an error message, Unknown Access Grant for Model even though the access grant was properly defined in the model.
1 Like