How to make PDT name never change ?

Looker Q&A Looker
1

Hello,

I need some info on how to make PDT name static and chosen by us and not change with every datagroup trigger .

2

Hello NM13,

Looker product has a feature which is designed to provide support for your use case. Please see documentation for the publish_db_as_view parameter for explanation. I will just add:

  • If you are wondering why this creates a view - this allows looker to keep the existing PDT intact for user querying while building the new physical table… looker then always updates the view to point to the newest version of the table.

If that doesn’t fully suit your needs, it may be appropriate in your case to achieve more custom behavior (like writing to a specific physical table) using the create_process parameter.

I hope this helps!.

Best Regards,
Kevin