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 tool_version
Type: string

synq-recon binary version

root config_file
Type: string

Path to the configuration file used

root description
Type: string

Human-readable description of the configuration suite

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 reconciliations
Type: array

Audit records for each reconciliation executed

 No Additional Items

Each item of this array must be:

root reconciliations reconciliation_audit
Type: object

root reconciliations reconciliations items name
Type: string

Reconciliation name from config

root reconciliations reconciliations items description
Type: string

Human-readable description

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

Reconciliation mode

Must be one of:

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

root reconciliations reconciliations items config
Type: object

Full reconciliation configuration after defaults are applied

root reconciliations reconciliations items config description
Type: string

Human-readable description of the reconciliation

root reconciliations reconciliations items config source
Type: object

root reconciliations reconciliations items config source as_of
Type: string

Time-travel timestamp for snapshot comparison

root reconciliations reconciliations items config target
Type: object

root reconciliations reconciliations items config target as_of
Type: string

Time-travel timestamp for snapshot comparison

root reconciliations reconciliations items config column_mapping
Type: object

Each additional property must conform to the following schema

root reconciliations reconciliations items config column_mapping additionalProperties
Type: string

root reconciliations reconciliations items raw_config
Type: object

Original reconciliation configuration as written in the YAML file, before defaults are applied

root reconciliations reconciliations items source
Type: object

root reconciliations reconciliations items source connection
Type: string

Connection name from config

root reconciliations reconciliations items source dialect
Type: string

Database dialect (postgres, snowflake, bigquery, etc.)

root reconciliations reconciliations items source query
Type: string

Base SQL query for this dataset

root reconciliations reconciliations items key_column
Type: string

Column used for bisection key ranges

root reconciliations reconciliations items hash_algorithm
Type: string

Hash algorithm negotiated or configured

root reconciliations reconciliations items columns
Type: array of string

Columns extracted from source query

 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

root reconciliations reconciliations items normalization source_columns
Type: array of string

Normalized column expressions for source

 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

Normalized column expressions for target

 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

Column name mapping from source to target (e.g., {userid: USERID})

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

Ordered list of stages executed

 No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stage_audit
Type: object

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

Stage type

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 config
Type: object

Stage-specific configuration (e.g., bisection factor/threshold)

root reconciliations reconciliations items stages stages items queries
Type: array

All queries executed during this stage

 No Additional Items

Each item of this array must be:

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

root reconciliations reconciliations items stages stages items queries queries items id
Type: string

Unique query identifier for cross-referencing

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

Whether this query ran against source or target

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

Number of rows returned by the query

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items queries queries items error
Type: string or null

Error message if query failed

root reconciliations reconciliations items stages stages items segment_tree
Type: object

Segment tree for bisection drill-down stages

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

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

Inclusive lower bound (null = unbounded)

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

Exclusive upper bound (null = unbounded)

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)

Why the segment became a leaf node

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

Total source rows in mismatched leaves beneath this node

Value must be greater or equal to 0

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

Total source rows across all leaves beneath this node

Value must be greater or equal to 0

root reconciliations reconciliations items stages stages items segment_tree query_ids
Type: array of string

IDs of queries that produced this segment's data

 No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items segment_tree query_ids query_ids items
Type: string

root reconciliations reconciliations items stages stages items segment_tree row_mismatches
Type: array

Per-row hash comparison results at leaf segments

 No Additional Items

Each item of this array must be:

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

A single row-level mismatch identified by per-row hash comparison

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

Type of row mismatch

Must be one of:

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

root reconciliations reconciliations items stages stages items segment_tree row_mismatches row_mismatches items source_row_hash
Type: integer

Row hash from source (absent for missinginsource)

root reconciliations reconciliations items stages stages items segment_tree row_mismatches row_mismatches items target_row_hash
Type: integer

Row hash from target (absent for missingintarget)

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

Actual column values from source row (only present at 'detailed' reporting level)

Each additional property must conform to the following schema

root reconciliations reconciliations items stages stages items segment_tree row_mismatches row_mismatches items source_values additionalProperties
Type: string

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

Actual column values from target row (only present at 'detailed' reporting level)

Each additional property must conform to the following schema

root reconciliations reconciliations items stages stages items segment_tree row_mismatches row_mismatches items target_values additionalProperties
Type: string

root reconciliations reconciliations items stages stages items result
Type: object

Stage result summary

root reconciliations reconciliations items stages stages items result statistics
Type: object

Bisection tree statistics

root reconciliations reconciliations items stages stages items result statistics total_nodes
Type: integer

Total nodes in bisection tree

root reconciliations reconciliations items stages stages items result statistics matched_nodes
Type: integer

Nodes where source and target match

root reconciliations reconciliations items stages stages items result statistics mismatched_nodes
Type: integer

Nodes where source and target differ

root reconciliations reconciliations items stages stages items result statistics intermediate_nodes
Type: integer

Total intermediate (non-leaf) nodes

root reconciliations reconciliations items stages stages items result statistics depth_distribution
Type: object

Count of nodes at each depth level (e.g., {"0": 1, "1": 4, "2": 16})

Each additional property must conform to the following schema

root reconciliations reconciliations items stages stages items result statistics depth_distribution additionalProperties
Type: integer

root reconciliations reconciliations items stages stages items result statistics mismatch_by_depth
Type: object

Count of mismatched nodes at each depth level

Each additional property must conform to the following schema

root reconciliations reconciliations items stages stages items result statistics mismatch_by_depth additionalProperties
Type: integer

root reconciliations reconciliations items stages stages items result statistics per_depth
Type: object

Per-depth-level breakdown of rows and segments (e.g., {"0": {totalrows: 500, mismatchedrows: 16, ...}})

Each additional property must conform to the following schema

root reconciliations reconciliations items stages stages items result statistics per_depth depth_stats
Type: object

Per-depth-level statistics for the bisection tree

root reconciliations reconciliations items stages stages items result statistics per_depth additionalProperties mismatched_rows
Type: integer

Source rows in mismatched segments at this depth level

root reconciliations reconciliations items stages stages items result statistics total_source_rows
Type: integer

Total rows in source across all segments

root reconciliations reconciliations items stages stages items result statistics total_target_rows
Type: integer

Total rows in target across all segments

root reconciliations reconciliations items stages stages items result statistics mismatch_source_rows
Type: integer

Total rows in source that are in mismatched segments

root reconciliations reconciliations items stages stages items result statistics mismatch_target_rows
Type: integer

Total rows in target that are in mismatched segments

root reconciliations reconciliations items stages stages items result mismatch_leaves
Type: array of object

Details of leaf segments that have mismatches

 No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result mismatch_leaves mismatch_leaves items
Type: object

root reconciliations reconciliations items stages stages items result mismatch_leaves mismatch_leaves items mismatch_types
Type: array of enum (of string)

Types of mismatch detected (can be multiple, e.g., both count and data)

 No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result 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 mismatch_leaves mismatch_leaves items termination_reason
Type: enum (of string)

Why the drill-down stopped at this leaf

Must be one of:

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

root reconciliations reconciliations items stages stages items result mismatch_leaves mismatch_leaves items diff_queries
Type: object

Ready-to-execute SQL queries for investigating this mismatch

root reconciliations reconciliations items stages stages items result mismatch_leaves mismatch_leaves items diff_queries source_rows
Type: string

SQL query to retrieve all source rows in the mismatched segment

root reconciliations reconciliations items stages stages items result mismatch_leaves mismatch_leaves items diff_queries target_rows
Type: string

SQL query to retrieve all target rows in the mismatched segment

root reconciliations reconciliations items stages stages items result investigation_queries
Type: array

Merged investigation queries covering adjacent mismatch leaf segments

 No Additional Items

Each item of this array must be:

root reconciliations reconciliations items stages stages items result investigation_queries investigation_query
Type: object

A merged investigation query covering one or more adjacent mismatch leaf segments

root reconciliations reconciliations items stages stages items result investigation_queries investigation_queries items min_key
Type: object

Inclusive lower bound of the merged key range (null = unbounded)

root reconciliations reconciliations items stages stages items result investigation_queries investigation_queries items max_key
Type: object

Exclusive upper bound of the merged key range (null = unbounded)

root reconciliations reconciliations items stages stages items result investigation_queries investigation_queries items leaves_covered
Type: integer

Number of mismatch leaf segments covered by this query

Value must be greater or equal to 1

root reconciliations reconciliations items stages stages items result investigation_queries investigation_queries items source_query
Type: string

SQL query to retrieve source rows in the merged key range

root reconciliations reconciliations items stages stages items result investigation_queries investigation_queries items target_query
Type: string

SQL query to retrieve target rows in the merged key range

root reconciliations reconciliations items overall_match
Type: boolean

Whether the reconciliation passed overall

root reconciliations reconciliations items error
Type: string or null

Error message if reconciliation failed