Knowledge Base Articles
Dev Mode PDTs
Knowledge DropLast tested: Sep 9, 2019A PDT that has been created/modified in a user's dev mode has the follow...
How are Out-of-Date PDTs Managed?
Knowledge DropLast tested: May 22, 2018 Persistent Derived Tables are automatically reaped by Looker based on ...
What does "using old version" mean in the PDT panel?
Knowledge DropLast tested: Jan 17, 2019 This is the case where looker is using a previous version of a table a...
Will selecting "Update" on my License Key affect active LookML code changes or kick off PDTs?
Knowledge DropLast tested: Jun 23, 2017 No. Selecting "Update" on the License Key admin setting will only ping...
What are mode=0 & mode=1 in active_derived_table?
Knowledge DropLast tested: Nov 10, 2020 The mode column indicates the state of the derived table.mode=0 being ...
PDT Logs: Consecutive Trigger Checks
Knowledge DropLast tested: Nov 2, 2020 If you happen to come across consecutive trigger datagroup check's equa...
How do I look up unused PDTs in system activity?
Knowledge DropLast tested: Sep 8, 2020 This link will help navigate you to the pdt_event_log explore (Be sure ...
Does a manual rebuild show up in the Admin > PDT panel?
Knowledge DropLast tested: Nov 16, 2017Yep - we report it with the build reason "User Requested Rebuild".This ...
PDT Troubleshooting and use of "Rebuild Derived Tables & Run"
Knowledge DropLast tested: Jul 12, 2017 You might get often faced with questions like:Why is my PDT data wrong...
PDTs - Useful Facts and Troubleshooting PDT Issues
Knowledge DropLast tested: Mar 20, 2017 The BasicsA PDT stands for Persistent Derived Table. It is a Looker-sp...
persist_for hierarchy
Knowledge DropLast tested: Jan 16, 2019 persist_for can be applied to PDTs, Models and Explores.There is a sig...
Why do I have duplicate PDTs?
Knowledge DropLast tested: Apr 4, 2020 PDTs can be shared by multiple models. When duplicates show up in the A...
How can I have a PDT only trigger a rebuild when two (or more) tables in my database have been updated?
Knowledge DropLast tested: Dec 27, 2018 Good question! There are at least two ways that we could get a PDT tri...
Multiple PDTs and a single Datagroup Object
Knowledge DropLast tested: Jan 16, 2019 If a user has multiple PDTs (say for example 3 PDTs) and they want to ...
Can you persist a derived table with a datagroup that's *not* included in the model the derived table is used in?
Knowledge DropLast tested: Jan 21, 2019 No, you cannot. If a derived table is persisted by datagroup_trigger, ...
How does the PDT stable view publish (publish_as_db_view) work?
Knowledge DropLast tested: Apr 7, 2020 As soon as a PDT build finishes, regardless of the source, a publish ta...