Looker 3.34 Release Notes

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 Without ORDER 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

• 
  New quarter Timeframe. This dimension an be created as part of a dimension group using quarter or as a standalone dimension, using date_quarter. Learn More.
  


• 
  New quarter_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 new full_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 using suggest_persist_for: followed by a timeframe. If no suggest_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 (""), the column_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 like onclick or onmouseover will function.