Looker 2.4 2014-07-14

LookML / Projects

• New field parameter format: for printf-style formatting

Explore

• Totals working in all dialects, implemented as a separate SQL query

Data Visualization

• New element parameter show_applied_filters: false to turn off dynamic filters in title of a dashboard element
• New dashboard parameter refresh: N minutes to refresh data every N minutes if the page is open

Enterprise, Platform, and Security

• LDAP authentication
• Two-factor authentication

Bug Fixes and Tweaks

• Add/delete projects moved to admin panel

Looker 2.2 2014-06-09

Data Visualization

• Custom map visualizations
• Dimensional scatter plot
• Automatic x_axis_scale detection
• x_padding_left and x_padding_right option for charts
• Specify colors, series_colors, series_labels, reference lines, and more in looker_type charts
• Plot geo coordinates (lat/long) on world map

LookML / Projects

• Redesigned Projects experience
• LookML project search with regular expressions & find and replace
• JGit bundled with Looker (replaces server-based git)
• Liquid templating (replaces ERB)
• More flexible join syntax
• Top nav menus update upon LookML file save (instead of after page reload)
• Declare a base_view as hidden: true
• Table Calculations: type: running_total
• Line-by-line git diffs in LookML editor (yellow for modified, green for added, red for deleted)

Explore

• Jump to LookML error link from Explore page
• Improved and more flexible number filter syntax (e.g. >, <, != operators)
• SQL Runner moved to Explore menu
• SQL tab updates live as query is constructed in UI (with EXPLAIN)

Enterprise, Platform, and Security

• Improved admin audit and Looker usage panels
• Embeddable iframe code added to public URL box

Bug Fixes and Tweaks

• Lots of looker_ (area, column, etc.) and reference line bug fixes. Thanks to the beta testers!
• Improved login and auto logout flow
• Convert “yyyymmdd” format to valid time field
• Year filters now use date syntax (instead of integer)
• Dozens of other bug fixes and tweaks!

Looker 2.0 2014-04-28

Data Visualization (Beta)

• Maps (US & World) chart types: Coordinates Plot, Choropleth
• New Cartesian chart types: Single Record, Donut, Donut Multiples
• Updated Cartesian chart types: looker_column, looker_line, looker_area, looker_pie
• Reference Lines: static, median, mean, min, max, ranges, standard deviation, variance
• Additional formatting parameters (interpolation, colors, hide_points, hide_legend)
• Automatically detect and format date axes

LookML

• Developer vs. Production Mode SQL option in PDTs
• Field name validation before query run
• Generate files as .model.lookml, .view.lookml, .dashboard.lookml
• When on, user access filters block filter suggestions
• select_filter aliased to suggest_filter in dashboard filters

Enterprise and Security

• Auto user log out (with warning) unless trusted computer

SQL Dialects

• Support for Teradata Aster 6.0
• (Beta) Support for Oracle Database 11g

Bug Fixes and Tweaks

• Persistent derived table fixes
• Drilling into a dashboard chart keeps filters applied
• Timezone conversion in Redshift
• Warn when changing timezone that it affects all users
• Show conditional filters in dashboard URL
• Return 401 error as JSON API responses when authentication fails
• Add link to SQL Runner from connections page
• MS SQL Server suggest fix