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

[sam8]

Knowledge Drop

Last tested: April 2021

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

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.