Looker 3.52 Release Notes

release

(Carter Moar) #1

Release Rollout Begins: July 31, 2016
Release Final & Download Available: August 18, 2016

Preparing for Release

Please take notice of items marked with a as they indicate changes to existing functionality and may require your attention.


Notable Features

Redesigned Navigation Bar

Navigation has been simplified to focus on three main activities: browsing content, exploring data, and developing. The new navigation bar frees up horizontal space and comes with a greatly expanded Help section–you can now jump directly to our official documentation and Looker Discourse, view information related to your Looker release, and search docs and Discourse all from one place.

Series Editor

Cartesian charts now sport a Series tab, which replaces the Style tab’s key-value pair method for changing the color, label, and type of each series on a visualization.

Legacy Feature Updates

The following 3 features have been deprecated and will only be available by enabling the associated legacy feature:

Details on how to migrate off these features can be found here.


Additional Features by Section

Looker Design

Redesigned Navigation Bar

  • Widened available working canvas to expand real estate for working with tables and visualizations and accommodate landscape viewing on additional devices.
  • Simplified navigation by removing icons and focusing organization on user actions. Learn more. The navigation includes:
  • Browse: Have a look at existing content; start from existing Looks and dashboards
  • Explore: Start a new query
  • Develop: Enter the LookML editor, the SQL Runner, and turn development mode on/off
  • Increased the available Help and reorganized the menu. Learn more The help menu includes:
  • Search for Docs and Discourse
  • Links to official Documentation and Looker Discourse
  • Information about the current Looker release (including release notes and number)
  • Chat support with Looker’s Department of Customer Love (only available to developers and instance admins)

Menu cleanup. Tweaked a number of menus and lists in order to facilitate navigation and unify design.

  • Alphabetized a number of lists including Roles, Connections, and Explores in the dashboard Filters modal.
  • Left aligned gear menu items and appended “…” to options that launch another modal.

Visualizations

Series Tab in Visualization Editor

The Series tab that introduces an improved interface for editing the color, name, and type of a series. Everything that had been modified using key-value pairs in the Style tab’s free text boxes can be found in the Series tab, which has replaced the Style tab for cartesian charts.

Learn more: Column charts / Bar charts / Scatter charts / Line charts / Area charts

Explore

  • Data tables now display column totals when row limit is reached. Learn more
  • Explore descriptions are now displayed in the Explore drop down on the top navigation bar.

Scheduling & Downloading

  • Stand-alone Permission to View Scheduled Information. The see_schedules permission allows access to the scheduled plan and the scheduler history panels. Learn more.
  • Improved Layout for Pivoted Downloads. Downloaded .csv, .html, .md, .txt, and .xlsx files now display one row per pivoted dimension to more closely match the display in Looker. If you have processes that rely on a single header row, please make use of the “Single Row Table Headers” legacy feature. Learn more.
  • Clarified the error that users receive when Looker is unable to render PDFs due to PhantomJS not being installed.
  • Clarified the error that users receive if they are a recipient of a scheduled plan made by a user who has been deleted or disabled.

LookML & Development Environment

  • Autogenerated Context as SQL Comments for PDTs. When generating PDTs, Looker will issue a comment to indicate the model, view, ID of the user generating the table (if available), whether or not the user is in developer mode, and the instance slug. Learn more
  • Updated the Look Validator to improve design and include the ability to replace the name of fields, views, explores, and models regardless of the error. Learn more
  • Fast File Switching. The LookML development IDE now instantly switches between files and does not require a full page reload.
  • Truncated SQL Runner Table List. The SQL Runner limits the table preview list to 500 to browser limit impact.
  • Completely removed the scoping parameter. Learn more

Dialects

  • BigQuery:
  • Fixed an issue where Symmetric Aggregates could be incorrectly calculated in the presence of negative numbers.
  • Improved the efficiency of the week timeframe.
  • Improved the behavior of measures in fanout_on fields.
  • Snowflake:
  • Added information about whether PDTs are functioning.
  • Hive:
    • Hive version 1.2 is the minimum supported version (rather than Hive version 0.13).
    • Hive now uses LIKE instead of regular expressions for string filtering.
  • Spark:
  • Looker now uses HiveQL 1.2 instead of HiveQL 0.13 syntax.
  • Presto:
  • Incorporated the standard Presto JDBC driver (version 0.149). Learn more.
  • DataVirtuality:
  • Added an SSL option in Looker’s connection panel.
  • Fixed an issue where DataVirtuality didn’t properly load error messages.
  • MS SQL:
  • Updated the JDBC driver to v4.2. Note that SQL Server 2005 will no longer be supported.

General Tweaks and Bug Fixes

  • API (beta) Changes:
  • Ensured that JSON format will return the values of type: number fields as numbers rather than strings. Learn more.
  • Replaced the run_async and create_query_and_run_async routes. API users should transition to the create_query_task route.
  • Performance and Stability Tweaks:
  • Improved performance when fetching cached results.
  • Reduced memory usage when reading from and writing to the query cache.
  • Changed the way Looker connects to internal MySQL databases to make the connection more robust.
  • Visualization Bug Fixes:
  • Fixed an issue where maps did not work with hidden columns when table calculations were present and all measures were hidden.
  • Fixed an issue where right padding on charts could be misaligned.
  • Fixed an issue where the value format of table calculations did not appear on the y-axis of a visualization.
  • Fixed an issue where time label format would only work with a label rotation value.
  • Fixed an issue where visualizations would render empty if a min or max y-axis value was used with a log scale type.
  • Fixed an issue where a chart warning could push the x-axis out of view.
  • Addressed an issue where different Looker systems could process and sort results in different orders across various areas (dashboards, Explores, downloads, etc.).
  • Fixed an issue where the visual indication that a filter input box was looking for suggestions failed to appear or continue to disappeared while running.
  • Fixed an issue where labels were inconsistently truncated on PDF downloads.
  • Text tiles on LookML Dashboards no longer produce “Element must specify an explore” warnings.
  • Fixed an issue where gear menus from fields in tables would overlay empty state messages on the data table.
  • Fixed an issue where the default value for a dashboard filter was not properly integrating with other filters if set up to do so.
  • Fixed an Issue where embedded dashboards could return empty results on the first run.
  • Fixed an issue where custom filters using yesno dimensions could incorrect SQL.
  • Fixed a bug where extended explores incorrectly returned the error “ignore unexpected list of fields in explore”.

Using Series Types to Create Mixed Type Visualizations (3.18+)
How to refer to a series in series types, series colors, and series labels (Pre- Looker 3.52)
(Josh Siegel) #2


(Carter Moar) #4

(Phil Jones) #5

I’m not seeing the series editor on my instance - do I need to do something specific to enable it?


(Frank Kutzey) #6

Hi,

same for me (on-premise)


(Zachary Michel) #7

@phl.jns and @sisu_frank_kutzey I’ll be emailing you both directly.


#8

Is there a bug with Visualizations/Edit/PointStyle? The three options are:

Circle (filled)
Circle (outline)
Circle (outline)


(Ken Cunanan) #9

@krisatHT, can you attempt to update the license in Admin > General? If updating the license fails to work, would you be able to email support@looker.com? We’re currently tracking this issue.

Thanks, and have a great rest of your day!

Best,
Ken


(Ken Cunanan) #10

@krisatHT, we actually went ahead and updated your license for your on your instance, and it seemed to completely resolve the issue. Should you see this issue again, please don’t hesitate to email support@looker.com!


(Carter Moar) #11

(Vincent Lam) #12

Where can I download the Looker jar ?


(Carter Moar) #13

@lam, if we host your instance, you will not need to download the jar; we’ll automatically deploy the newest release to your instance at the scheduled time (you should also receive an email if you fall into one of these categories of individuals who receive release emails.

According to my records, it looks like we host your instance and you’re currently running Looker 3.52.


(Vincent Lam) #14

I understand that we’re using your servers at the moment, but we frequently experience performance issues, even after a few upgrades. So we would like to explore the option of the on-premise solution.


(Carter Moar) #15

@lam, since this is an issue that relates to the specifics of your setup, it’s possible that your instance might require some configuration tweaks. I’ve spoken with your customer success manager, who will be reaching out shortly.

In general, we can respond most rapidly to matters related to instance specifics if you reach out to support@looker.com or directly to your customer success manager.