Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Looker Life Hacks (Join Me!)

nicholaswongsg
Userlevel 4

Got a looker life hacks like commands to clear selection or force pull from production and more? Would love to hear what you have up on your sleeve! 😉 I’m going to start first!


Life Hack #1: Seeing errors because your local production branch is not up to date?

When changes are pushed to production they push to remote production and sometimes we need to manually update our local production environment. In your LookML page, HOLD SHIFT & CLICK ON THE ARROW next to the Validate Again function. You will get MORE functions. 🙂


What You See Normally

30%20AM


What You See When You SHIFT

41%20AM


Reference:


39 replies

D
Rank
Userlevel 4

This is such a cool thread, thanks for starting!

fabio
Rank
Userlevel 7
Badge

Kinda remembered this one way after the fact, but…


If you want to quickly add a hidden field to your explore, just append &f[view.field]=0 to your current URL. This will add the field as an additional filter, without interfering with your other selected dimensions and filters, then you can add the field to your table, if desired, by using the gear menu from the newly applied filter

Cyril_Marques

If I can add my usd_2 (LookML joke):


On Mac:

Command + Option + 0 to fold all LookML in current file

Command + Option + shift + 0 to unfold all LookML in current file


I guess replace Option with Alt on other OS.


It changed my life!

izzy
Userlevel 7
Badge +1

😂 😂 😂

mprogano
Userlevel 3

Not sure this counts as a life hack, but I wrote some CSS to increase the width of the autocomplete dropdown and enable vertical scrolling and it’s made my workflow 10x better 😃


SOURCE:

https://discourse.looker.com/t/a-better-autocomplete-dropdown-for-the-looker-ide/12782

** Checkout the UNOFFICIAL Slack Community: http://bit.ly/union_invite
S

this is exactly what I came looking for, thank you very much!

mzaccaron

When you want to create a report with a specific order of the columns, you can set up a set of fields with all the fields in the order you want and then use the drill to generate the report (click and then explore from here in the drill result) - instead of manually generating the report - it is also good to keep track of the order - if the order matters!

izzy
Userlevel 7
Badge +1

X-posting @Dawid_Nawrot’s “Collapse all field groups” bookmarklet to collapse every field in the field picker 🔥🔥🔥


izzy
Userlevel 7
Badge +1

from @gregono1:


S
Userlevel 3

Not exactly a hack but something that I recently noticed.


When you use the ‘fold LookML’ option, how much of the code it folds depends on where your cursor is. I had always assumed it just collapsed everything completely which was a bit annoying as generally in a view I want the view itself expanded but all the dims/measures etc collapsed - and this is what happens so long as your cursor is inside the view: myview { } block. Magic!

lindenPMP
Userlevel 1

​Hey @izzy  @fabio@Dillon_Morrison@ernesto@will.adams@jeffrey.martinez  this is one of the coolest threads I’ve found in Community! Not sure if similar iterations that are more recent exist, and I don’t know about anyone else, but I’d love to see what tips & tricks folks have picked up over the past year or two... that’s a lot of version releases and feature updates… what do ya say we bring it back?!

​

fabio
Rank
Userlevel 7
Badge

@lindenPMP - I don’t have any new in-product hacks myself, but since Looker’s extensibility interfaces have grown so much in the past year or two (extensions and OAuth for the API in particular), I think a lot of us have been making cool things in that space.

One that I got through our open sourcing process is here. It’s a sample lightweight Node.js server that helps translate OAuth-authenticated users into backend service-account authenticated API calls for exposing limited administrative capabilities to your end users: https://github.com/looker-open-source/micro-admin-for-looker

thomas.rose-1636633722
Userlevel 1

Just discovered - if you need to hide an “action:” you can use liquid to set an empty label - this not just shows an empty row but hides the action from the menu.

Need help with Looker? Feel free to Contact me - Looker Expert at adesso SE - Certified Looker LookML Developer / Google Cloud Data Engineer
Vikak kumar
Userlevel 2

Phone pay customer care number 7978471163/24/7908676812Phone pay customer care number 7978471163/24/7908676812Phone pay customer c

Reply


Terms of Service