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
- BigQuery groupby, add row with count of 0 for groupby variable if no rows found
- BigQuery - Transaction is aborted due to concurrent update against table
- I keep getting Access Denied error in GCP bigQuery
- How to install firebase extension in not-interactive way
- QGIS GeoJSON Newline Delimited format compatibility with BigQuery
- Big Query - Get continuous 7 characters from a long string in Big Query
- REGEXP replace with blank
- GA4 Data Not Retained for More Than 60 Days Despite BigQuery Table Expiration Set to 'Never
- Using Google.Cloud.BigQuery.V2 API in Azure Functions
- Google BigQuery Delete Rows?
- Determine Easter Sunday BigQuery
- Does data compression actually do anything on Query->to_Arrow()?
- FIRST and LAST VALUE bringing conflicting row quantities in the same query. WHY?
- Parse Google BQ SQL queries and get all tables referenced
- Whilst deploying a GCP function, the service account keeps reverting back to its default resulting in an error
- Why does BigQuery return different random numbers in this CTE?
- Max number of partitions that can be created on bigquery table
- NOAA data in BigQuery not being updated?
- BigQuery - DELETE statement to remove duplicates
- Splitting a string column in BigQuery
- How to write a dataframe to BigQuery and overwrite partition instead of the table?
- Add Date column base on other columns in Bigquery
- How can I get the last element of an array? SQL Bigquery
- Google BigQuery: how to create a new column with SQL
- Is it possible to replicate across projects when doing "Cross-region dataset replication" in BigQuery?
- How to display Airflow DAG status in Big Query tables
- big query data transformation logic
- What is the correct fields in `time_partitioning` for GCSToBigQueryOperator in Airflow
- Set Spark configuration when running python in dbt for BigQuery
- Scheduling queries: Is there a way to bypass the minimum 15min interval?