Looker 5.14 Extended Support Release Notes


(Carter Moar) #1

Expected Deployment Dates:

ESR Staging: May 29, 2018 - June 24, 2018
ESR Production Release: June 25, 2018 - September 16, 2018

Release Highlights

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 launch the new release.

For even more detailed release information and to see general tweaks and bug fixes, please see the Release Notes for each Looker version included in the 5.2 ESR:

Notable Features

Content Validator Improvements

The Content Validator is now able to scan for, identify, and fix broken content in Tiles on Lookless Dashboards. Lookless Tiles will now appear in the Content Validator along with regular Looks, and will be included in the “Replace or Remove” process. It is now possible to bulk delete invalid fields.

SQL Runner Changes

In addition to now being able to use ${view_name.SQL_TABLE_NAME} to reference Persistent Derived Tables from SQL Runner, LookML Developers can quick-query the LookML model directly using the new Models tab in SQL Runner. This will save valuable development time when troubleshooting PDTs, testing individual LookML fields, and running one-off queries. Excited to see it in action? Hop over to Next for more ideas about how to use this feature.

Data Privacy Features and GDPR

This release we’re changing the way we do privacy with a new suite of features designed to protect our users’ data and to make it easy for you to do the same. Administrators can now opt in to a “Cookie Notification Banner” to comply with new EU GDPR requirements and edit disabled SSO and LDAP users’ data, ensuring that disabled users’ privacy remains protected. Email subscriptions are now managed in the Preference Center rather than on users’ Account page.

Features by Section

Dashboards and Visualizations

  • :alembic: [Labs] Experimental Custom Fields. New experimental feature allows for on-the-fly field creation without additional LookML modeling. Try it on Next. Learn more about setting up the experimental group.
  • Improved Mapping Functionality and Added New Maps. Including a satellite map, a traffic map, label visibility control, and more.
  • :zap: If you’re running your instance behind a firewall you may need to whitelist mapbox.com, as the maps are no longer pointing to lookecdn.com.
  • :zap: Added error checking to prevent one field from having two or more filters on a dashboard.

Content Management and Discoverability

  • :alembic:[Labs] Save Merged Results to dashboards. Users can now save Merged Results queries to Dashboards. Please note: these elements do not currently interact with Dashboard-level filters. Learn more about configuring Merged Results.
  • Content Validator for Lookless Dashboards. The Content Validator is now able to detect and solve issues in saved tiles on Lookless Dashboards.

Scheduling and Downloading

  • :tools: Dashboard PDFs and Scheduled Visualizations is now enabled by default. In order to have access to rendering options, administrators will need to download the PhantomJS version 2.1.1 on the server hosting the Looker application.
  • :zap: The Legacy API has been completely removed. It is no longer possible to create API-only users or to use the Legacy API.
  • :alembic: Looker API 3.1 API 3.1 endpoints and functionality are now available for experimentation in the interactive Looker API docs. Learn more.
  • Added support for number formatting in Excel. Downloads with number fields no longer appear as strings in Excel.
  • New Scheduler Modal.
  • Increased Email Size Limit. Email size limit has been increased to 15mb.
    • :zap: Fixed a bug where .xlsx schedules were sending empty files if results had not changed since last run. Scheduled content will be sent upon update, regardless of attachment format or whether “results changed since last run” is checked.

LookML and Development

  • :zap: The LookML Validator will now correctly include a warning when ${} field references are included in SQL-based Derived Tables. Note that it is not currently possible to reference LookML fields from a Derived Table; in previous versions Looker had silently ignored the ${} characters if they referred to fields.
  • :zap:The partition_keys parameter now requires quotes around list items. Learn more.
  • Added the ability to create a new Project via the API. The new create_project call allows API users to create a new LookML Project for development in the UI.
  • ${view_name.SQL_TABLE_NAME} is now usable in most sql: parameters. Learn more.
  • Added ability to include custom filters in Native Derived Table definition. New expression_custom_filter parameter allows developers to define custom filters on NDTs in LookML. Learn more.
  • Improved Content Validator. replace and remove functions are now more clearly distinct and Content Validator now replaces field names in visualization config settings.
  • Bulk delete from Content Validator. It is now possible to dispose of many Looks at once when grouping validator errors by Look. Learn more.
  • Git branch deletion. Introduced the ability to delete shared Git branches.
  • Reference LookML Objects in SQL Runner. ${view_name.field_name} and {view_name.SQL_TABLE_NAME} can now be referenced from SQL Runner.
  • Git Garbage Collection. Looker will now periodically perform garbage collection on all project repositories via git gc. This will speed up most Git operations done within Looker, especially in larger projects.

Platform and Administration

  • :zap: Email Subscription Changes. Removed all email subscription options from user menus. Users will now be able to manage their subscription preferences in the Preference Center linked in their Account Page.
  • Introducing schedule list by user. Users are now able to see and navigate their saved schedules all in one place.
  • Added allowed_clock_drift support for SAML configurations. Learn more.
  • PDT-specific database credentials. You can now assign PDT processes credentials, allowing you to prioritize builds, send builds to different Snowflake warehouses, and reduce users’ write access. Learn more.
  • Cookies Notification Banner. Added a toggle in the Admin menu to include a cookies notification banner to all users on a Looker instance.
  • Edit Disabled LDAP and SSO users. Introduced functionality allowing administrators to edit disabled LDAP and SSO users.
  • Updated Cached Data Retention Policy. Looker has significantly reduced the time to clean up cached encrypted query results when the Instant Dashboards Labs feature is not enabled.


  • Restricted the ability to use a user-editable user attribute towards parameterized database connections.
  • Tightened access to application database.
  • Removed an XSS vulnerability on the admin/connections/.../edit page.
  • Addressed a SAML authentication bypass vulnerability.


  • Added Dremio support.
  • Updated Snowflake support to include IN statements where appropriate.
  • :zap: Data Virtuality drivers are no longer bundled with the Looker .jar. Self-hosted customers will have to add a driver to their Looker machine. Learn more.