Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started152 News & announcements128 Who's hiring442 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1886 SQL327
Exploring & curating dataExplores579 Dashboards & looks1617
Application developmentEmbedding Looker / Powered by Looker159 Open source projects56 Looker API388
AdministrationUser access & management77 General Looker administration463
Data science & analyticsGot a question?87 Share your best practices16
The Kitchen TableTechnical Tips & Tricks1741 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥4
コミュニティフォーラム (Japanese)ニュースと告知51 ヘルプとサポート14 コラム69

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2111 Topics

Most replies

Recently active Most views Newest first

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can we define a view: parameter within a Model file? An explore: within a View file?Knowledge Drop

Last tested: Jun 28, 2021 This is technically possible, but we recommend against it, mainly for readability and organizational purposes. There are very few instances where it would be recommended/preferable to do this.You can technically define any object you want inside any file. The LookML parser starts at a model file, and then prepends the model file with any files in include: statements, making one "giant file". So, in this way, it doesn't really matter which file view or explore objects are defined in.For best practices, it is much cleaner to keep all explores inside model files, to keep view objects inside view files, and to only define one view per view file. You may encounter atypical types of modeling either in discourse examples, like this one, where we give an example like this:connection: "bigquery_publicdata_standard_sql" explore: persons {join: persons_cities_lived {....join: persons_phone_number {.....}} view: persons {} view: persons_cities_lived {....} view: persons_p

230

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Can I see user event activity in system activity? For example, seeing which users committed code?Knowledge Drop

Last tested: May 13, 2020 Yes, we have the /event and /event_attribute explores in system activity. Those explores will have Event Category and Event Names. The event_attribute explore has more robust information on the details of things that were changed.A few example Event Names are below:create_project login create_connection create_dashboard update_dashboard git_commit git_create_branch git_delete_branch create_role update_role create_content_metadata_access delete_content_metadata_accessCheck out this doc to see a comprehensive list of all event types.Here are some examples of cool things you can find:Event Explore use cases Event Attribute Explore use cases This content is subject to limited support.

210

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

${TABLE} is not allowed in the 'X' property.Knowledge Drop

Last tested: Aug 29, 2019 If you get an e-mail with a schedule error and it says ${TABLE} is not allowed in the 'X' property, this because you are using ${TABLE} outside of a sql parameter.Example of where this would fail:dimension: test {type: stringsql: ${TABLE}.field ;;# The below html references are incorrect. Substitution operators (the ${}) can't be used in html because they evaluate to SQL.html: My values are ${TABLE}.field and ${otherfield ;;} To fix this, use liquid references instead!dimension: test {type: stringsql: ${TABLE}.field ;;# {{value}} is how you reference the value of this field, and {{viewname.fieldname._value}} is how you reference the values of other fields.html: My values are {{value}} and {{otherfield._value}} ;;} This content is subject to limited support.

410

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Is there a way to get rid of the "Row limit reached" message, when we drill down in the explore?Knowledge Drop

Last tested: Jun 28, 2021 Not at the moment, but you can share your request with the Product team via Pendo! This content is subject to limited support.

1670

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Why do my queries with table calcs have such a long post-process/unaccounted for time when downloading?Knowledge Drop

Last tested: Jun 24, 2020 There could be a few reasons for this, first off table calcs operate over the entire result set. So say one of the calcs makes a list out of the column, that is a 5000 entry list in the simplest case, 50000 in the 20+ minute case. If you then try to take the maxof that, one of these will take much longer. It doesn't have to be a crazy looking table calc to be gnarly in terms of processing time.Second, there is also a global limit of 3 table calcs at a time that one looker instance (or node in a cluster) will process on the backend. So very long time intervals might include the time queued waiting for one of those table calc worker threads to get free.So what next? The less drastic though less feasible would be to suggest you change there querying habits. Moving table calc logic into the lookml/database OR being wary of how many queries they are firing off/downloading that contain table calcs. The more drastic option but perhaps the more scalable, would be clu

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

Filtering on Last Business day of MonthKnowledge Drop

Last tested: Feb 2, 2021 dimension: returned_last_business_day {type: yesnosql: CASE WHEN EXTRACT( day from DATEADD(day,2,${returned_date_raw}) ) = 1 AND ${returned_day_of_week} = "Friday"THEN trueWHEN EXTRACT( day from DATEADD(day,3,${returned_date_raw}) ) = 1 AND ${returned_day_of_week} = "Friday" then trueWHEN EXTRACT( day from DATEADD(day,1,${returned_date_raw}) ) = 1 then true else false END;; Basically, what this does is check to see if the second to last day of the month is Friday, if so that means that the last day of the month for that month was Saturday. If the third to last day of the month is Friday, it means that the last day of that month was a Sunday. This content is subject to limited support.

1110

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

What does the Ordinal Scale Type visualization setting do?Knowledge Drop

Last tested; Jan 13, 2021 The short explanation is that with Ordinal Scale Type setting, data is plotted along the x-axis as evenly-spaced, discrete entries, regardless of relative distance between data points. (https://docs.looker.com/exploring-data/visualizing-query-results/column-options#scale_type)The longer explanation:Let’s say you have a dataset like the following, where you have a gap in data from December 26th to December 27th (December 25th has data as shown in the data table, it looks empty here because it is a small number for the scale of this visualization).If you would like to show your data over the full timeframe that the data was collected, you can use the “Automatic based on Data” Scale Type (as shown above), or the “Time” Scale Type. However, if you do not want to show this gap, the Ordinal Scale Type will only plot the data from the data table. This content is subject to limited support.

490

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

SQL Error: relation "schema.table" does not exist"Knowledge Drop

Last tested: Feb 2021 This error message can appear when a table no longer exists but still shows in the list of tables for this schema.Error Message Error Running SQL ERROR: relation "schema.table" does not existTroubleshooting Go to the gear option next to the connection name and hit "Refresh Tables and Schema" if the table has been renamed/deleted then it will no longer show up under the reference name that is causing the error.This can also happen if the table is defined with mixed-case spelling and you try to query it without double-quotes. See this stackoverflow postIn other words, if hotelList was created with mixed-case spelling, this won't work:play_arrowSELECT *FROM hotellistLIMIT 10Because the tablename is converted to lowercase when the query is run, this also won't work:play_arrowSELECT *FROM hotelListLIMIT 10To avoid this issue, use double-quotes to use the specific mixed-case spelling as the table is defined. This will work:play_arrowSELECT *FROM "hotelList"LIMIT 10It is

14410

1 year ago

Department of Customer LoveModerator

published in Technical Tips & Tricks

SQL Error: "Syntax error at or near:"Knowledge Drops

Last tested: Feb 2021 Overview This SQL error generally means that somewhere in the query, there is invalid syntax.Some common examples:Using a database-specific SQL for the wrong database (eg BigQuery supports DATE_ADD, but Redshift supports DATEADD) Typo in the SQL (missing comma, misspelled word, etc) Missing a sql clause (missed from, join, select, etc) An object does not exist in the database or is not accessible from the current query (eg referencing orders.id when there is no orders table joined in the current query, etc)In some circumstances, the database error message may display extra detail about where the error was raised, which can be helpful in narrowing down where to look.Error Message SQL ERROR: syntax error at or nearTroubleshooting This should generally be the first step to troubleshoot any SQL syntax error in a large query: iteratively comment out blocks of SQL to narrow down where the problem is.TIP: To make this process easier, change the group by clause to use p

401130

1 year ago

xinLooker Staff

published in Technical Tips & Tricks

Custom filter: filter the last day of each month/quarter until yesterdayKnowledge Drop

4400

1 year ago

xinLooker Staff

published in Technical Tips & Tricks

How to filter complete weeks in the last quarterKnowledge Drop

Last tested; Jan 3, 2020 For some analysis, you might want to get only the completed weeks in the last quarter, for example, if the first day of Q4 2019 (2019-10-01) is Tuesday, then the start day should be 2019-09-30, and the last day of the quarter is 2019-12-29 (Sunday).We can use the below SQL to create a yesno filter, the yes value will filter out all the dates of the complete weeks.BigQuery:${date_dimension}>=date_trunc(date_add(date_trunc(current_date(), quarter), interval -1 quarter), ISOWEEK) AND${date_dimension}<date_add(date_trunc(date_add(date_trunc(current_date(), quarter), interval -1 week), ISOWEEK), interval 1 week) Redshift and Snowflake:${date_dimension}>=date_trunc('week', dateadd('quarter', -1, date_trunc('quarter', current_date)))::dateAND${date_dimension}<dateadd('week', 1, date_trunc('week', dateadd('week', -1, date_trunc('quarter', current_date))))::date Postgres:${date_dimension}>=date_trunc('week', date_trunc('quarter', now())-interval '3 months

6150

1 year ago

xinLooker Staff

published in Technical Tips & Tricks

Can slack actionhub and Lookerbot use the same bot user?Knowledge Drop

Last tested: Jan 15, 2019 Yes. Lookerbot is also an action hub. This content is subject to limited support.

1 year ago

xinLooker Staff

published in Technical Tips & Tricks

What is case sensitive in LookerKnowledge Drop

Last tested: Dec 31, 2019 1. Filename: it is case sensitive, however, we rarely have any impact since we don't reference the file name in the lookml.2. View name, dashboard name and field name: it is case sensitive, and we will have to ensure we reference the view, dashboard and fields with the correct case.3. Filter value: By default Looker filter UI is case sensitive, this also depends on the sql dialect and the settings in Looker, and it can be case sensitive. There's a parameter for it: https://docs.looker.com/reference/model-params/case_sensitive-for-model4. Referencing lookml field in Liquid: this is also case sensitive. This content is subject to limited support.

1320

1 year ago

xinLooker Staff

published in Technical Tips & Tricks

Why I cannot see the filter tab in the dashboard schedule modal?Knowledge Drop

Last tested: Jan 9, 2020This issue could happen if one of the dashboard filters is broken and requires a fix. Typically this happens to the field type filter that the underlying field is renamed or removed. Once the filter is fixed, the filter tab in the dashboard schedule modal should show up. This content is subject to limited support.

1 year ago

xinLooker Staff

published in Technical Tips & Tricks

System activity history explore: More Granular History Created DimensionKnowledge Drop

120

1 year ago

wonkyoung.park

published in Technical Tips & Tricks

Why does my explore take so long to load?Knowledge Drop

Last tested: Jan 19, 2021 Does the explore in question have a lot of fields and joins? If so, the current advice is that we should reduce the number of fields and joins in an explore until it's "small" enough" but we don't have a specific target.One thing to note is that hiding some of the fields with the hidden parameter or the fields parameter would not help much because our backend would still have to do a lot of work to gather all the data from all the LookML files referenced in the explore. This content is subject to limited support.

740

1 year ago

wonkyoung.park

published in Technical Tips & Tricks

JS Console: "dashboards cached_results miss for id your_dashboard_id"Knowledge Drop

Last tested: Jul 20, 2020 Problem: You're seeing dashboards cached_results miss for id <your_dashboard_id> in the JS console on an embeeded dashboardExplanation: No need to be alarmed. This message is harmless. It's logged by the front-end code whenever the /cached_results endpoint was not used to accelerate the dashboard load and that endpoint is never used for embedded dashboards. This content is subject to limited support.

100

1 year ago

vitor.leepkalnLooker Staff

published in Technical Tips & Tricks

My date filter is returning results from one day laterKnowledge Drop

Last tested: May 24, 2019 ProblemWhile filtering on a specific date, or by last x days, the query returns results from one day later.Potential SolutionsIf it's only a date (YYYY-MM-DD), with no time info, make sure your dimension_group contains a datatype: date parameter. Check to make sure that timezone conversion is happening or not happening as expecting. This content is subject to limited support.

430

1 year ago

vitor.leepkalnLooker Staff

published in Technical Tips & Tricks

How to find out the remote URL of the repository connected to a Looker projectKnowledge Drop

Last tested: Sep 3, 2019 Those with multiple projects could be using different repositories, and it's hard to troubleshoot when we don't know where the remote is hosted.Check in Looker Go to "Project Settings" and scroll to the bottom of the page - here you will see the Remote Origin URL:Check in Looker serverIf you have access to the Looker server, navigate to the project directory inside of the models directory /looker/models/project_x and run the following code:git config --get remote.origin.url The following info will be displayed:lookeruser@instance:~/looker/models/project$ git config --get remote.origin.urlgit@github.com::org/repo.gitshowing the repo. This content is subject to limited support.

940

1 year ago

Page 52 / 85

Badges

sbrylowskihas earned the badge Friendly Face
carriehas earned the badge Helpful
carriehas earned the badge Community Star
carriehas earned the badge Friendly Face
Dawidhas earned the badge Community Star

Show all badges

Sign up

Already have an account? Login

Social Login

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the Terms of Service.

If you’re an EEA-based consumer of digital content, services, or goods, and you’ve agreed to our Terms of Service, then EEA consumer laws provide you with a legal guarantee. Under this guarantee, we’re liable for any lack of conformity that you discover for the one-time supply of digital content or services at any time during the “continuous” supply of digital content or services.
Your national laws may provide an even longer guarantee. Your rights under these legal guarantees aren’t limited by any other commercial guarantees that we provide. If you want to make a guarantee claim or if you would like to delete your account data, please contact us lookerconnect-help@google.com.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

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.

This file cannot be downloaded

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

The Kitchen Table

Can we define a view: parameter within a Model file? An explore: within a View file?Knowledge Drop

Can I see user event activity in system activity? For example, seeing which users committed code?Knowledge Drop

${TABLE} is not allowed in the 'X' property.Knowledge Drop

Is there a way to get rid of the "Row limit reached" message, when we drill down in the explore?Knowledge Drop

What could cause the purple loading bar to get stuck?Knowledge Drop

500 Error on Add To ProjectKnowledge Drop

AssertionError in SDK callKnowledge Drop

How to Handle \n in dimensions - Newline_to_br LiquidKnowledge Drop

Can I enable SAML on my instance?

Troubleshooting Slack action errorsKnowledge Drop

Why do my queries with table calcs have such a long post-process/unaccounted for time when downloading?Knowledge Drop

Filtering on Last Business day of MonthKnowledge Drop

What does the Ordinal Scale Type visualization setting do?Knowledge Drop

SQL Error: relation "schema.table" does not exist"Knowledge Drop

SQL Error: "Syntax error at or near:"Knowledge Drops

Custom filter: filter the last day of each month/quarter until yesterdayKnowledge Drop

How to filter complete weeks in the last quarterKnowledge Drop

Can slack actionhub and Lookerbot use the same bot user?Knowledge Drop

What is case sensitive in LookerKnowledge Drop

Why I cannot see the filter tab in the dashboard schedule modal?Knowledge Drop

System activity history explore: More Granular History Created DimensionKnowledge Drop

Why does my explore take so long to load?Knowledge Drop

JS Console: "dashboards cached_results miss for id your_dashboard_id"Knowledge Drop

My date filter is returning results from one day laterKnowledge Drop

How to find out the remote URL of the repository connected to a Looker projectKnowledge Drop

Badges

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded