WITH
a AS (
SELECT
foo
FROM
`project_a.dataset_a.table_a`
),
b AS (
SELECT
foo
FROM
`project_b.dataset_b.table_b`
)
SELECT * FROM a UNION ALL SELECT * FROM b
with project_a as the configured project in my BigQuery client, bigquery-emulator errors with:
no such table: project_a_project_b_dataset_b_table_b
e.g. if I do:
with
project_a
as the configured project in my BigQuery client, bigquery-emulator errors with:no such table: project_a_project_b_dataset_b_table_b