Question

How to reference the latest PDT's in an SQL query?

  • 5 January 2022
  • 1 reply
  • 16 views

So we have PDT’s that are refreshing quite often in the company I work at. In addition to this, we need to query these PDT’s from outside looker, say through python.

Problem is that when building queries in Looker Develop it provides the full name of the PDT, the structure is something like:

pdt_database.lr$yu0631641312338859_table_name

And then a new one is generated within a given time frame with a difference UUID string before the table_name.

My question is, how can I build a query, that automatically references the latest build PDT for pdt_database.table_name without having to look up the UUID string to insert, ideally something like:
pdt_database.{LATEST}_table_name.

Kind regards,


This topic has been closed for comments

1 reply

Userlevel 7
Badge +1

Have you looked at publish_as_db_view?

https://docs.looker.com/reference/view-params/publish_as_db_view