Query to Retrieve all region Datasets

[Luffy]

Hello Everyone,

the below query gives us the details of the datasets present in our DB

SELECT

  *

FROM

  INFORMATION_SCHEMA.SCHEMATA;

and to access location specific we put in a parameter of region-REGION where REGION is the region we wish to query on.

https://cloud.google.com/bigquery/docs/information-schema-datasets

How do we get all region datasets in one generic query ?

any help is appreciated!

[osvaldolopez]

Here is a workaround of what you're looking for. This other post also may be helpful.