Weird bug in BigQuery

Question

I am trying to execute a request directly from the web console https://bigquery.cloud.google.com

It executes once, and I got the result another time when I received an error on the same request:

Error: TABLE_QUERY expressions cannot query BigQuery tables.

I also tried using different query options for "Use cached results", "Interactive", and "Batch" behavior.

Why can this happen?

Answer 1

TABLE_QUERY filters are for querying metadata only. For a short period of time, you could query the table data in your TABLE_QUERY filter; we recently closed this loophole.

We add a whitelist for customers that are negatively affected; a whitelist will allow them to query data in a single dataset in the TABLE_QUERY expression until they can update their queries.

Note that you can still use __TABLE_SUMMARY__ within TABLE_QUERY if you want, for example, to find the maximum table identifier. For instance:

 SELECT foo FROM TABLE_QUERY(my_dataset, 'table_id IN (SELECT MAX(table_id) FROM my_dataset.__TABLES_SUMMARY__ WHERE table_id CONTAINS "my_prefix")') LIMIT 1 

If this does not work for you or you want your project to be included in the white list, please contact [e-mail].