Knowledge Drop

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

Userlevel 5

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.                



0 replies

Be the first to reply!