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/...

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?

Answer 1

Under advanced settings, ensure it is set to "write if empty" and not append or overwrite if the table is being created for the first time.

Answer 2

I had experience similar Error ,where table is not been created and some unknown error popup in dialog

The way I solved it just Closed down all of my chrome browser and refresh my pc and then restart the browser . This time every thing worked fine

Answer 3

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