SYNQ Recon Audit Log

Type: object

Audit log capturing all operations performed during a synq-recon reconciliation run

root version
Type: const

Schema version

Specific value: "1"

root invocation_id
Type: stringFormat: uuid

Unique identifier for this invocation/run

root meta
Type: object

AuditMeta holds build and environment metadata for the synq-recon binary.

root meta version
Type: string

Module version or tag (e.g. v1.2.3)

root meta vcs_commit
Type: string

VCS revision hash

root meta vcs_time
Type: string

VCS commit timestamp (RFC3339)

root meta vcs_dirty
Type: boolean

True if the working tree had uncommitted changes

root meta go_version
Type: string

Go toolchain version used to build the binary

root config_file
Type: string

Path to the configuration file used

root suite
Type: string

Machine identifier for the config suite (from YAML name field or filename)

root suite_title
Type: string

Human-readable title of the config suite (from YAML title field or falls back to suite id)

root description
Type: string

Longer description of the configuration suite

root variables
Type: object

Resolved template variable values used for query interpolation

Each additional property must conform to the following schema

root variables additionalProperties
Type: string

root started_at
Type: stringFormat: date-time

RFC3339 timestamp when the run started

root completed_at
Type: stringFormat: date-time

RFC3339 timestamp when the run completed

root duration_ms
Type: integer

Total run duration in milliseconds

Value must be greater or equal to 0

root warnings
Type: array of string

Suite-level warnings detected during config validation

 No Additional Items

Each item of this array must be:

root warnings warnings items
Type: string

root reconciliations
Type: array

Audit records for each reconciliation executed

 No Additional Items

Each item of this array must be:

root reconciliations ReconciliationAudit
Type: object

ReconciliationAudit captures everything about a single reconciliation execution.

root reconciliations reconciliations items name
Type: string

Machine identifier (YAML key)

root reconciliations reconciliations items title
Type: string

Human-readable title (from YAML title field or falls back to name)

root reconciliations reconciliations items mode
Type: enum (of string)

Must be one of:

  • "row_count"
  • "full"
  • "aggregate"

root reconciliations reconciliations items source
Type: object

DatasetInfo identifies a source or target dataset.

root reconciliations reconciliations items target
Type: object

DatasetInfo identifies a source or target dataset.

Same definition as source

root reconciliations reconciliations items columns
Type: array of string
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items columns columns items
Type: string

root reconciliations reconciliations items normalization
Type: object

Normalization records the column expressions used after cross-DB type alignment.

root reconciliations reconciliations items normalization source_columns
Type: array of string
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items normalization source_columns source_columns items
Type: string

root reconciliations reconciliations items normalization target_columns
Type: array of string
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items normalization target_columns target_columns items
Type: string

root reconciliations reconciliations items column_mapping
Type: object

Each additional property must conform to the following schema

root reconciliations reconciliations items column_mapping additionalProperties
Type: string

root reconciliations reconciliations items stages
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages StageAudit
Type: object

StageAudit captures one reconciliation stage (quickcheck, bisectiondrill, aggregate_check).

root reconciliations reconciliations items stages stages items stage
Type: enum (of string)

Must be one of:

  • "quick_check"
  • "bisection_drill"
  • "aggregate_check"

root reconciliations reconciliations items stages stages items duration_ms
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items queries
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items queries QueryRecord
Type: object

QueryRecord captures a single SQL query execution.

root reconciliations reconciliations items stages stages items queries queries items role
Type: enum (of string)

Must be one of:

  • "source"
  • "target"

root reconciliations reconciliations items stages stages items queries queries items duration_ms
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items queries queries items rows_returned
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items queries queries items retry_attempt
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items queries queries items stats
Type: object

QueryStats holds execution statistics collected from the database driver.

root reconciliations reconciliations items stages stages items queries queries items stats query_id
Type: string

QueryID is the database-assigned query identifier for auditing.
Available for BigQuery (job ID), Snowflake, ClickHouse (client-generated).

root reconciliations reconciliations items stages stages items queries queries items stats rows_read
Type: integer

RowsRead is the number of rows read/scanned by the query engine.

root reconciliations reconciliations items stages stages items queries queries items stats bytes_read
Type: integer

BytesRead is the number of bytes read/scanned by the query engine.

root reconciliations reconciliations items stages stages items queries queries items stats rows_produced
Type: integer

RowsProduced is the number of result rows returned to the caller.

root reconciliations reconciliations items stages stages items queries queries items stats cache_hit
Type: boolean

CacheHit indicates whether the query result was served from cache.

root reconciliations reconciliations items stages stages items queries queries items stats bytes_billed
Type: integer

BytesBilled is the number of bytes billed (BigQuery).

root reconciliations reconciliations items stages stages items queries queries items stats slot_millis
Type: integer

SlotMillis is the slot time consumed (BigQuery).

root reconciliations reconciliations items stages stages items queries queries items stats blocks
Type: integer

Blocks is the number of data blocks read (ClickHouse).

root reconciliations reconciliations items stages stages items queries queries items stats completed_splits
Type: integer

CompletedSplits is the number of completed splits (Trino).

root reconciliations reconciliations items stages stages items queries queries items stats cpu_time_millis
Type: integer

CPUTimeMillis is the CPU time consumed (Trino).

root reconciliations reconciliations items stages stages items queries queries items stats wall_time_millis
Type: integer

WallTimeMillis is the wall time reported by the engine (Trino).

root reconciliations reconciliations items stages stages items segment_tree
Type: object

SegmentAuditNode represents a node in the bisection segment tree with query references.

root reconciliations reconciliations items stages stages items segment_tree segment
Type: object

SegmentInfo identifies a key range segment.

root reconciliations reconciliations items stages stages items segment_tree segment depth
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items segment_tree segment index
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items segment_tree termination_reason
Type: enum (of string)

Must be one of:

  • "threshold_reached"
  • "max_depth_reached"
  • "empty_segment"
  • "cannot_split"
  • "matched"
  • "error"

root reconciliations reconciliations items stages stages items segment_tree mismatch_rows_in_subtree
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items segment_tree total_rows_in_subtree
Type: integer

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items segment_tree children
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items segment_tree children SegmentAuditNode
Type: object

SegmentAuditNode represents a node in the bisection segment tree with query references.

Same definition as segment_tree

root reconciliations reconciliations items stages stages items segment_tree row_mismatches
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items segment_tree row_mismatches RowMismatchAudit
Type: object

RowMismatchAudit captures a single row-level mismatch in the audit log.

root reconciliations reconciliations items stages stages items segment_tree row_mismatches row_mismatches items type
Type: enum (of string)

Must be one of:

  • "missing_in_target"
  • "missing_in_source"
  • "modified"

root reconciliations reconciliations items stages stages items result

root reconciliations reconciliations items stages stages items result anyOf QuickCheckStageResult
Type: object

QuickCheckStageResult is the typed result for a quick_check stage.
root reconciliations reconciliations items stages stages items result anyOf BisectionStageResult
Type: object

BisectionStageResult is the typed result for a bisection_drill stage.

root reconciliations reconciliations items stages stages items result anyOf item 1 statistics
Type: object

BisectionStatistics holds statistics about the bisection segment tree.

root reconciliations reconciliations items stages stages items result anyOf item 1 statistics depth_distribution
Type: object
No Additional Properties

All properties whose name matches the following regular expression must respect the following conditions

Property name regular expression: ^[0-9]+$
root reconciliations reconciliations items stages stages items result anyOf item 1 statistics depth_distribution ^[0-9]+$
Type: integer

root reconciliations reconciliations items stages stages items result anyOf item 1 statistics mismatch_by_depth
Type: object
No Additional Properties

All properties whose name matches the following regular expression must respect the following conditions

Property name regular expression: ^[0-9]+$
root reconciliations reconciliations items stages stages items result anyOf item 1 statistics mismatch_by_depth ^[0-9]+$
Type: integer

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves MismatchLeafDetail
Type: object

MismatchLeafDetail holds detailed information about a single mismatch leaf.

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves mismatch_leaves items segment
Type: object

MismatchLeafSegment identifies the segment of a mismatch leaf.

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves mismatch_leaves items mismatch_types
Type: array of enum (of string)
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves mismatch_leaves items mismatch_types mismatch_types items
Type: enum (of string)

Must be one of:

  • "missing_in_source"
  • "missing_in_target"
  • "count_mismatch"
  • "data_mismatch"
  • "unknown"

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves mismatch_leaves items termination_reason
Type: enum (of string)

Must be one of:

  • "threshold_reached"
  • "max_depth_reached"
  • "empty_segment"
  • "cannot_split"
  • "matched"
  • "error"

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves mismatch_leaves items row_mismatches
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves mismatch_leaves items row_mismatches RowMismatchDetail
Type: object

RowMismatchDetail holds per-row mismatch detail in the stage result.

root reconciliations reconciliations items stages stages items result anyOf item 1 mismatch_leaves mismatch_leaves items row_mismatches row_mismatches items type
Type: enum (of string)

Must be one of:

  • "missing_in_target"
  • "missing_in_source"
  • "modified"

root reconciliations reconciliations items stages stages items result anyOf item 1 investigation_queries
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result anyOf item 1 investigation_queries InvestigationQuery
Type: object

InvestigationQuery represents a merged diff query covering one or more adjacent mismatch leaves.

root reconciliations reconciliations items stages stages items result anyOf AggregateStageResult
Type: object

AggregateStageResult is the typed result for an aggregate_check stage.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down
Type: object

AggregateDrillNode represents a node in the hierarchical aggregate drill-down tree.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children
Type: array
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children AggregateDrillChild
Type: object

AggregateDrillChild represents a single divergent group within a drill-down level.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items type
Type: enum (of string)

Must be one of:

  • "mismatch"
  • "missing_source"
  • "missing_target"
  • "value_mismatch"

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items differences
Type: object

MeasureDifferences holds all difference variants for measure comparisons.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items differences relative
Type: object

Relative difference per measure (target - source). Positive means target is larger.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items differences absolute
Type: object

Absolute difference per measure: |target - source|. Always non-negative.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items differences pct_vs_source
Type: object

Percentage difference relative to source: |diff| / |source|.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items differences pct_vs_target
Type: object

Percentage difference relative to target: |diff| / |target|.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items differences pct_symmetric
Type: object

Symmetric percentage difference: 2*|diff| / (|source| + |target|).

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation
Type: object

ThresholdEvaluation captures the effective thresholds applied and per-measure verdicts.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation absolute_threshold
Type: number

AbsoluteThreshold is the configured maximum absolute difference, or 0 if not set.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation percentage_threshold
Type: number

PercentageThreshold is the configured maximum percentage difference, or 0 if not set.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation percentage_mode
Type: string

PercentageMode is which percentage formula was used: source, target, or symmetric.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation measures
Type: object

Measures holds per-measure threshold evaluation results.

Each additional property must conform to the following schema

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation measures MeasureVerdict
Type: object

MeasureVerdict captures the threshold evaluation result for a single measure.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation measures additionalProperties exceeded
Type: boolean

Exceeded is true when the measure difference exceeds all configured thresholds.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation measures additionalProperties reason
Type: enum (of string)

Reason explains why the measure was considered within or outside thresholds.

Must be one of:

  • "exact_match"
  • "within_absolute_threshold"
  • "within_percentage_threshold"
  • "exceeded_all_thresholds"
  • "no_thresholds_configured"

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation measures additionalProperties effective_absolute
Type: number

EffectiveAbsolute is the absolute threshold that was applied to this measure (may differ per measure via per_measure config).

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items threshold_evaluation measures additionalProperties effective_percentage
Type: number

EffectivePercentage is the percentage threshold that was applied to this measure.

root reconciliations reconciliations items stages stages items result anyOf item 2 drill_down children children items drill_down
Type: object

AggregateDrillNode represents a node in the hierarchical aggregate drill-down tree.

Same definition as drill_down

root reconciliations reconciliations items warnings
Type: array of string
No Additional Items

Each item of this array must be:

root reconciliations reconciliations items warnings warnings items
Type: string

root reconciliations reconciliations items status
Type: enum (of string)

Outcome of this reconciliation

Must be one of:

  • "passed"
  • "failed"
  • "mismatched"
  • "mismatched_within_threshold"

root total_stats
Type: object

QueryStats holds execution statistics collected from the database driver.

Same definition as stats

root status
Type: enum (of string)

Overall execution status derived from individual reconciliation outcomes

Must be one of:

  • "passed"
  • "failed"
  • "mismatched"
  • "mismatched_within_threshold"

root summary
Type: object

AuditSummary holds aggregated counts derived from individual reconciliation results.

root summary overall_match
Type: boolean

True when every reconciliation matched (exactly or within threshold)

root summary total
Type: integer

Total number of reconciliations executed

Value must be greater or equal to 0

root summary matched
Type: integer

Number of reconciliations that completed and matched exactly

Value must be greater or equal to 0

root summary matched_within_threshold
Type: integer

Number of reconciliations that had differences within configured thresholds

Value must be greater or equal to 0

root summary mismatched
Type: integer

Number of reconciliations that completed but found data differences exceeding thresholds

Value must be greater or equal to 0

root summary failed
Type: integer

Number of reconciliations that encountered an infrastructure error

Value must be greater or equal to 0