Reverting a BigQuery table pushed to by Pub/Sub to a backup
I have a BigQuery table I stream updates to from Pub/Sub topic via push subscription writing to it with the topic schema.
Troubleshooting Pub/Sub to BigQuery subscription
I set up a BigQuery subscription to a Pub/Sub topic using the table schema, but when I publish a message to the topic, the data is not written to the BigQuery table. I followed Google’s troubleshooting advice, but it says the subscription is healthy and there are no error messages. I also tried the advice in this answer, but the table is set to never expire, and enabling ack messages for the subscription has no effect since it is not a pull subscription. The project does have a billing account (we have been using BigQuery for a while now).