Write rows to dataset table

POST

/dataset-tables/{tableId}/rows

Write data to a dataset table. Supports JSON or Arrow IPC format.

Query Parameters:

• mode: Write operation mode
  • append: Insert new rows without checking for duplicates (fastest)
  • upsert: Insert new rows or update existing rows by primary key
  • overwrite: Replace all existing data in the table
  • delete: Delete rows by primary key
• idempotency_key: Optional key for exactly-once semantics
• skip_validation: Skip schema validation (faster but riskier)

Content Types:

• application/json: Body is array of row objects (or array of PKs for delete)
• application/vnd.apache.arrow.stream: Body is raw Arrow IPC bytes

Parameters

Path Parameters

tableId

required

string

Query Parameters

mode

required

string

Allowed values: upsert append delete overwrite

idempotency_key

string

skip_validation

boolean

nullable

Responses

200

Rows written successfully

object

rows_affected

required

number

rows_inserted

number

rows_updated

number

rows_deleted

number

dataset_version

required

number

duration_ms

required

number

warnings

Array<string>

usage

object

getOptsCold

required

number

getOptsWarm

required

number

getRangeCold

required

number

getRangeWarm

required

number

getRangesCold

required

number

getRangesWarm

required

number

headCold

required

number

headWarm

required

number

listCold

required

number

listWarm

required

number

putOperations

required

number

deleteOperations

required

number

cacheHitRatePercent

required

number

readBytesCold

required

number

readBytesWarm

required

number

writeBytes

required

number

400

Bad request - invalid data or schema mismatch

403

Forbidden - insufficient permissions to write to this table

404

Dataset table not found

500

Internal server error - ingestion failed