Bigtable in BigQuery "Failed to create table: Not found"
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?
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
- Is there a way to measure string similarity in Google BigQuery
- Finding the most frequent value of string using BigQuery
- How to calculate a unit price with a recursive Tree structure in a database
- How to automatically back up and version BigQuery code such as stored procs?
- Error loading file stored in Google Cloud Storage to Big Query
- How to configure federated query from Google BigQuery to Google AlloyDB?
- BigQuery Policy Tags: possible as infra as code?
- How to use GCP Translation API to process a table in BigQuery?
- How to enable DML statements on BigTable via BigQuery?
- BigQuery: include procedures when copying a dataset
- Backquote usage in BigQuery for table names - UI vs API
- Grab the values from url that is in between specific characters BigQuery
- how to check if date is within the same month as date in another column SQL BQ
- How to pass a parameter into bigquery query on colab
- How to find MIN() of sorted aggregates without using loops
- Can I prevent duplicate data in bigquery?
- How to Concatenate Data from Different Rows into One in BigQuery
- How to include DeltaLake Files from GCS to BigQuery
- Uploading multiple local parquet files to bq
- What does sql error "Analytic function cannot be an argument of another analytic function" mean?
- Issue with the IS NULL function in BigQuery
- Getting an error : AttributeError: 'MySchemaClassName' object has no attribute "..type '' while working with apache_beam to_dataframe module
- How to give access to a single Bigquery Dataset for a user to access the data in Datalooker?
- How to drop multiple tables in Big query using Wildcards TABLE_DATE_RANGE()?
- Big query multi-statement with a declare
- Delete old rows in change log for Firestore to BigQuery Extenstion
- Max number of partitions that can be created on bigquery table
- How to write data from apache beam using gcp dataflow to bigquery table?
- Is it possible in BigQuery to alias a splat?
- How to order and limit for a unique column value SQL