In my never-ending quest to ensure that PDTs are building as expected, I’ve used the /explore/i__looker/pdt_log explore to put together a number of daily reports that me and my team use to ensure things are running smoothly.
I’m fairly certain we could build even more effective tooling if we could use this data in our own view and, subsequently (and awesomely), make PDTs out of this data. And now I’ve searched thoroughly enough to feel it’s time to actually ask here 😃
Is there a way to query Looker’s internal database and with that tables such as pdt_event_log? Is this even stored in “our” database (in our case Redshift) and just tidily tucked away or is it hosted SaaS-style along with our Looker instance?