How to manually query a cache table in BigQuery-CodePudding

Let's say I have the following query:

select 1

If I run the query again it will grab it from cache:

Query complete (0.1 sec elapsed, cached)

However, if I run a query like:

SELECT 1

It will not grab it from cache. Is there a way to manually query the cache table? For example, converting SELECT 1 into the query SELECT * FROM name_of_cache_table?

Query normalization works in the above case, but for our purposes we're looking to be able to directly access cache as necessary.

CodePudding user response：

It is possible to query the cached table since it creates an anonymous table. See

Try querying one of these tables:

SELECT
 * 
FROM
 `_730f58d68c6f40ed0335322e46c4c87cer3af6290.anon36335c2bcd73b61558b7028ca8666efac3802a28`

Result from anonymous table: