What happens if I manually stop/kill a Building PDT in admin/queries?

[Dean_Hicks]

Knowledge Drop

Last tested: Sep 14, 2020
 

• If the PDT build was initiated by the regenerator (sql_trigger_value or datagroup_trigger, the current build will be cancelled, along with the current regenerator cycle. The PDT will remain triggered and the regenerator will initiate another build/rebuild the next regenerator cycle.
• If your PDT build was initiated by an explore query (persist_for, dev mode PDTs, trigger PDTs that have not been built yet), Looker will wait until the next time the table is used in a query to rebuild it or in the case of a trigger PDT, the regenerator will attempt to build the next regenerator cycle.
• If your PDT build was initiated via the Rebuild Derived Tables and Run option, the existing PDT will be used. A rebuild will not be initiated until it is triggered for rebuild.

This content is subject to limited support.