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.
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.
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:
- Single row headers in downloaded tables
- JSON numbers returned as strings
- Unscoped field name aliases
Details on how to migrate off these features can be found here.
Additional Features by Section
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.
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.
- 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_schedulespermission allows access to the scheduled plan and the scheduler history panels. Learn more.
Improved Layout for Pivoted Downloads. Downloaded
.xlsxfiles 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
scopingparameter. Learn more
- Fixed an issue where Symmetric Aggregates could be incorrectly calculated in the presence of negative numbers.
- Improved the efficiency of the
- Improved the behavior of measures in
- Added information about whether PDTs are functioning.
- Hive version 1.2 is the minimum supported version (rather than Hive version 0.13).
- Hive now uses
LIKEinstead of regular expressions for string filtering.
- Looker now uses HiveQL 1.2 instead of HiveQL 0.13 syntax.
- Incorporated the standard Presto JDBC driver (version 0.149). Learn more.
- 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: numberfields as numbers rather than strings. Learn more.
- Replaced the
create_query_and_run_asyncroutes. API users should transition to the
- 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”.