This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

How to make PDT name never change ?

Posted a week ago
NM13
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hello,

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

0 1 43
Topic Labels
0 Likes
Reply
1 REPLY 1

Posted on --/--/---- --:-- AM
Kevin_F_McCarth
Staff
Reply posted on --/--/---- --:-- AM

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

0 Likes
Reply
Top Labels in this Space