How to Save a View in BigQuery - Standard SQL Dialect

Question

I am trying to save a view using the BigQuery WebUI that was created in the standard SQL dialog box, but I get this error:

Failed to save view. Bad link table "myDataset.myTable"; tables in standard SQL views require explicit project identifiers

Why does this error appear? How can i fix this? Should the "Table ID" field of the "Save View" dialog box include the project identifier? Or is this error due to the request itself? Just in case, the request is executed without any problems.

Thank you for your help.

Answer 1

In your view, there is a link to myDataset.myTable - this is normal when you simply run it as a request (for example, in the web interface).

But to save it as a view, you must fully define this link below

 myProject.myDataset.myTable 

So just add the project to this link