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
What You See When You SHIFT
One of my all time favorites is multiple cursors.
Clicks: ⌘+click on Mac or ⊞+click on Windows
Drags: option+drag on Mac or alt+drag on Windows
Edit a 250 line CASE statement like a hot knife through butter with this trick!
One of my favorites has been
option+clickon the legend when a pivot makes the chart too cluttered. By default, clicking an item in the legend will hide/show its corresponding line/bar in the chart, doing so while holing down
optionwill hide/show everything else. Becomes really useful when you have 10+ pivot columns, but here’s an example with just a few:
I’ve got one— Did you know you can “Option + click” on a field reference in the Looker IDE and it will jump you to the place that field’s defined?
This is a great idea,
@nicholaswongsg! Let’s make it exciting—
There’ll be a prize for the user behind the post in this thread that gets the most likes!
Share your secrets for a chance to win… something! 🥳
From another account of mine… fold your LookML wherever you want by adding bracket pairs inside comments:
One of my favourites, adding LookML search to Chrome (or probably other browsers too).
Chrome lets you add your own search engines which can be triggered in the address bar with a keyword followed by a space: https://support.google.com/chrome/answer/95426?co=GENIE.Platform%3DDesktop&hl=en#edit (other browsers can do similar things I think)
The code search URL for a Looker project looks like this (%s is where the search query goes): https://<LOOKER_INSTANCE>/search?projects%5B%5D=<PROJECT>&q=%s
Once you’ve set this up you can quickly search your LookML project, e.g. my keyword is ‘lk’
Pretty handy for finding stuff quickly.
This is such a great idea! One of my favorites that I learned recently is “Cmd-J” or “Ctrl-J” to jump to a specific file in the IDE.
This is super useful for navigating around the IDE quickly, especially when you’ve got a ton of files! I’m so excited to see what else y’all have to share 😃
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 😃
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]=0to 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
Here is a page of shortcuts that work in the Lookml editor. My favorite is “fold all”
Izzy, I’ve got a chrome search shortcut set up just for Discourse too ❤
Not sure if it’s a life-hack… but it sure is a time-saver that I often forget about --> The
Quick Helpon the right side of the LookML IDE is clutch when you want to know the available parameters for that type of field, or need a refresher on syntax (or like me, you forget if you need to include brackets, or some “;;” perhaps). It’s dynamic so it changes based on your text cursor location, AND it’s hyperlinked to our docs so you can jump straight to the relevant documentation if you need more info.
If I can add my usd_2 (LookML joke):
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!
Love this thread!
@izzy that one is really cool - looks like it only works within the current file though?
EDIT: looks like I was too hasty and this does let you navigate between files if you click a view_name.field_name reference; doesn’t seem to work from within an extension view though.
I have a couple but I’ll post them as separate replies.
Thought I’d add some more here and bump the thread (and partly as I’ve posted about some spurious non-issues recently 😊) . Maybe we can get some more contributions before the end of the week.
Some IDE/code related ones:
cpu- are there any more/an official list?
And one last one:
and vice versa.
The results are in!
@ernesto having the highest ❤ count on a single post (20, for his multiple cursor technique), @simon_onfido has the highest overall ❤ count, with 23 between his two contributions. Plus, Ernesto works here. Simon wins!!
And this works when creating table calcs too… Revolutionary
This is blowing my mind! Sweet!
This is wild!
@fabio was so casual about already knowing this, but this totally blew my mind too.
Adding in on this:
@jonathan.walls here at Looker built a package for sublime text to do LookML highlighting!
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!
this is exactly what I came looking for, thank you very much!
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
This is such a cool thread, thanks for starting!
I love using browsers’ “custom search engines” with my most used dashboards.
Also, I wrote this bookmarklet for one-click downloading in your preferred format which I think qualifies: https://discourse.looker.com/t/one-click-downloading-with-bookmarklets/7079