Only US data location tables show in explorer?

[ggianfran]

It seems that only tables which have datalocation US show up in the explorer. None of my EU tables appear

[archiewood]

Hmm, all my test data is in the US, so missed this.

It seems like bigquery default to showing data from the US if you don't specify

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

Should just be a case of updating the queries that get the information schemas to check other regions too.

[archiewood]

Need to sort out #5 first.

Currently if you search in regions that dont have tables you get an error - so this needs to be rectified

[archiewood]

This is now unblocked

[archiewood]

You can now specify the location of the dataset when you set up a connection.

Due to a BQ limitation, you cannot see all tables from all regions in one connection. To see tables from multiple regions you need to add multiple connections