Bigtable in BigQuery “Failed to create table: Not found”

Question

Trying to add an external Bigtable table to BigQuery by following these instructions. I've double checked my PROJECT_ID, INSTANCE_ID and TABLE_ID are all correct and have seemingly conducted my URL properly following the prescribed format https://googleapis.com/bigtable/projects/[PROJECT_ID]/instances/[INSTANCE_ID]/tables/[TABLE_NAME].

When I attempt to create the table, I get an error message:

Failed to create table: Not found: URI https://googleapis.com/bigtable/projects/...

Error

Searched around to see if anyone else has encountered this, but haven't seen anything. The instance in question is a development instance, I'm not sure if that matters for BigQuery or not. Anyone know if there's additional IAM configuration needed for BigQuery to be able to access the table?

I think the issue is the zone that the instance was created in. The docs indicate instances have to be located in us-central1-b and us-central1-c for BigQuery to work but I'm unable to create an instance in those zones. I only have us-central1-f. — Mike Sukmanowsky
I've raised an issue here: issuetracker.google.com/issues/72240210 — Graham Polley

Graham Polley Graham Polley · Accepted Answer · 2018-01-20T03:05:21

Looks like the UI is missing some zones from the drop down. Use the gcloud tool instead, and set the desired zone that will work with BigQuery. For example:

gcloud beta bigtable instances create bigstuff --cluster=bigstuff-cluster --cluster-zone=us-central1-b --cluster-num-nodes=3 --description=stuff

Bigtable in BigQuery “Failed to create table: Not found”

1 Answers