Where is the LookML Associated with my Dashboard?

(Carter Moar) #1

As of Looker 4.12 you can generate and copy a LookML representation of a User Defined Dashboard (UDD).

Looker has two ways to create a dashboard:

The first, and oldest, is to write dashboard LookML to define the details of each dashboard element, and to wrap them together (see [here] (http://www.looker.com/docs/sharing-and-visualization/creating-lookml-dashboards) for instructions on how to build a dashboard with LookML).

In Looker 3.2, we introduced a second type of dashboards: user defined dashboards (UDDs). These dashboards are entirely drag and drop, [are super easy to create] (http://www.looker.com/docs/exploring-data/building-dashboards), and can be just as powerful.

A question we often get is:

Where is the LookML for my dashboard?

The answer almost always requires a further question:

What kind of a dashboard is it?

LookML Dashboards

If we’re talking LookML dashboards, the answer is easy. There will be a cog in the upper right hand corner of your dashboard with an option to Go to Dashboard LookML. This will take you to the LookML file that contains your dashboard’s LookML, and you’ll be off and running. :runner:

User defined dashboards

If we’re talking user defined dashboards, the answer is also easy, if more nuanced. The short answer is “There isn’t any”.

The more nuanced answer is that UDDs do not have any associated LookML. User defined dashboards are linked to Looks rather than LookML, so if you’d like to change visualization parameters, just use the Explore interface to edit your visualization (for more detail, check out the above link). You can rearrange the tiles and add filters just by clicking and dragging. You cannot, however, dig in to the LookML to tweak things.

Embedding Dashboards
Performance Considerations with Suggest Filters
(Nicole Beyer) #2

Differences between LookML and User Defined Dashboards

LookML Dashboards

  • Based on LookML, written in a dashboard.lookml file
  • Changes made by editing LookML

User Defined Dashboards (UDD)

  • Based on saved Looks
  • Elements update anytime the corresponding saved Looks is updated
  • Entirely configurable in the UI (ideal for non-developers)
  • Has no associated LookML, stored entirely in Looker’s database

Troubleshooting Looker SSO Embed URL Generation
How to add and edit filters in a Drag and Drop Dashboard (deprecated as of 3.32)
(Carter Moar) #3

As of Looker 4.12 you can generate and copy a LookML representation of a User Defined Dashboard (UDD). The core of this article is still accurate and there is still no LookML that governs a UDD, but you can now create a LookML-based copy of a UDD.

(Tig Newman) #4

At the top of this article, I’ve added a link to the documentation about generating and copying a LookML representation of a user-defined dashboard.