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?
I used gcloud cbt tool to delete corresponding rows.