This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a stream setup with Datastream where a PostgreSQL database on
Cloud SQL replicates to BigQuery. When data is inserted to the
PostgreSQL database, replication to BigQuery has been working just
fine.I went to delete a row from the PostgreSQL dat...
Thank you for your help, looks like all is working well now with another
attempted delete. Going forward, I think I will set the replica identity
to default: ALTER TABLE stocks REPLICA IDENTITY DEFAULT;
Thank you for the response. I created a Primary Key in the PostgreSQL
table but when I start the stream, I am getting a new error now when
starting the stream's backfill:Datastream can't create a table in
BigQuery, because the table's primary key has...
