Knowledge Drop

Can the PDT scratch schema exist in a different db host than the original tables used to create it?


Userlevel 4
Badge
  • Looker Staff
  • 158 replies

Last tested: April 2021

 

No. Even PDT Override doesn't allow for this.

Screen Shot 2021-04-25 at 02.16.24.png

The challenge here is that Looker would have to issue a multi part query: first to the database with the PDTs, and then to the database with the actual tables. Writing a coherent query with joins and such that involves two different databases is outside the scope of our product at this time. The closest we can get is to "join" two different queries on the frontend using Merged Results.

 

 

This content is subject to limited support.                


0 replies

Be the first to reply!

Reply