Looker 6.0 Extended Support Release Notes


(hilary) #1

Anticipated Deployment Dates

ESR Staging: November 12, 2018 - December 10, 2018
ESR Production Release: December 10, 2018 - March 4, 2018

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.

System Configuration Notices

Take note of items marked with a :tools: as they indicate changes to system configurations that may impact your ability to run the new release.

Notable Features

Refactored Cartesian Charts

A new visualization engine provides for bubble charts, greater flexibility when mixing series types, and smarter defaults for cartesian charts. It also lays the foundation for future developments. The visualization framework is generally available now, but could previously be enabled using the “Enhanced Visualizations” Labs feature.

New LookML Parameters


Control data access at the field, explore, join, and view level based on user attributes with the new access_grant parameter.



Using two timestamp fields, quickly and flexibly calculate duration with the new duration dimension group. Like the time dimension group, this parameter accepts the intervals field that allows Looker developers to specify the units that matter to their model.


Merged Results Improvements

Looker users now experience even more front-end flexibility with Merged Results on experimental Custom Fields. Merged results are also now available in embedded iframes for Powered By Looker users, and as CSV download.

Features by Section

Scheduling and Downloading

  • Download Merged Results as CSVs. It is now possible to download Dashboards containing merged results queries as CSVs.

LookML and Development

  • access_grant parameter. LookML developers can use new LookML parameters to adjust data access at the view, join, explore, and field levels.
  • New duration type dimension group. Learn more.
  • :zap: Completely removed the “Allow the access_filter_fields parameter” Legacy Feature. User Attribute-based access filters are now the only method for row-level data security. Learn more.
  • :zap: Disabled the “Native Derivied Tables Convert Dates and Yesnos to Strings” Legacy Feature. It may be temporarily reenabled on the Legacy Features page if needed to help your transition. Learn more.
  • :alembic: New API endpoints for git management. The experimental API 3.1 now contains the following endpoints: all_git_branches, git_branch, create_git, update_git, find_git_branch, delete_git_branch
  • Code Quality Options. Added a third level of Code Quality requirements. Looker Admins can now allow developers to commit LookML code with Warnings but not Errors in the LookML validator. Learn more.
  • Git setup performance enhancements. Back end enhancements to the git setup process make git integration faster and more performant.

Dashboards and Visualizations

  • Improved Color Picker. New color palette selection tool in visualizations menu. Learn more.
  • :zap: Enhanced Visualizations. Enhanced visualizations have moved out of Beta and will now be available to all Looker customers. Legacy Visualizations are available as a legacy feature in the Admin panel. Learn more.
  • New Markdown Toolbar for Dashboard text tile creation. Learn more.
  • Merged Results improvements:
    • :alembic: Experimental custom fields can now be used in Merged Results.
    • Merged Results are now available in embedded dashboards.
  • :alembic: Beta Enhanced Renderer. Introduced Enhanced Rendering designed to be used in conjunction with the beta Enhanced Visualizations feature. Learn more about customer-hosted setup.


  • BigQuery Standard SQL. Added support for DATETIME and NUMERIC data types.
  • Athena. Updated to Athena driver 2.0.5 and introduced support for arrays in Athena.

General Tweaks and Bug Fixes

  • Content Management and Discoverability

    • Fixed a bug where embed users could not navigate backward when saving a Look.
    • Fixed a bug where restoring a Dashboard from the Trash did not also restore Looks.
    • Fixed a bug where the spaces sidebar was not scrolling properly.
    • Added breadcrumbs to the spaces page.
  • Action Hub

    • :zap: Made some small UI changes to the Admin Menu for the Looker Action Hub
  • Dashboards, Visualizations, and Explore

    • Looks are now edited in the page instead of in an additional “edit” modal.
    • :alembic:Custom Visualizations are available to all Looker instances in the Labs panel. Learn more.
    • Fixed a bug where reference lines didn’t behave as expected with stacked percentage charts.
    • Fixed a bug where log scale y-axes lacked margins.
    • Mixed series types now automatically layer for visibility.
    • Fixed a bug where stacked charts legend order did not match visualizations.
    • :zap: Reference lines now compute standard deviations based on population calculations rather than sample ones.
    • Fixed a bug where long-running queries prevented dashboards from loading.
    • Fixed a bug where using custom fields on merged results queries hid the “Explore From Here” button.
    • Fixed a bug where some dashboard tiles showed the following error: Unexpected token � in JSON at position 14.
  • Scheduling and Downloading

    • Fixed a bug where scheduling an excel file sometimes produced an error.
    • Fixed a bug where text visualizations did not render correctly when sent to email as a .png.
    • Fixed a bug where schedules occasionally failed due to node communication errors.
    • Fixed a bug where filters on fields that had been removed caused scheduler UI to break.
    • Fixed a bug where some schedules to S3 buckets were failing.
  • Platform and Administration

    • :tools: Looker 6.0 requires Java 1.8 update 161+. Learn more.
    • Fixed a bug where the timezone picker did not change in embedded explores.
    • Fixed a bug causing some general instance performance issues for Powered By Looker Instances.
  • LookML and Development

    • Improved error messaging around references to unset user attributes.
    • Stopped generating superfluous joins for empty filters.
    • Addressed an issue where switching between files in the IDE was sluggish.
    • Fixed a bug where some distance dimensions incorrectly calculated a distance of 0.00.
    • Unnecessary include statements are now generated commented in view files.
    • :alembic: Fixed a bug where the Content Validator sometimes reloads with boxes checked.
    • :zap: Fixed a bug where custom dimensions could be used to query filter-only fields. Looks and dashboards with these fields may cause an error message.
    • Fixed a bug where always_join was not used in suggestions query.
  • Dialects

    • Fixed a bug where number type dimensions did not recognize the decimal data type in Athena.
    • The LookML generator now double-quotes column references in IBM Db2.
  • Security

    • Fixed a security issue where users could potentially change ownership of other users’ dashboards.
    • Removed stack trace exposure in the event of low-level errors.