Skip to content

One page of the bounded mismatch sample for a stage

GET
/jobs/{jobId}/runs/{runId}/results/mismatches
jobId
required
string

Job definition ID

runId
required
string

Job run ID

page
number
default: 1

Page number (1-indexed)

pageSize
number
default: 25

Items per page

workspaceId
required
string

Workspace ID

stage
required
number

Zero-based stage index to read mismatch rows for

sort
string

Column name (from the stage column manifest) to sort by

sortDirection
string
default: asc
Allowed values: asc desc

Sort direction

Page of mismatch rows

object
stage_index
required

Zero-based stage index these rows belong to

number
state
required

Whether the mismatch sample was available for this stage

string
Allowed values: ok sample_unavailable
columns
required

Column manifest describing the shape of each row

Array<object>
object
name
required

Column name as it appears in the result artifact

string
type
required

DuckDB logical type of the column, e.g. ‘VARCHAR’, ‘DOUBLE’, ‘BIGINT’, ‘BOOLEAN’, ‘TIMESTAMP’

string
role
required

Semantic role of the column in the comparison result

string
Allowed values: dimension source_value delta threshold_flag percentage_difference match_flag
measure

Measure name this column derives from (set for measure-derived columns)

string
source_index

Zero-based index of the source connection (set for source_value columns)

number
rows
required

Page of mismatch rows; keys are column-manifest names, values are scalar cell values

Array<object>
object
key
additional properties
any
pagination
required

Pagination over the bounded sample (not the full unmatched set)

object
page
required

Current page number (1-indexed)

number
pageSize
required

Items per page

number
total
required

Total number of items across all pages

number
totalPages
required

Total number of pages

number
hasMore
required

Whether more pages exist after the current one

boolean
sample_bounded
required

True when total_unmatched exceeds the rows held in the bounded sample

boolean
sample_size
required

Number of rows held in the bounded sample

number
total_unmatched
required

Total unmatched rows in the full result set, so the UI can say “showing 1,000 of 48,112”

number

Invalid stage / sort column / pagination

Job run not found