Creating and updating a temporary table in LookML
I am trying to create/update table/view inside a SQL based derived_table in LookML. Is that possible? I keep g...
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
Looker Access Filters
Hello,For my job, I am updating a model with an explore extend. In that extend, I am joining the base explore ...
Drill Down Issue
I am trying to create a collection of fields for drilling down in an explore and hitting an issue. I have an e...
Not able to create a project in Looker despite Admin Role
Hi Team,I have admin role in Looker. But when I try to create a new Looker project, I encounter Looker access ...
Merge Queries
Hey,We are trying to do a merge query but it isn't producing any results. We are joining the explores on an ID...
Can I use a user_attribute for dynamically change model names inside dashboard files?
Hello,We are currently using a single Looker instance with three different projects (Dev, QA, and Prod). Each ...
Pagination in Looker
Some old-school reporting use-cases may require viewing more than 5,000 records. Since Looker sets row limits ...
'Datagroup Maintenance Schedule' vs. 'datagroup- max_cache_age'
if I have defined max_cache_age in datagroup within a model say 'A' and we also have Datagroup Maintenance Sch...
Create a custom visualization without development skills using Generative AI
Create a new project (or you can use your existing one if you only need a single custom viz) and create a new ...
Drill Downs for Table Calculations
Hi all,I have a simple table calculation on a report and I would like to control the drill down. If it was a m...
Injecting extended view dimension in derived table sql doesn't work
Hi,I built a future looking period control that has application in 4 different views. In the spirit of DRY, I ...
is it possible to filter a parameter based on another parameter?
Hello, I have two parameters that I need to tie together when using them as a filter on the looker dashboardPa...
LookML filter dependent on another?
Hello, I am trying to create two filters on a dashboard. The setup is this. We have multiple teams and multipl...
How to Dynamically Connect Looker to Different BigQuery Reservations Using User Attributes?
Hi Looker Community,I'm working on a project where I need to dynamically connect to different BigQuery reserva...
How to Set Up Looker for Multi-Tenant Use with Per-Client Billing?
Hi Looker Community,I'm looking for advice on setting up Looker to serve multiple B2B clients using a single d...
Updating the view does not update dashboard
I have a dashboard which has a tile built from "ABC" view. I wanted to make some column name changes, so I upd...
Multiple connections in one model
Hi, I’m new to Looker and I’m trying to figure out how to have a model that uses more than one connection - as...
Liquid Filters Documentation
I stumbled across this reference at the bottom of the liquid variables reference page for handling filters as ...
Update(write-back) data on BigQuery from Looks?
Is there a way to let users update data on DB right from looks? I read about actions here but I found it very ...
send email in field-level via SendGrid
Hi everyone, I'm trying to figure out how to send email via SendGrid from Looker dimension (the way it is impl...
Passing Literal Values to Predicate
We have a BigQuery table partitioned on date. In order to take advantage of the partition, we need to pass the...
Using Liquid variables with sql
I built a parameter and a measure which run SQL from a joined view, but when I run it in Explore, I get an err...
Safely changing view label in looker
I am changing view label in Looker and after the change, some of the dashboard is breaking due to "View not fo...
Date range filter based on lastest data
Hello guys,I'm stuck with date filtering- Please suggestThe data is stored in BQ as Month end dates and we hav...
Can I change the names of the column headers in my look?
If you look at this screenshot, you can see the "repetition" of the header names. "Company Id Company Id" etc....
Problem triggering Cloud Functions with Looker Actions
Hello everyone,I spent the last two days trying to figure out how to trigger a Cloud Function from Looker.I ha...
Can I use a user_attribute for a filter title on LookML dashboard?
hello, I have a customizable dimension label based on a user attribute and I am having trouble using that valu...
Value format in looker. We are trying to break number in billiion, million and thousands dynamically
Folks,We are trying to format numbers in Looker dynamically in billions, million, and thousands dynamically. B...
Add Group Header Rows
Hello Looker Community!I was wondering if there is a way to add a group header row in looker. What I mean by t...
dynamically select dashboard time period with parameter
Hello, I want my users to use a "filter" (parameter) to select the time period of the dashboard, e.g. date, we...
