Looker 5.16 Release Notes

release

(Carter Moar) #1

Anticipated Deployment Dates

Release Rollout Begins: June 3, 2018
Release Final & Download Available: June 14, 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.


Notable Features

Looker Action Hub

Automate your data workflows with new Actions for Marketo and Google Cloud Storage, as well as new functionality for some existing integrations. Learn more about how to leverage the Action Hub to streamline your data here.

Features by Section

Action Hub

  • Introduced Actions for Marketo. Learn more.
  • Introduced Actions for Google Cloud Storage. Learn more.
  • Introduced new Segment, Amazon S3, and Digital Ocean Storage functionality. Learn more.

Scheduling and Downloading

  • Added JSON Detail Streaming Support. It is now possible to stream content as JSON, allowing for delivery of larger result sets.

LookML and Development

  • Refreshed the Manage Projects page to make it easier to add and configure LookML projects.
  • :zap: The Delete Project button is now accessible through the LookML Project Settings menu rather than Manage Projects.
  • :zap:Introduced a LookML validator warning when a field name and an alias name have the potential to cause a collision.
  • Added the ability to create a read-only clone of a project from a public repository. Learn more.

Security

  • Fixed an issue that could result in unencrypted files written to a tmp directory in cases of very large Excel exports. Access to these files required system-level access to the Looker host which is logged and monitored, and limited to specific Looker personnel.
  • :zap: Users are no longer able to edit Looks and Dashboard Tiles that are based on models they do not have the explore permission for.
  • Fixed potential HTML injection vulnerabilities in experimental Login Page Message, group name as rendered in Recent Activity page, and certain User Attributes fields in the admin panel.
  • Fixed Reverse Tabnapping Vulnerability with anchor tags in fields where markdown is permitted.

Dialects

  • Microsoft Azure PostgreSQL. Introduced support for Microsoft Azure PostgreSQL.
  • Google BigQuery Standard SQL. Improved performance and ability to scale of queries using Symmetric Aggregates.
  • Snowflake. Enhanced the LookML generator to better preserve character casing and properly identify all timestamp types.
  • :zap: Teradata. The Looker .jar no longer includes the Teradata driver. Self-hosted customers will have to add a driver to their Looker machine. Learn more.
  • Improved month name SQL implementation for Hive and Spark to be less verbose and more performant.

Content Management and Discoverability

  • Improvements to the way content is displayed in Spaces.
  • :zap:Looks and Dashboards display as thumbnails in Spaces. Learn more.
  • Copy, edit, delete, and re-name content from thumbnails.
  • View Content metadata in Spaces

General Tweaks and Bug Fixes

  • Dashboards, Visualizations, and Explore
    • :alembic: [Labs] Added measure type: sum to experimental custom fields.
    • :alembic: [Labs] Fixed a bug with autocomplete functionality in custom fields.
    • Fixed a bug where the run button was hidden in iframes where filter values contained too many characters.
    • Fixed an issue where all_dashboards API call returned deleted dashboards.
    • Fixed a bug where Table Calculations and Custom Fields did not work with aliased fields.
  • Scheduling and Downloading
    • :alembic: [Labs] Added additional endpoints to API 3.1
  • Platform and Administration
    • Improved Log diagnostic info in cases where Google Auth fails.
    • Fixed a bug where the run button was missing from the admin usage page.
    • Fixed a bug where incompatible text lengths in internal database sometimes resulted in data truncation.

Looker Actions - Google Cloud Storage
(Carter Moar) #2

(Ian) #3

Does this release include the updated sym agg for bigquery (using the new data type) as talked about here: Symmetric Aggregate Performance in BigQuery


(Carter Moar) #4

Yes it does! Sorry we glossed over that one.


(Ian) #5

you sure? the sym agg calculations are still looking the same as before


(Ian) #6

apologies, just realised this is the newest unreleased version and not the one we have just upgraded to!


(Nicolaas) #7

Really happy with the Marketo action! Does it use the Bulk API or Rest API under the hood? I.e. can we use it to send large lists of people (say 10-20k) from Looker to Marketo?


(Carter Moar) #8

It’s currently based on the rest API and is subject to the standard in-Looker row limit (5,000 rows). We are actively working on the ability to stream results, which would open up those large lists but it’s not quite ready yet. I’m eagerly awaiting it too!


(Nicolaas) #9

Thanks for the info, Carter. Look forward to that the streaming functionality!


(Kumaran Raghunathan) #10

Could you please provide more insights on the SQL dialect improvement for Snowflake. “**Enhanced the LookML generator to better preserve character casing and properly identify all timestamp types”. What types of improvement does it really make.


(Carter Moar) #11

When creating new views based on Snowflake tables, the LookML generator wouldn’t automatically create dimensions with the right type for timestamp data (it used type: string). It also didn’t handle columns that required double quotes super well.

You could always work around these since it’s just a matter of LookML generation, but these improvements definitely make life easier.


(Alison) #12

Could you please provide more detail for this bullet point? Thanks in advance.


(Kumaran Raghunathan) #13

Thanks for the details Cutler.