Looker 6.10 Release Notes

Userlevel 5

Anticipated Deployment Dates

Release Rollout Begins: April 7, 2019

Release Final & Download Available: April 18, 2019

Release Highlights

In addition to general tweaks and enhancements, this release comes with new and improved features in the following categories. Read on for more detail.

Preparing for Release

Please take notice of items marked with a ⚡ as they indicate changes to existing functionality and may require your attention. For more information see the Legacy Feature Updates and Features by Section below.

Experimental and Beta Features

The following new and improved experimental and beta features are marked with a ⚗:

Notable Features

Three (or four) New Visualizations

By popular request, we’ve added three new standard visualizations and a fourth Labs revamp of the table visualization. Use the new box plot to show distributions in value, use the waterfall to help understand the cumulative effect of positive and negative values, and highlight the most popular values with the new word cloud. The new table visualization has native subtotals and adjustable and freezable columns.

Features by Section

Dashboards, Visualizations, and Explore

  • New visualizations!

  • Reverse the colors. Added an option to reverse the order of a color palette when multiple series are present in a visualization.

Platform and Administration

  • Introduced Oauth for the Action Hub. New actions may be built with OAuth, allowing users to authenticate as themselves to take action in another application. Learn more.

  • New default password requirements. New and reset passwords will be subject to the following requirements: minimum length 10 characters, at least one uppercase and one lowercase letter, one numeric character, and one special character. Learn more.

  • New language support. Expanded current language support to include Spanish, Italian, Korean, Dutch, Portuguese, Brazilian Portuguese, and Russian. Learn more.

  • System Activity model and dashboard improvements

    • Fields used in non-Look tiles are now tracked in the model and dashboards.

    • Added descriptions to the remaining fields in the model.

    • Improved drill fields in the System Activity model and dashboards.

  • ⚗ Promoted API 3.1 from “experimental” to “beta”.

  • Added the ability to disable Gravatar user account profile pictures. Learn more.

  • Added Javascript events that track when embedded content begins and completes loading data. Learn more.

LookML and Development

  • The Content Validator now covers dashboard filters and listeners. Learn more.


  • Addressed a vulnerability that allowed for access to other users’ scheduled deliveries.

  • Addressed a vulnerability related to the sanitization of SQL Runner downloads.

  • Newly created instance will default to having “Clickjacking Protection” enabled on the Embed Admin page. Existing instances will retain their selected values.

General Tweaks and Bug Fixes

  • Dialects

    • Fixed an issue where Looker generated invalid SQL for Dremio.

    • Fixed an issue where Looker generated incorrect SQL for relative date filters on Druid.

  • LookML and Development

    • Added a link to the “import credentials” project settings tab when the LookML Validator warns that a dependency lacks credentials.

    • Fixed an issue that resulted in “Document Not Found” messages when selecting “View Document” to see a document outside of the IDE.

    • ⚗ Custom fields no longer unnecessarily trigger Symmetric Aggregates.

    • Fixed an issue where developers could not see certain models connected to local git repositories.

    • Fixed an issue where the Content Validator could group errors by the wrong space.

    • Fixed an issue where the Content Validator did not flag errors produced by fields being excluded using fields: [] at the join level.

    • Fixed an issue where the LookML Validator failed to detect inaccessible native derived table fields.

    • Added validation to properly protect against duplicative model names issues.

    • ⚗ Fixed an issue where project import would include all view files in a project when it should just include the root with include: "/*.view".

  • Scheduling and Downloading

    • Improved mailer stability by retrying schedules after a timeout period.

34 replies

Hey @Brad_Kohlmeyer,

Yes, transpose is now available in the new table visualization!

Hi Arielle!

Any on the ability to transpose rows and columns?

Really looking forward to this feature.



My clients are very interested in the subtotals. They’ve been asking for this for quite some time now. Thanks!

Hi @clupton92592, the table feature is here to stay! It’s currently in labs because we are actively developing new features on it, so you may notice some updates over the coming releases. Out of curiosity, which part of it are your customers interested in?

Hi Arielle,

I understand the Table-Next Lab feature is currently in the Experimental stage. This is a feature our clients have been asking for, but before I enable this Lab I’d like to find out how likely will this become a permanent feature? I’d hate to enable it for my clients if it’s not going to be available for them in the future. (kind of like giving a little kid a toy he’s always wanted then taking it away from him 🙂 )

Userlevel 7
Badge +1

You’re right that it’s not explicitly on the roadmap right now— However, a general redesign of dashboards and filters is, and this feature is being discussed as part of that. You’ll be the first to know!

Going on several years now of wanting this feature so I don’t expect it will be on the near term vision. Thanks for checking though have not heard back yet.

Are there plans to have the Table-Next as a ‘Data Table’ option for formatting in email sends? Would be great for viewing tables on smaller screened devices…

Userlevel 5

Awesome! Immediately more useful now 🙂

Hey @bens, collapse/expand all from the header bar is on our backlog, hoping to get that into a future update! In the meantime, you can actually change the default behavior in the viz config, here:

Userlevel 7
Badge +1

Christmas is coming early this year!

Userlevel 5

Not to get too greedy here, but a collapse/expand all would be fantastic. It’s really cumbersome to use sub totals without this feature (especially since Looker is defaulting to expanded). @arielle thanks for your detailed response above! Looking forward to seeing those changes.

Hi @divvyMatt, glad to hear you are enjoying the new table updates! Yes, the ability to transpose (flip the columns + rows) is in the works right now. Here’s a sneak peek 😀 (it’s not available quite yet, but will be in an upcoming release!)

I love the new table options - particularly the ability to autosize a column. Curious, will this new table support stacking measures verticlaly at some point? Tracking 4-5 measures in a vertical stack with time on the horizontal in a table is an incredibly common use case - think quarterly financial reports, P&L statements, etc.

Thanks for the great improvements!

Hi all, thanks so much for your feedback on the new visualizations! We love hearing from our customers on their use cases and where our features are working / not working for them. I do want to give a couple of updates around the waterfall and boxplot visualizations:

@bens I totally hear you on the 0 dimension use case for waterfall - we are going to be releasing an update soon that supports that configuration. We will also be pushing a couple of fixes to resolve bugs around the color picker - thanks for your patience as we roll these out!

For boxplot we did take an approach that is a bit different from other products given our in-database architecture. Since Looker does not consume or store the full dataset in memory, computing the min/max/quartiles based on the subset of rows available in the table could potentially result in inaccurate values. To ensure accurate results, we instead opted for the database to do the computation, which does require that measures or custom fields are needed to set it up.

Thanks again everyone for the feedback and helping us improve - keep it coming!



@Lewis_Osborne Here they are: https://docs.looker.com/exploring-data/visualizing-query-results/boxplot-options

Are the online docs for the box plot available?

Waterfall color options are buggy for me. Only let’s me specify a color if I have “Reverse colors” checked.

Userlevel 5

Interesting! Seems the use case I was envisioning is pretty different. For me, the thing I love about a waterfall chart is to take multi-variate realities (such as profit), and to deconstruct them into those raw components (such as + revenue - fixed costs - variable costs). That said, I totally neglected to think about that kind of use for Waterfalls, but I see the value completely!

Userlevel 2

For the Waterfall I have the transaction date as the dimension, and the sum of transactions as the measure.

When I first saw the topic of Waterfall charts it seemed to be about some kind of cost analysis, but my first thought was to show the balance of an account over time, and the Waterfall Chart option given recently covers this exactly without needing any calculated fields.

I can filter for client X with a load date of Y, and see how the value of those accounts has progressed, and get a good idea of how much is left on that account.

Even if you’re looking at costs A, B and C and incomings of X, Y and Z, I’d imagine you’d want all those in the same table/view and the dimension would be the transaction type or similar?

Userlevel 5

While it’s great to see these new visualizations, I feel like the waterfall and box plot are an iteration away from being ready for business users selecting them from an Explore (though maybe this is something with a few examples of how to use them properly from Looker, I’ll understand the intent more than I do right now). My concern is that it seems they both require using of Table Calcs or LookML, which to me goes against Looker’s raison d’être of no/low-code data dives for all.

For a Waterfall, for example, I’m not clear on how we’re intended to use it with one dimension and one measure. The most obvious use case for a Waterfall Chart is probably a visualization of income. For that, I would’ve thought the approach to accommodate would be to actually allow zero dimensions, and only measures. Then, to be able to specify whether each measure is an Up or Down contributor (i.e. flip the signs if needed), and the column headers could simply be the measure column names. With one dimension and one measure to accommodate this, pretty sure I’d have to write Waterfall-specific fields.

For a Box Plot, I understand the concept at least, but I still don’t think it’s overly usable to require writing between two and five measures just for it. The way I was hoping it would work, is to accept two dimensions and one measure and for the system to deduce the rest (the quartile locations, whisker extremities, etc.). Say your first dimension was Store Name, and your second was Order Number. Then, with a Total Sales measure, this could present a box per Store, with orders ‘bucketed’ into the appropriate regions.

Hopefully something in this ramble is of use to someone, but these are promising starts 🙂

Userlevel 7
Badge +1

Nothing at the moment, Dan— I know that there is some general dashboard redesigning in the pipeline, but I’m not certain whether that scope includes this feature. I’ll see if I can get someone from product to weigh in.

Any updates on PDF’s with filters at the top?

Userlevel 7
Badge +1

FR: https://looker.atlassian.net/browse/ADMIN-604

Userlevel 5

I see many great improvement in system activity. Can we add filter to User Activity dashboard to exclude all users who are disabled?