Query view from BigQuery to temporal table so it could be consumed by Storage API

I want to use Storage API to read a lot of rows from a view on bigQuery.
I’m using Java 🙂

There is a limitation on Storage API, it cannot consume from views. (https://cloud.google.com/bigquery/docs/reference/storage#limitations)

So my question is, how can I query it?
Is there a simple way of creating a temporal table with my query and getting that tableId so I can use StorageAPI to read from there?

You need to sign in to view this answers