The PDT Reaper
Knowledge DropLast tested: Dec 12, 2019The reaper is the process in Looker that is responsible for dropping no...
•
Knowledge DropLast tested: Dec 12, 2019The reaper is the process in Looker that is responsible for dropping no...
Knowledge DropLast tested: Sep 9, 2019A PDT that has been created/modified in a user's dev mode has the follow...
Knowledge DropLast tested: May 1, 2020 It's an identifier for an instance. Instance slug is the combination of...
Knowledge DropLast tested: Oct 31, 2019 QuestionHow do I use access filters inside the SQL of a derived table?...
Knowledge DropLast tested: March 2021The ProblemI need a condition to appear in the WHERE clause of my derived...
Knowledge DropLast tested: May 22, 2018 Persistent Derived Tables are automatically reaped by Looker based on ...
Knowledge DropLast tested: Feb 2021ProblemI have several PDTs building, and I want to either: Pause a PDT from...
Knowledge DropLast tested: April 2021 How do I use window functions in Looker?Window functions are a very powe...
Knowledge DropLast tested: Jul 13, 2018The problemSay you want to see some metrics for your top 10 customers b...
You can use the graph_derived_tables_for_model endpoint (documentation) to get a dependency graph of all the P...
Knowledge DropLast tested: Jan 17, 2019 When you call ${sql_table_name} in SQL Runner, if you're in dev mode, ...
Knowledge DropLast tested: Jan 17, 2019 This is the case where looker is using a previous version of a table a...
Knowledge DropLast tested: Jan 17, 2019 This is one example of an error you can get by using a CTE in a derive...
Knowledge DropLast tested: Jan 25, 2021 The frequency of datagroup triggers is determined by two things:1. The...
Knowledge DropLast tested: Jun 23, 2017 No. Selecting "Update" on the License Key admin setting will only ping...
Knowledge DropLast tested: Nov 10, 2020 The mode column indicates the state of the derived table.mode=0 being ...
Knowledge DropLast tested: Nov 2, 2020 If you happen to come across consecutive trigger datagroup check's equa...
Knowledge DropLast tested: Sep 8, 2020 This link will help navigate you to the pdt_event_log explore (Be sure ...
Knowledge DropLast tested: Aug 19, 2020 What are transient schemas? https://docs.snowflake.com/en/user-guide/t...
Knowledge DropLast tested: Mar 23, 2020 You will not be able to query the stable view name until the PDT rebui...
Knowledge DropLast tested: Nov 16, 2017Yep - we report it with the build reason "User Requested Rebuild".This ...
Knowledge DropLast tested: Jul 12, 2017 You might get often faced with questions like:Why is my PDT data wrong...
Knowledge DropLast tested; Oct 17, 2017 Right now that's not possible natively.One thing you can do is concat ...
Knowledge DropLast tested: June 2021The PDT reaper process runs at most every hour (while respecting the PDT m...
Knowledge DropLast tested: Oct 22, 2018 This can be caused by commented out liquid in a PDT - commenting in Lo...
Knowledge DropLast tested: Mar 20, 2017 The BasicsA PDT stands for Persistent Derived Table. It is a Looker-sp...
Knowledge DropLast tested: May 11, 2020TL/DR: Don't share the schema! Two instances should not share the same ...
Knowledge DropLast tested: Sep 6, 2019 One reason why your NDT rows and your corresponding explore query rows ...
Knowledge DropLast tested: Jan 16, 2019 persist_for can be applied to PDTs, Models and Explores.There is a sig...
Knowledge DropLast tested: Apr 4, 2020 PDTs can be shared by multiple models. When duplicates show up in the A...