materialization id for

GEISJ
New Member

Hi all, 

hope your doing fine. 

I am currently working with the Looker API and Python. And there is this call: ​​​​​​https://cloud.google.com/looker/developers/api/reference/latest/methods/DerivedTable/check_pdt_build

I was wondering where I can get the latest materialization_id ( in an automated way in the best case szenario) for a specific PDT or all the PDTs? 

Can Anyone support?
 

Asked differently (or maybe 2nd question): Is there a way to check the information displayed in the Admin Section (Persistent Derived Tables - shown in the picture below) with the help of the Looker API? 

9886305d-ccf5-4379-bb22-9a5691a9c7dd.png

(picture from here: https://cloud.google.com/looker/docs/admin-panel-database-pdts).

Many thanks for your support!

Enjoy your day.

Best,

Jonathan

0 2 157
2 REPLIES 2

Randomly I was looking at this today thinking same thing and just happened to see your post here.

my guess at the time was that you have to kick off a build and that returns that ID which you can then plug into the status endpoint. Just a guess.

I am fairly confident you won’t be able to do this for agg tables as we have issues with these not actually behaving in the same way as pdts.

GEISJ
New Member

Hey 

thanks for your reply. I figured as much as well. Unfortunatly this is not a very pleasant solution for us and probably not a way to move forward. 
And I would expect to be able to check out the status of all the builds somehow.  

Anyway thanks for your input and have a great day.