google-cloud-platformgoogle-bigquerygoogle-cloud-bigtable

How to enable DML statements on BigTable via BigQuery?

I have a BigTable and I am querying it from BigQuery. For an urgent production issue, we need to delete some records based on a condition.

However when I type DELETE query, I get error saying:

DML statements are only supported over tables that have data stored in BigQuery. Unsupported table: table_name

Is there a way to delete these records from GCP console?

Solution

  • I used gcloud cbt tool to delete corresponding rows.