home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Looker 7 Release Highlights

Looker 7.12

play_circle_filled
Expected
Rollout
Start
Sunday
July 19th
2020
check_circle
Expected
Final Release and
Download Available
Thursday
July 30th
2020

Breaking Changes

Check out these breaking changes introduced in Looker 7.12:
  • A new design for the LookML IDE is available to all users with access to LookML projects. The object browser is no longer a Labs feature; it is now out of beta and generally available. The IDE Folders Toggle legacy feature is now fully removed, and the legacy IDE can no longer be enabled.
  • The .strings files for localization legacy feature is now fully removed and unavailable to re-enable.
  • The SnowFlake Unquoted Database legacy feature is disabled by default. Snowflake connections that have incorrect capitalization in the database name will break.
  • The LookML Validator will now render a warning if there are multiple entries of the following: derived_table parameters within a view file, query parameters inside an aggregate table within a defined explore parameter, or materialization parameters within an aggregate_table within a defined explore parameter.
  • The LookML Validator will now issue a warning for aggregate table names greater than 255 characters. In addition, the aggregate table LookML generator will no longer generate names longer than the maximum allowed characters.
  • The table visualization setting Bars is now called Cell Visualization.
  • CSV downloads now allow non-romanized characters in the file name. This may impact automation that relies on the file name being empty for files named with non-romanized characters.
  • The password reset function will lock after too many failed login attempts. The lockout duration is 5 minutes for most customers after 4 failures and 30 minutes for PCI instances after 6 failures.

Redesigned IDE

Check out the new IDE in your LookML projects.
  • The new UI design of the LookML IDE is available to all users with access to LookML projects.
  • You can now navigate projects with the object browser without having to enable a Labs feature.

Upgraded Explore Field Picker

Introducing a redesigned Explore UI through the Upgraded Explore Field Picker Labs feature.

The Looker Extension Framework (Beta)

Introducing the Looker extension framework, available with the Extension Framework Labs feature, which is enabled by default.
  • This feature allows developers to build custom JavaScript applications and tools on top of Looker without requiring them to set up their own stacks for building.
  • Applications can be used in Looker or embedded in other applications.

Looker 7.10

play_circle_filled
Expected
Rollout
Start
Sunday
June 14th
2020
check_circle
Expected
Final Release and
Download Available
Monday
June 29th
2020

Looker API CORS

A new experimental Labs feature that permits browser-based applications to directly call the Looker API without needing a proxy server for the API calls.

Dashboards (Beta): Filter Themes

Introducing the ability to customize embed filter colors.

Dashboards (Beta): Enhancements

Introducing new menu options on dashboard (beta) tiles and the ability to retrieve dashboard LookML from dashboards (beta).
  • Tile menus on dashboards (beta) now present the options to Clear Cache & Refresh and View Look. Note: The View Look option is only presented on tiles that are derived from existing Looks.
  • You can now copy the LookML from a dashboard (beta) by clicking Get LookML from the dashboard menu.
  • LookML dashboards can now be configured to use filter controls available in dashboards (beta). The LookML for user-defined dashboards with filters configured using dashboards (beta) contain a ui_config parameter for each filter.

Database Connection Pooling

A new beta Labs feature that can improve query performance and support more concurrent users for supported database dialects.
  • A new beta Database Connection Pooling Labs feature is now available for Redshift, Postgres, and Snowflake SQL dialects.
  • Enabling this Labs feature optimizes database connection reuse via the JDBC driver.

Looker 7.8

play_circle_filled
Expected
Rollout
Start
Sunday
May 17th
2020
check_circle
Expected
Final Release and
Download Available
Thursday
May 28th
2020

Aggregate Awareness

Looker will detect and run a query against the most efficient aggregate table in your database.
  • Aggregate awareness increases database query performance and decreases costs by allowing you to define aggregate tables in LookML.
  • Aggregate tables are roll-ups of more granular data tables.
  • Looker automatically queries the aggregate tables instead of the larger, more granular tables whenever possible.

Parallel Persistent Derived Table Builds

Multiple PDTs can now be built at once.
  • Increases the number of PDTs that can be built at one time per connection.
  • The default concurrency is set to 1. The concurrency can be increased in the Max PDT Builder Connections field for a connection’s settings.

Data Dictionary

The Data Dictionary extension is now available in the Looker Marketplace and can be enabled by switching on the Extension Framework, Marketplace, and Local Project Import Labs features.
  • The Data Dictionary is a centralized source for the field definitions of a selected model and Explore.
  • A field profiler displays information about a specific field and previews its top values.
  • Quick filters help users find the descriptions and field types they need.
  • The Data Dictionary retains Looker’s permissions structure — users can see only the models they have access to.

New Marketplace Content

New and modified content is now available in the Looker Marketplace.
  • A new data block launched in the Marketplace called Covid-19. It has a pre-built data model and dashboards built around public COVID-19 data from the New York Times and Johns Hopkins.
  • A new Radial Gauge visualization offers customizable ranges, target values, and formatting.
  • A new Braintree block by Looker helps you better understand your business’ transaction data.

Looker 7.6

play_circle_filled
Expected
Rollout
Start
Sunday
April 19th
2020
check_circle
Expected
Final Release and
Download Available
Thursday
April 29th
2020

Persistent Derived Table Admin Page Improvements

Improved searchability, page performance, and monitoring on the Persistent Derived Tables page in the Admin panel.

LookML Refinements

Introducing LookML refinements that allow users to build on the LookML of views and Explores in projects.
  • LookML refinements provide users a way to build on the LookML of views and Explores in your projects.
  • LookML refinements are ideal for projects with Looker Blocks, which use pre-built pieces of LookML; projects that import files from other projects; projects where you often need to generate your files from tables in your database; and situations where you want to share LookML between models or projects while making customizations in each place (that is, hub-and-spoke configurations).

Removing the Automatic S3 Backup (Customer-Hosted Instances Only)

Automatic S3 backup will no longer be available for customer-hosted instances.
  • Looker highly recommends hosting your own backup.
  • This is recommended as a daily practice to ensure that your Looker content and configurations are continuously saved.

Alerts User Management Page

Introduced a new page for users to manage their alerts.

Users can view and manage their alerts through an alerts user management page available from their user profile.

Looker 7.4

play_circle_filled
Expected
Rollout
Start
Sunday
March 15th
2020
check_circle
Expected
Final Release and
Download Available
Thursday
March 26th
2020

Dashboards (Beta) Updates

Introducing new functionalities on dashboards (beta).
  • Dashboards can now be downloaded in PDF and CSV formats. Note: PDF will still render the old dashboard design.
  • A tile’s content can be downloaded in these formats: TXT, Excel, CSV, JSON, HTML, Markdown, and PNG.
  • A grid layout option is now supported.
  • Merged results are now filterable and fully supported.

New LookML Syntax

Introducing new filters and order_by_field syntax.
  • New filters syntax is more concise and simpler to write. The square brackets denote an array with key-value pairs.
  • Measures can now be sorted by other measures in the order_by_field parameter.

Slack Integration Updates

Introducing the ability to add multiple Slack workspaces and Looker homepage in Slack.

Marketplace Content

More blocks and visualizations are now available in the Looker Marketplace.

Added the following blocks:

  • Salesforce
  • Hubspot
  • Square
  • Time Tracking Essentials
  • Zendesk Analysis

Added the following Visualizations:

  • Aster
  • Spider

Action Hub Updates

Introducing two new Google actions - Google Drive & Google Sheets.
  • Users now have the ability to use an Oauth-based Google Drive action to send PDFs, Images, and more straight to Google Drive from Looker.
  • Users now have the ability to use an Oauth-based Google Sheets action to send CSVs from Looker straight to Google Sheets, as well as the ability to maintain live linkages or send static snapshots.

Looker 7.2

play_circle_filled
Expected
Rollout
Start
Sunday
February 9th
2020
check_circle
Expected
Final Release and
Download Available
Thursday
February 20th
2020

Dashboards (Beta) Updates

Introducing new functionalities on dashboards (beta).
  • Introducing the ability to create and manage alerts with a new simplified UI.
  • Introducing support for static maps (regions and point).
  • The LookML parameter parameter is now supported in dashboard (beta) filters, specifically for the following filter types:
    • Radio buttons
    • Button group
    • Drop-down menu
    • Advanced (is)

Team Homepage Settings

Homepage settings are out of Labs (beta) and in the Admin section under General Settings.

API 4.0 (Experimental)

Introducing a new experimental version of the Looker API, version 4.0.

Looker 7.0

play_circle_filled
Expected
Rollout
Start
Sunday
January 10th
2020
check_circle
Expected
Final Release and
Download Available
Monday
February 3rd
2020

Marketplace

Marketplace (beta) Labs feature is enabled by default.
  • Ensures that users can easily discover relevant and helpful marketplace choices.
  • Enables Looker users to discover, install, and uninstall content like blocks, applications, and custom visualizations. This initial release of the marketplace is publishing the following:
    • Sales Application
    • 23 Looker Blocks
    • 12 custom visualizations

IDE Improvements

Introducing bulk edits for files and folders in the IDE as well as improvements to the IDE UI.

Enhanced PDT Rebuilds

Use the power of the LookML model outside of Looker.
  • For every rebuild of a PDT, the given table name will now be unique. This will yield increased stability and faster rebuilds for certain dialects.
  • Stable, statically named view tables can now be generated on top of PDTs. A stable database view will only be published for its underlying PDT when that PDT gets rebuilt. By having a static, friendly name, the view table allows you to consistently access a PDT via SQL on the source database. This feature provides users with the ability to hook up other analytics or data science tools to Looker-governed data. Learn more about stable view tables.

System Activity Dashboard Enhancements

System Activity dashboards can be enabled through a beta Looker Labs feature: System Activity Model.
  • Improved and reorganized dashboards in a logical and actionable way to provide users with more efficient monitoring of the Looker instance. Learn more about System Activity dashboards.
  • Use the Errors and Broken Content dashboard to stay on top of all the things that need your attention for quick remediation.
  • Visualize potential performance issues via the new scheduler heatmap and avoid bottlenecks.
  • These are the titles of the available dashboards:
    • User Activity
    • Content Activity
    • Performance Audit 1
    • Performance Audit 2
    • Errors and Broken Content

Boards Section Descriptions

To provide more context to users viewing boards, the feature now includes descriptions for each section.
Top