I was reading over some of the Datastream docs on creating streams and it mentions the following
However, you'll soon be able to create connection profiles for other destinations, including [BigQuery](https://cloud.google.com/bigquery) and [Pub/Sub](https://cloud.google.com/pubsub).
Is there a timeline on when Pub/Sub will be available as a destination? Secondly, do you know if there are any plans on supporting Pub/Sub message attributes when Pub/Sub does become available as a destination for Datastream? Thanks!
What is the recommended work-around for now? Would it be to write data to Cloud Storage, and use a pub/sub subscription on Cloud Storage (https://cloud.google.com/storage/docs/pubsub-notifications)? That seems quite wasteful of resources.
no updates at this time. please feel free to reach out to your account team, or create an issue in our public issue tracker to receive ongoing updates as they become available.
Update without Primary Key Changes: The change_type will be UPDATE.
Update with Primary Key Changes: The change_type will be UPDATE-INSERT.
However, in my case, I’m receiving Source-specific metadata where change_type is ‘UPDATE-INSERT’, even though the primary keys (‘account_id’ and ‘id’) are not changing.
For instance, the response I’m seeing includes ‘primary_keys’: [‘account_id’, ‘id’] and ‘change_type’: ‘UPDATE-INSERT’. Upon verifying the data flow in my table, these keys (‘account_id’, ‘id’) remain unchanged. Shouldn’t the change_type in this scenario be ‘UPDATE’ instead?
Could anyone advise on how to address this issue?
is there any alternate or workaround to get older value for updating field without primary key?