Can BigQuery View reference other Tables and Views from different datasets/projects?

Viewed 1247

According to BigQuery Views docs: "Also, views can only reference other tables and views with the same Dataset location."

But in fact i can create a View like this (query is just for example):

SELECT a.body 
FROM [fh-bigquery:reddit_comments.2008] as a
inner JOIN flatten([bigquery-samples:playlists.playlists],tracks.data)
as b ON a.author=b.tracks.data.artist.name

And then reference this view in query like a normal table:

SELECT * FROM [flow-1202:alex_centre.test_v_501] LIMIT 1000

And it works.

Do we have more restrictions when using Views instead of Subqueries in BigQuery?

1 Answers
Related