Release Begins: November 10, 2015
Release Final & Download Available: December 3, 2015
See all Release Notes
Visualizations
New Visualization: Interactive Maps. New maps zoom and pan, and are reactive to filter changes. Learn More.
Color Improvements for Charts Learn More
- New series of color palettes that can be used in visualizations.
- New color picker to assist in selecting new chart colors.
- Global default color scheme can be applied across the entire instance. Learn More.
Ability to Sort by Series in Visualizations. Sort the row total in the table to see the information in the chart displayed in order of ascending or descending row totals.
Updated Tooltips for readability.
##Dashboards
Asynchronous Dashboard Loading. Tiles now load as their data returns from the database, instead of 2 at a time, to aid in faster loading of cached dashboards.
More Informative Error Messaging on Dashboards. Dashboard tiles will now display the error that has prevented them from rendering, instead of merely showing that an error has occurred.- Removed the ability to change Dashboards back to “Drag” layout. Newspaper layout is now the preferred layout for all drag & drop dashboards.
##Explore
More Granular Scheduling Options. Includes multiple hours, different days of the month, and on weekdays only.
- Ability to Sort by Row Totals and Table Calculations
In-modal Look Editing. Keeps users on the page that they accessed the modals from for increased context in the app.
Improved Public Link Workflow. It is no longer required to refresh the page to see the associated public links after marking a Look public.
Ability to Issue Queries WithoutORDER BY
Clause. Looker will not generate an Order By clause if the first field in the table is a cancel_grouping_field and there are only dimensions in the query. This can be used to reduce the size and complexity of a query in certain cases.- Improved Suggestions for Filtering
- Suggestions will now properly populate from a view that is defined using the sql_table_name parameter.
- Day of Week and Day of Week Index timeframes now suggests days instead of timestamps.
- See additional changes in the LookML section, including how to make suggestions work with access filters.
- Updates to Filtering for
type: location
Fields - Added radius-based filtering.
- Added support for
null
,not null
and-null
in filtering. The location field is considered null if either lat or long (or both) is null.
LookML
Newquarter
Timeframe. This dimension an be created as part of a dimension group usingquarter
or as a standalone dimension, usingdate_quarter
. Learn More.
Newquarter_of_year
Timeframe. This dimension returns Q1, Q2, Q3, Q4 independent of year and can be created as part of a dimension group or as a standalone dimension. Learn More.
Suggestions for Access Filters. Uses a newfull_suggestions: true
parameter. Learn more.
Configurable Suggestions Caching. Suggestions can now be cached for the time of your choosing. Set these on a per-field basis usingsuggest_persist_for:
followed by a timeframe. If nosuggest_persist_for
is set, the default time remains 6 hours.
Powered By Looker
PDF Downloading for Embedded Dashboards. Permissions are configured in the same way as for regular Looker Users and Roles.
All Download Types for Embedded Elements. Permissions are configured in the same way as for regular Looker Users and Roles.
User Timezones for SSO Embedding. Set the parameter as part of the SSO embed setup process.
##Dialects
Expanded BigQuery Support (read the blog post and the nuance), including:- Query Size Estimator to help manage query usage.
- Nested and repeated data supported natively in LookML using
fanout_on:
parameter. Learn More
- PDTs to optimize querying.
- Job Canceling for queries.
- Generator Improvements, especially for nested and repeated data.
- .p12 Certificates support arbitrary passphrases and are now uploaded via Looker.
Microsoft SQL Data Warehouse Improvements:
- Persistent Derived Tables are now supported.
- Symmetric Aggregates are now supported.
- Hive & Spark: Fixed an error with week truncation.
- Vertica: Fixed for query killing.
##Admin
- PDT Panel in the Admin panel now reflects shared PDTs.
- Added a URL to the modals in the Query panel, so that you can return to the data about those queries.
- Updates to the i__looker model & Usage panel.
- Fixes query most recent run at time.
- Adds most recent run time.
- Make user roles into a list.
- Fix dashboard scheduled task email list (and make sure the dashboard represents the fix).
##General Tweaks & Bug Fixes
Scheduled Email Attachments for the iPhone iOS Mail Application. Fixed a bug that was preventing this functionality.
Added Text Editor Modes. Set the mode on a per-account basis . Options are vim and emac.- Fixed a filtering issue where commas were not properly being escaped.
- Fixed an issue where some LookML errors were not being caught by the validator.
- Fixed a bug in which .iqy files were not carrying value format through to the Excel file.
- Fixed a bug where trying to delete a model with a space in the name caused a 404.
- HTML Sanitization whitelists are no longer configurable. All HTML specified in LookML is stripped of JavaScript tags and attributes, and all other valid HTML tags are allowed.
- Looker now supports using an ‘external’ cipher key that is managed in an external file specified to looker on the commandline.
- This release will also see the introduction of a CDN for our static assets.
- Improved security for javascript files via SRI Integrity matching for browsers that support this new security feature.
##Behavior Changes
LookML Changes that are likely to impact LookML Dashboards created by copying the LookML created by a UDD.- You cannot set floats or integers to “” without an error.
- If a Dashboard’s LookML has the
column_limit:
set to an empty string (""
), thecolumn_limit:
is converted to nil.
Liquid Templating Changes for All Customers: Javascript in Liquid templates will no longer work as of 3.34. Neither<script>
tags or event handlers on elements likeonclick
oronmouseover
will function.