Zum Hauptinhalt springen

Upsert Records by Primary Key

POST 
/reference-datasets/:dataset_id/records/upsert

Upsert records in the current version by primary key.

Existing rows matching a primary-key value are updated with the provided columns; unknown primary-key values are inserted as new rows. The current version is mutated in place — no new version is created (same semantics as append). To checkpoint the mutated state into a new immutable version, call POST /reference-datasets/{id}/versions/snapshot afterwards. Maximum file size is 1GB.

Requires primary_key_column to be set on the dataset; otherwise returns 400. Introducing new columns via upsert is rejected (422) — use the versions endpoint for schema evolution.

Parameters:

  • dataset_id: UUID of the reference dataset
  • file: Parquet file with rows to upsert (multipart/form-data)

Request​

Responses​

Current version mutated in place with rows upserted by primary key