Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
Ditto @IanT, i__looker has traditionally answered only around 20-40% of the questions we’ve had that can actually be answered with the underlying data.
Perfect thanks @brecht, yes I’m familiar with i__looker (we use it quite a bit although we’d absolutely love to be able to manually query the underlying data or change the LookML for i__looker so it’s more comprehensive).
This is really useful thanks! Hoping the comment also includes the query source, ie explore / SQL runner / etc…?
@dengstrom, you’ll need to go to the i_looker explore here: https://yourcompany.looker.com/explore/i__looker/history Then you filter for: History Source = Other History Message = Building derived table YOUR_PDT_NAME And the fields I selected: History Created Date History Query Run Count History Average Runtime
@sam, thanks for the quick response, that’s most probably the reason, we didn’t quite trust our Lookerbot enough to give him admin rights 🙂
Thanks @aleks, would be nice to be able to do this via the Lookerbot rather than changing persist_for. Also, any idea why it’s not possible for us to use to Lookerbot to access the i_looker model? The bot gives me a “forbidden” message. One example use for this is that we regularly need to check PDT avg build times and daily build counts for specific PDTs similar and it would be useful to be able to ask the bot for this info. See this example for a specific PDT, we’d use a command similar to “@looker pdt builds {pdt_name}”:
Is there a way to configure a custom command not to get results from cache and to run the query instead?
Thanks brettg we’ll take a look at that.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
