We are using the People with Significant Control (PSC) snapshot, which provides a full downloadable dataset of PSC records. After successfully loading the snapshot data into our data platform and creating the required tables, we plan to consume the PSC Streaming API for ongoing incremental updates using the timepoint parameter.
Could you advise on the recommended approach for transitioning from the bulk snapshot to the Streaming API without missing any updates?
Specifically, how does Companies House recommend consumers handle the period between:
- The point in time when the snapshot was generated,
- The completion of snapshot ingestion into the target platform, and
- The establishment of the Streaming API connection?
Is there a way to obtain the bulk snapshot’s associated timepoint, or another recommended mechanism to ensure no changes are missed or duplicated during the handover from the bulk snapshot to the stream?