Left Join vs Left Outer Join in LookerML
Hello,Is there any difference between Left Join and Left Outer Join in LookerML?I'm a completely noob and I'm ...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
SSAS consumption options
Hi people! Thanks in advance for read or help me with this.Being brief, I have a SSAS tab model being consumed...
Define dimension from a sub table's column
I have a derived table on view, the sql goes like:with events AS ( select create_time, export_duration, upload...
Autoscale enable for Looker
Need Autoscale for Looker,
Snowflake - Use ARRAY field without junction table
When I worked with BigQuery, I used this article to unnest repeated records: https://help.looker.com/hc/en-us/...
Primary key doesn't seem to be recognised
Has anyone dealt with this error before?I understand what it’s saying, but I have primary_key: yes defined in ...
Getting odd results when trying to commit a single change (multiple files listed that I have not changed)
We have a large, central data team that contains multiple subteams (data engineering, data governance etc.). T...
coalesce in view with two tables
I have a requirement of doing a coalesce by joining two tables. I can do that in explore but as I need that to...
Reassign parameter value in LookML
How can I reassign the parameter value by selected value in filter?What I tried to do:{% assign var=_filters[‘...
declare variable in sql runner
Hi guys, I need help.I'm new to the looker, I would like to know if there is a way to declare variables in sql...
required_access_grants for extension
Hi,we have a base explore that we use as explore_source in some views and as extension for other explores. The...
GoogleJsonResponseException: API call to bigquery.jobs.query failed with error: Access Denied: Project ppc-big-query: User does not have bigquery.jobs.create permission
I’m having issues running a BigQuery function from the submit button in the sidebar. The query function works ...
Looker Implementation experience
Looking for highly technical person with Looker implementation at an Awesome company - Ciena!! Person must hav...
Table Calculations in quickstart queries
Are there any plans to allow the query parameter (for quickstarts) to contain table calculations?
Add multiple filter condition in paramater
Currently this User 1 Filter 1 Num Val filter is equating the exact value of what ever the user input in the v...
How to block comment in LookML
Hi friends,Just curious is there a way to block comment as in C we can use /*...*/?Searched the community but ...
fighting student data
How make a dashboard from fighting students data
How to integrate looker with ms team
How to integrate looker with MS team?
Looker Salesforce Data Actions
Hi everyone,I saw on a video that you can create Data Action where you can insert data in Lookers Look cell an...
Project Structure
Hi,I have a question about setting the order of the project in my instanceAll the projects are in the below fo...
Filtered minimum date measure
measure: min_this_date { type: date sql: min(${this_date}) ;; filters: [other_field: "-NULL"] }This will error...
Case When for YesNo in Custom Dimension
Hi,I need to use YesNo Dimension in Case When statement and check if it’s not equals to “Yes”, then put some v...
Changing table name in data warehouse
Hello,This might be a very basic question with a simple solution but so far I could not find it.We have a tabl...
Can I extend my view with another view, and have derived table at the same time?
Can I extend my view with another view, and have derived table at the same time?
Array column
Hi there,Would like some input on how to create a dimension from an array column in Lookml. Warm regards.
Pagination in Looker
Some old-school reporting use-cases may require viewing more than 5,000 records. Since Looker sets row limits ...
Bar chart after pivot- unexpected
Hello, I have a look that is a bar chart, this look is supposed to show 3 values, lets call them A, B, and C, ...
Empty map drill overlay modal displaying only proper drill-fields for location-type dimensions
In case anyone else is struggling with this issue, I did not see another thread or any documentation of this e...
can we specify the folder for lookml dashboard?
As a parameter in lookml dashboard code?
Passing Value from filtered measure as a label
Hello everyone, currently I am facing some usability issue with our end users.I am trying to pass the value th...
