Federated table/query not working - "Cannot read in location: us-west1"

Question

I have a GCS bucket in US-WEST1:

That bucket has two files:

1. wiki_1b_000000000000.csv.gz
2. wiki_1b_000000000001.csv.gz

I've created a external table definition to read those files like so:

The dataset where this external table definition exists is also in the US.

When I query it with:

SELECT
  *
FROM
  `grey-sort-challenge.bigtable.federated`
LIMIT
  100

..I get the following error:

Error: Cannot read in location: us-west1

I tested with asia-northeast1 and it works fine.

Why isn't this working for the US region?

Answer 1

Faced the same earlier. See G's answer - must use us-central1 for now: https://issuetracker.google.com/issues/76127552#comment11