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.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Ms SQL server to gcp bigquery using Datastream

Posted on 02-13-2025 12:48 AM
Vigneshanandara
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I have a table in Ms SQL server. I am replicating the table to gcp bigquery using datastream with write mode as merge.  Back file is successful. When a row is  inserted to the source table it gets replicated with out any issues. When I delete a row in source table I get a new record in bigquery, instead of deleting. When I update a record in source, I get two record inserted with the data stream to bigquery metadata as isdelete is true and the new one as false. The old record is not updated or removed it also has the metadata of the stream is deleted as false.

What is the issue here?

0 1 166
0 Likes
1 REPLY 1
Top Labels in this Space
Top Solution Authors
View all