Liquid _in_query not working for custom dimensions
Hi!I have a set of derived tables where I use Liquid to include/exclude columns in the SELECT statement based ...
Forum Posts
Extend view and use its dimension in a derived table sql
Can I extend a view and use one of its dimensions in derived table sql query?Here is an example of what I am t...
Do PDTs behave different in Dev Mode?
I was testing a PDT in dev mode that took about an hour to complete, but it seemed to keep getting cancelled b...
templated filters and derived tables
view: closed_loans { derived_table: { sql: with closed_loan_data as ( select row_number() over (order by coale...
What max cache can we set in Mbs/Tbs ?
Hi everyone,Whos know max cache in looker which I can apply? Because I found only default value (2000mbs.) --o...
[Analytic Block] - Pivot by Top X - Introducing bind_all_filters: yes
Pivot by Top 10 You’ve got a high cardinality dimension and you’d love to just see the Top 10 based on some me...
Window Calculations (Partition by) gives different results depending on what (unrelated) fields are in the table
Hi, I’ve been trying to get sum certain values for other repeated values in the table using SUM(values_to_sum)...
PDT rebuilding every hour due to 'table not in scratch schema'
Hello,I have a problem with several persisted derived tables that are set to rebuild overnight, but are actual...
Datagroups Deleted Overnight
Hi, it looks like our Datagroups were deleted overnight. Anyone else experiencing this? Also it seems like our...
How often will the cache be cleared by this data group which using sql_trigger?
If I have a datagroup with a sql_trigger of ‘SELECT CURRENT_TIMESTAMP" (that is, it selects thecurrent date, h...
what are the pros and cons of using derived tables
what are the pros and cons of using derived tables
Adding measure based on date
Hi all,I am trying to create an aggregation based on the date of a measure I have which should not include the...
How to capture date difference with liquid ml
I am attempting to use Liquid ML to adjust a table i am using for a look depending on the date range a user se...
Incremental SQL PDT not working
I’ve got this incremental PDT: derived_table: { increment_key: "last_update_time" increment_offset: 5 sql: WIT...
Using a Filter value to execute only part of Derived Query
I have the following derived query:derived_table: { sql:select * from this_yearunion allselect * from last_yea...
SQL Derived Table
I am trying to create a derived table with SQL which involves using a liquid condition in the SQL. I used a in...
LookML error "Can't construct persistent derived table"
I created datagroup and persistent derived table as below. but it keeps giving me an error. model```connection...
Create matrix using a dimension containing the names of several measures and display their values conditionally row by row into a dummy measure
I am trying to create a table in which I display the measures names in rows while bringing their respective va...
Derived table with SQL that references other view dimensions?
I am trying to create a new view which is derived from existing tables/views that are already specified in Loo...
select field list and make new query with this list
I would like to select field names from one table and pass their list to another select.I know how to do this ...
Liquid checks in persistent derived tables: Triggered builds failed?
Hi,My PDTs work fine unless the build is triggered by Looker instead of through an Explore.I have the followin...
change date format
I created a derived table that count the leads that we got in each day:Instead of that, I want to count the nu...
How to create Native Derived Table with brand wise Rank() over order by Sum of Sale price.
Here I want to create rank column with help of Sum(sales) aggregation value in the same query. select brand, S...
Cannot create a derived table using SQL
Hi, I’m new to Looker, and I’m trying to do the following: Take a lengthy SQL query that I built and save it a...
Can tables within the same schema become a filter?
There are many tables in our database having the same structure, and all of them need to add some customized m...
Duplicating Tables for Comparative Analysis
Hello! My goal is to develop a benchmark analysis, a time-series comparison of a single customer’s measures to...
How to calculate YTD for every date period in history and not just as now?
HiI am trying to replicate existing reports which include MTD and YTD measures. I don’t want the YTD as per no...
SQL query optimization for derived tables
I’m trying to run SQL RANK() OVER function on top of my existing table to remove duplicated rows of BigQuery t...
Best way to replace table calculations for month over month retention/results
I need to track 3 data points month over month that all have to do with the volume of partners on our delivery...
How unpivot a table in LookML?
I have a table with the following structure:month | cost_cat1 | cost_cat2 | cost_cat3But I need this one:month...