Hi all, I was testing the BigQuery CDC feature as demonstratedhere using a Pub/Sub push subscription with _CHANGE_TYPE, and I find it doesn't really fit my use case, and hence I want to revert it.
However I couldn't find a way to do so, I have tried deleting the Pub/Sub subscription, removing the PK from the table but still I am still getting DELETE/UPDATE/MERGE DMLs are currently not supported over tables that had UPSERT streams. So I was wondering how can I completely remove the UPSERT stream from my table so it goes back to normal?