How does the PDT stable view publish (publish_as_db_view) work?

[LookerExperts]

Knowledge Drop

Last tested: Apr 7, 2020
 

As soon as a PDT build finishes, regardless of the source, a publish task gets enqueued for that PDT, assuming

• it has the publish as db View flag
• It is a prod PDT (not dev mode)

The publish task will drop the view if it exists and then create it. This is because the PDT name will change. It will do an insert to the pdt_event_log table for use by system_activity for the 'drop view'.
 

How do you check if it worked?

Look for the "action" field in system activity's PDT Log explore

Generated sql will use the pdt hash not stable name, so don't check there!

This content is subject to limited support.