Cross-dataset Foreign Key referencing in BigQuery

In one of my previous posts I've written about the then-newly-added Primary Key/Foreign Key constraints in BigQuery. While they are not enforced like traditional RDBMS, they can still provide an improvement to query performance. They have one importa...