Manage Reconciliation Policy by Name

curl -X PUT "https://{HOST}/catalog-server/api/rules/reconciliation/byName/Sales_Recon_Policy" \

  -H "Content-Type: application/json" \

  -H "Authorization: Bearer $TOKEN" \

  -H "accessKey: $ACCESS_KEY" \

  -H "secretKey: $SECRET_KEY" \

  -d '{

    "description": "Reconciliation policy to ensure sales data matches between source and target tables",

    "status": "ACTIVE",

    "scheduled": true,

    "schedule": "0 3 * * *",

    "source": {

      "connectionName": "sales_source",

      "database": "sales_db",

      "table": "transactions"

    },

    "target": {

      "connectionName": "sales_target",

      "database": "sales_warehouse",

      "table": "transactions"

    },

    "joinConditions": [

      {

        "sourceColumn": "transaction_id",

        "targetColumn": "transaction_id"

      }

    ],

    "matchRules": [

      {

        "sourceColumn": "amount",

        "targetColumn": "amount",

        "tolerance": 0

      },

      {

        "sourceColumn": "currency",

        "targetColumn": "currency"

      }

    ],

    "thresholds": {

      "maxMismatchPercentage": 5

    },

    "tags": ["finance", "critical"]

  }'