dataset reconciliation derived

{
  "input": {
    "body": {
      "key": [
        {
          "left": "order_id",
          "right": "orderId"
        }
      ],
      "left": {
        "csv": "order_id,amount,status\n1001,42.50,shipped\n1002,19.99,pending\n1003,7.00,shipped\n",
        "name": "source_export"
      },
      "right": {
        "csv": "orderId,amount,status\n1001,42.5,shipped\n1002,19.99,PENDING\n1004,3.00,shipped\n",
        "name": "warehouse"
      }
    },
    "type": "http",
    "method": "POST",
    "bodyType": "json"
  },
  "output": {
    "type": "json",
    "example": {
      "left": {
        "name": "source_export",
        "read_row_count": 3,
        "joinable_key_count": 3,
        "supplied_row_count": 3,
        "empty_key_row_count": 0,
        "duplicated_key_count": 0
      },
      "right": {
        "name": "warehouse",
        "read_row_count": 3,
        "joinable_key_count": 3,
        "supplied_row_count": 3,
        "empty_key_row_count": 0,
        "duplicated_key_count": 0
      },
      "limits": {
        "maxColumns": 64,
        "maxCsvBytes": 262144,
        "maxCellLength": 4096,
        "maxKeyColumns": 4,
        "maxListedKeys": 200,
        "maxRowsPerSide": 5000,
        "maxNumericExponent": 6000,
        "maxListedDifferences": 500,
        "maxSignificantDigits": 50
      },
      "complete": true,
      "warnings": [],
      "comparison": {
        "numeric": "exact",
        "duplicate_keys": "multiset",
        "numeric_tolerance": "0",
        "max_numeric_exponent": 6000,
        "max_significant_digits": 50
      },
      "reconciled": false,
      "request_id": "example-request",
      "service_id": "dataset_reconciliation",
      "assumptions": [
        "Equality is decided exactly on the decimal text, never through floating point, so 42.50 and 42.5 agree while 9007199254740992 and 9007199254740993 do not.",
        "Values are otherwise compared as the text supplied. No locale, thousands separator or ambiguous date order is inferred.",
        "An empty key column makes a row unjoinable rather than grouping it with other empty keys, because that would invent matches."
      ],
      "cardinality": "1:1",
      "differences": [
        {
          "key": "1002",
          "column": "status",
          "left_row": 3,
          "right_row": 3,
          "left_value": "pending",
          "right_value": "PENDING",
          "right_column": null,
          "numeric_delta": null,
          "numeric_delta_text": null
        }
      ],
      "key_columns": [
        {
          "left": "order_id",
          "right": "orderId"
        }
      ],
      "limitations": [
        "Join integrity and field-level agreement only. Which side is correct, why they disagree, and whether the key is the right key are not assessed.",
        "Row, column, cell and listing bounds are applied as the sides are read. Anything left unexamined is named in not_examined, and reconciled is false whenever complete is false.",
        "Exact numeric comparison holds within the declared envelope of significant digits and exponent. A value outside it is counted in not_comparable_count and reported unexamined rather than compared."
      ],
      "observed_at": "2026-10-02T00:00:00.000Z",
      "not_examined": [],
      "only_in_left": [
        {
          "key": "1003",
          "rows": [
            4
          ]
        }
      ],
      "only_in_right": [
        {
          "key": "1004",
          "rows": [
            4
          ]
        }
      ],
      "service_version": "1.0.0",
      "compared_columns": [
        {
          "left": "amount",
          "right": "amount"
        },
        {
          "left": "status",
          "right": "status"
        }
      ],
      "difference_count": 1,
      "matched_key_count": 2,
      "only_in_left_count": 1,
      "ambiguous_key_count": 0,
      "only_in_right_count": 1,
      "not_comparable_count": 0,
      "differences_by_column": {
        "status": 1
      },
      "matched_row_pair_count": 2,
      "multiset_matched_key_count": 0
    }
  }
}