Rebuilding Incremental PDTs
I’m trying to force rebuild an incremental PDT from scratch without needing a change to the PDT’s lookml. The ...
Forum Posts
Can I create PDT for only few dimensions in the dashboard.
I have a view which uses derived sql. The dashboard is built using this view. The filters takes long time to l...
Looker Incremental PDT creates and duplicate records
Hi, Recently I have implemented incremental PDT and after few weeks I realize its creating duplicate records i...
Auto-Switch between Dev & Prod Schema and PDTs
I would like to share an approach to auto-switch between development and production datasets on a single looke...
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...
In Incremental PDT rebuild derived table feature not working
Whenever there is new data coming in. I use the rebuild derived table feature to pull the latest data.But when...
Datagroups and caching with dynamic schema value
Hi everyone! I have a somewhat open ended question that I can’t seem to find any information on… We have a Loo...
PDT Regenerator Using Multiple Models
I have a model with 2 `.model.lkml` files, which use 2 different connections and share views.I have a function...
PDTs that CREATE with daily incremental load
Hello! We know that PDTs are great at updating new data daily, but what if you are building a PDT from scratch...
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...
Error Creating Indexes for PDT
I’m using a PDT in my application. I get a warning that I’m not using an index for my PDT, and so to commit my...
Incremental PDT not working in dev environment - Looker
Hi Team,I am working on development environment in development mode.I have created Persistent derived table bu...
Datagroups Deleted Overnight
Hi, it looks like our Datagroups were deleted overnight. Anyone else experiencing this? Also it seems like our...
Incremental PDTs not incrementing when referencing the same derived table more than once.
I came across this problem a month ago. I have a SQL-based derived table (not a PDT), which I reference twice ...
Incremental SQL PDT not working
I’ve got this incremental PDT: derived_table: { increment_key: "last_update_time" increment_offset: 5 sql: WIT...
Incremental PDT's - rebuild entire table nightly
Hi All! Does anyone have thoughts on the following use-case for incremental PDT’s?I have an incremental PDT th...
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...
Loading historical data using incremental PDT
I have an incremental PDT that loads data on a daily basis. However when I deploy the same to production I wan...
improve performance in looker derived table
I have a question about how to improve query performance in looker. I use derived table in looker to transform...
How to reference the latest PDT's in an SQL query?
So we have PDT’s that are refreshing quite often in the company I work at. In addition to this, we need to que...
Looker is generating multiple SQL statements that are not separated by semicolons
HelloI am porting the marketplace marketplace_retail-block-v2 application to work with another database. It’s ...
Issue Staging Data Dynamically
We have a large base_table in our Snowflake database that contains row-by-row transactions from all of our sub...
Creating a PDT on the fly?
I recently discovered a PDT can be created on the fly either using a WITH statement or using Liquid. Right now...
Aggregate Awareness via Looker API?
Hi Looker Community,So I’m trying to build more and more Aggregate Awareness tables for my company, and I’m se...
“Resources exceeded during query execution” in BigQuery because of cartesian product
BigQuery charges per query based on how much data it has to scan. It then allocates server capacity to your qu...
PDT
Hello, please how to create the derived tables in our database to see the data they outside of our dashboards ...
Dynamically choose the table using Date filter values without adding new filters/parameters.
Hello All,I have a derived table for monthly data and a dashboard based on that. But when users are trying to ...
Converting SQL queries and stored procedures into LookML coding
Please help me understand converting some SQL query (see demo example below) into equivalent LookML coding; ex...
PDT .publish_as_db_view: yes
Hi All,I want to be able to query my pdt through a view since the PDT name changes every time with a new rebui...
Passing parameters into PDT
HiI’ve got a question regarding Solution 2 in this articlehttps://help.looker.com/hc/en-us/articles/3600238616...