Looker 4.14 Release Notes

release

(Carter Moar) #1

Currently Scheduled Deployment Dates

Release Rollout Begins: May 14, 2017
Release Final & Download Available: May 25, 2017


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.

  • Dashboards, Visualizations, and Explore
  • Looker Platform and Administration
  • LookML and Development Environment
  • Dialects

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 the Legacy Feature Updates and Features by Section below.

  • Content Access is now entirely governed by Space Access Controls.
  • Introduced the “Allow unlimited downloads that might crash Looker” Legacy Feature.
  • Replaced the individual Create Model, Create Dashboard, Create Document, etc. options with a single Add Files menu in the LookML development environment.

Notable Features

Single-Value Dashboard Filters

Sometimes it doesn’t make sense to filter on multiple values; your city lookup Dashboard will look pretty crazy if you filter on New York and Santa Cruz. With Dashboard filter customizations you can set a filter to allow just one value, forcing a match to a user-entered value or a User Attribute. Learn more.

A Simplified System for Content Access

Introducing a streamlined set of content access rules, designed to make it easier to manage users’ experiences and exposure to Looks and Dashboards. No need to sort through a web of model access, user permissions, and Space controls to determine what your users can see; simply use Space Access Controls to govern what folks can see.

Timeline Visualizations

Wondering when your users were active? How about what hours you’ve got support covered or when your warehouse staff is scheduled? The new Timeline visualization might be the choice for you! Learn more.


Features by Section

Dashboards, Visualizations, and Explore

  • Introduced the Timeline visualization. Learn more.
  • A field’s description will now appear in a tooltip when hovering over the column header on Dashboards, Looks, or in Explore. Learn more.
  • The explores in the Explore menu can now be organized using the group_label LookML parameter. Learn more.
  • Dashboard filters can now be configured to accept just a single filter value. Learn more.
  • Added an option to the vector_tile_region map layer to allow for the outlining of regions without data. Learn more.

Looker Platform and Administration

  • :zap: Content Access is now entirely governed by Space Access Controls. Learn more
  • :zap: Introduced the “Allow unlimited downloads that might crash Looker” Legacy Feature. Learn more.
  • New API endpoints:
  • Introduced API endpoints for reading project information.
  • Added an API endpoint for LookML validation.
  • You can now filter tables on the Persistent Derived Tables Admin panel. Learn more.
  • Looker will now pull avatars from Google if you’re using Google Auth.
  • Renamed the Edit Look Settings gear menu option to Edit Settings.

LookML and Development Environment

  • The LookML generator will now create dimensions of type: zipcode.
  • :zap: Replaced the individual Create Model, Create Dashboard, Create Document, etc. options with a single Add Files menu in the LookML development environment. Learn more.
  • Removed the striped gradient from the Development Mode banner.

Dialects

  • Amazon Spectrum. Added support for Amazon Spectrum. Learn more.

General Tweaks and Bug Fixes

  • Fixed a couple of issues related to labels and pie charts.
  • Fixed an issue where selecting Filter from the data table didn’t open the filter panel.
  • Fixed an issue where all_scheduled_plans() did not return scheduled plans.
  • Fixed some table alignment issues when row totals are present but dimensions and row numbers are not.
  • Fixed an issue where creating a view from a table could overwrite an existing view if it had the same name.
  • Addressed some issues related to manually defining vector_tile_region map layers.
  • Tweaked Look and Dashboard pages to improve header text alignment.

(Carter Moar) #2

(Yuriy) #3

Hi Carter,

I’ve tried to access the Spaces with Content from Multiple Models Look.
I get the following error:

The MySQL database encountered an error while running this query.
temp derived_table space_model_look_facts creation failed: SQL Error in CREATE TABLE as SELECT: java.sql.SQLSyntaxErrorException: Access denied for user 'looker_db_user'@'%' to database 'looker_tmp'

We do not have looker_tmp database created. Is this something that we were supposed to create and grant permissions prior to upgrade?

Thanks


(erin.alexander) #4

For updates and features covered in documentation, I have added “Learn More” links to the page and section in our customer documentation pages.


(Carter Moar) #5

@yuriy, it sounds like your instance is running with a MySQL application database rather than the default HyperSQL. The Spaces with Content from Multiple Models Look relies on some views built off of ephemeral (not persistent) derived tables. In MySQL, Looker will write these derived tables using temporary tables (since MySQL lacks the notion of CTEs–common table expressions).

It could be the case that when setting up the MySQL database a temporary schema was not created, or the database user was never given access to it. If everything goes according to plan, I believe that the below excerpt from this article should provision such access.

Create a database and user

Create a user and db on the database instance. Replace DBUSERNAME, DATABASENAME, and ‘DBPASSWORD’ with the actual values for the user and db.

CREATE USER DBUSERNAME;
SET PASSWORD FOR DBUSERNAME = PASSWORD ('DBPASSWORD');

create database DATABASENAME DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
grant all on DATABASENAME.* to DBUSERNAME@'%';
grant all on looker_tmp.* to 'DBUSERNAME'@'%';