Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started113 News & announcements112 Who's hiring414 Release notes (archive)63 Lesson Comments12 Challenge10
Looker developmentLookML1561 SQL284
Exploring & curating dataExplores490 Dashboards & looks1355
Application developmentEmbedding Looker / Powered by Looker132 Open source projects48 Looker API331
AdministrationUser access & management51 General Looker administration414
Data science & analyticsGot a question?69 Share your best practices16
コミュニティフォーラム (Japanese)ニュースと告知43 ヘルプとサポート11 コラム69
The Kitchen TableTechnical Tips & Tricks1659 Common Account Questions14 Blog Archives3 DCL Mic Drops5

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

1681 Topics

Recently active

Most replies Most views Newest first

Article How to Persist Derived Tables in Looker

Last tested: Jul 1, 2019 In order to persist tables in Looker, PDTs must be enabled for the connection and the scratch schema must be set up according to the database configuration instructions.Once the scratch schema has been set up and the connection allows for PDTs, derived tables can be persiste...

Technical Tips & Tricks

Article How to schedule based on a datagroup

Last tested: Sep 17, 2020 In order to schedule content with a datagroup, the datagroup will need to be defined explicitly in the model file or written in a .lookml file and included in the model file.1) Using just sql_trigger: use this to force a cache reset and/or drop and rebuild a PDT at a speci...

Technical Tips & Tricks

Article How do totals for table calcs work?

Last tested: Sep 21, 2020 Totals for table calcs work by apply the table calc logic to the totals of the measures that are referenced in said table calc.In other words,For any fields referenced in the calculation, the totals are computed. (This will fail for dimensions because they are not included...

Technical Tips & Tricks

Article What is a derived table?

Last tested: Jun 29, 2021 In SQL, a derived table is a subquery that is used in the FROM clause of a query.Example:SELECT * FROM (SELECT a, b, c FROM table) derived_table ;;In the above example, SELECT a, b, c FROM table is our derived table.In Looker, derived tables follow this same concept; howeve...

Technical Tips & Tricks

Article When updating an instance, will schedules that are scheduled to send while the instance is down send once it’s back up?

Last tested: Mar 19, 2019if they don’t start before the update, they will send out once it’s back up - if they are in process during the update, Looker will try to finish them after the update This content is subject to limited support.

Technical Tips & Tricks

Article What timeframe is the "Average Build Duration" of a PDT calculated on?

Last tested: Oct 24, 2019 We only keep data in PDT System Activity explore for 30 days. This means that the "Average Build Duration" only considers the most recent 30 days. This content is subject to limited support.

Technical Tips & Tricks

Article When "New Account Notifications" is on, will I get notified when new embed users are created?

Last tested: Apr 22, 2019Nope! New Account Notifications are only sent for non-embed accounts. This content is subject to limited support.

Technical Tips & Tricks

Article When using user-specific connections, is the cache still shared?

Last tested: Jan 22, 2019Just using user-specific connections does not disable the shared cache because if two users share the same username for the database, the shared cache will still be used. If the usernames vary though (which is the point of this feature), the shared cache will not be used Thi...

Technical Tips & Tricks

Article What standard are Looker's timezones based on?

Last tested: Apr 2, 2019 We have a list of timezone settings Looker can use in this doc here: https://docs.looker.com/reference/embedding/timezonesBut, where do these timezone names come from? Did we at Looker just make up all these names for different timezones?Nope! These are the names provided b...

Technical Tips & Tricks

Article Scientific notation with n significant figures in table calc

Last tested: Oct 25, 2018 You can replace n with the number of sig figs in this formula:concat(round(${view_name.field_name}/power(10, floor(log(${view_name.field_name}))), n-1), " x 10^", floor(log(${view_name.field_name}))) Example with n=2:concat(round(${orders.count}/power(10, floor(log(${orders...

Technical Tips & Tricks

Article What permission do I need to schedule based on a datagroup?

Last tested: Apr 7, 2020 Besides the general scheduling permissions, you need the develop permission on the model where the datagroup is defined AND see_datagroups. This means that only developers can schedule based on a datagroup.You do NOT need update_datagroups —this permissions is only for seein...

Technical Tips & Tricks

Article What happens to my `models-user-X` directory when I switch branches?

Last tested: Aug 28, 2018The models-user-X directory does NOT act as a "pointer" to a permanent local copy of the shared branch's files. Instead, when you create a new shared branch in Looker, a branch on the remote repo is created; this branch contains all of the commit history for the branch. Then...

Technical Tips & Tricks

Article Explore from Here matches what's on my dashboard tile, but the edit modal for the tile does not. Why?

Last tested: Apr 29, 2019This is most likely because there are dashboard-level filters being applied to the tile. The explore from here will match exactly what's on the dashboard, including applied dashboard-level filters. The edit modal for the tile will show only the query information saved on t...

Technical Tips & Tricks

Article Column is ambiguous SQL Error

Last tested: Sep 6, 2018 You may see an error that says something like Column 'id' in field list is ambiguous. This error means that there is a field name that is present in more than one table, so it needs to be scoped with the table name to avoid ambiguity: using orders.id instead of just id will...

Technical Tips & Tricks

Article Will my LookML references evaluate if the liquid condition that directs to those references isn't met?

Last tested: Mar 4, 2020 Yes, the LookML references will always evaluate, even if the SQL containing the reference doesn't end up in the final query due to an unmet liquid condition. Looker checks for all dependencies before applying liquid conditions, which causes LookML references to be evaluated...

Technical Tips & Tricks

Article Can I host a custom visualization on a private github repo?

Last tested: Aug 28, 2020 Not if you want it to work consistently! Users who are signed into Github and have access to the private repo will be able to see the custom vis, but if they are not signed in to Github, the custom visualization will not work, and Looker will not tell them why. Furthermore,...

Technical Tips & Tricks

Article Why is my API call returning a 403 Forbidden error?

Last tested: Dec 28, 2018 One possible reason is that the URL is missing the port number: https://mycompany.looker.com/api/3.0/login instead of https://mycompany.looker.com:19999/api/3.0/login . Leaving the port unspecified will use the default port of 443, which isn't used for API calls. Adding :19...

Technical Tips & Tricks

Article Can I cache with the API query endpoints?

Last tested: May 12, 2020 The `run_query` and `run_inline_query` API endpoints can pull from cache in the following ways:cache=true : use cache if it is availablecache=false : don't use cache even if it is availablecache_only=true : retrieve any results from cache even if the results have expiredHow...

Technical Tips & Tricks

Article In what order are operations based on datagroups performed?

Last tested: Nov 13, 2018 1. Check trigger (if triggered proceed to step 2)2. Rebuild any PDTs which use this datagroup as their datagroup_trigger3. Invalidate any existing cache entries which use this datagoup as their persist_with datagroup4. Run any schedules based on this datagroup This content...

Technical Tips & Tricks

Article "Something went wrong" on map visualizations on Chrome

Last tested: Feb 11, 2021 If a user sees "Something went wrong" on map visualizations on Chrome but not on other browsers, check the "Use hardware acceleration when available" setting: chrome://settings/?search=accelerationMap visualizations take a lot of resources and require this setting to be ena...

Technical Tips & Tricks

Article Why aren't my SSO embed URLs creating a new embed user when I access them?

Last tested: Apr 28, 2021 If you are getting a "You are not authenticated to view this page" 401 error, then the login has failed and the user will not be created. Try the URL in the Embed URI Validator. Fabio's troubleshooting guide can also be helpful.If the login is successful, this most likely m...

Technical Tips & Tricks

Article Why are we seeing "Result set for email cannot exceed 7.5/15 megabytes"?

Last tested: Feb 28, 2019Before version 5.14, the maximum file size that could be sent via the scheduler was 7.5MB. As per our docs here, After 5.14, 15 megabytes is the maximum. There's a feature request you can comment on for bigger limit. This content is subject to limited support. ...

Technical Tips & Tricks

Article Why are my git deploy webhooks failing after enabling Looker's IP Allowlist?

Last tested: Apr 2, 2021 Looker's IP Allowlist functionality gives Admins the ability to control what IP addresses are able to access their Looker instance. Because Github, Gitlab, Bitbucket, etc. all have their own cloud-based git repositories, we'll want to also allowlist the IP addresses for your...

Technical Tips & Tricks

Article How do I return the largest pivoted value in each row?

Last tested: Jul 8, 2019 Try using this table calculation:max(pivot_row(${name_of_measure}))That will return a single column with the largest value in each row! This content is subject to limited support.

Technical Tips & Tricks

Article I created a folder (previously space) but it's not showing up in i_looker/System Activity, am I doing anything wrong?

Last tested: Sep 6, 2019 No, you aren't! Folders only show up in the Look explore only if there is a Look on it. Empty folders would not be there. This content is subject to limited support.

Technical Tips & Tricks

1
...
40
41
42
43
44
45
46
...
68

Page 43 / 68

Powered by inSided

Sign up

Already have an account? Login

Social Login

or

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

*

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

© 2021 Looker Data Sciences, Inc.
community@looker.com
Privacy | Terms | Cookies | Community Guidelines