Reconciliation Policy - Schema

This schema represents the Reconciliation policy object returned by:

• Create and List Policies
• Manage Reconciliation Policy by ID
• Manage Reconciliation Policy by Name

Top-level Fields

Key nested properties (high-level):

• rule.id (integer) – Unique policy ID.
• rule.name (string) – Policy name.
• rule.type (string) – Always RECONCILIATION.
• rule.leftBackingAsset / rightBackingAsset (object) – Source and sink assets to be compared.
• rule.thresholdLevel.success / warning (integer) – Pass/fail thresholds for reconciliation.
• rule.labels (array) – Labels associated with the policy.
• rule.notificationChannels (object) – Alert settings.

Example JSON

Json

{

"rule": {

"archived": false,

"autoCreated": false,

"createdAt": "2024-05-13T09:41:43.063Z",

"createdBy": "user@company.com",

"description": "Hashed data equality between source and sink tables",

"enabled": true,

"executionTimeoutInMinutes": null,

"id": 282143,

"isProtectedResource": false,

"labels": [],

"lastUpdatedBy": "user@company.com",

"leftBackingAsset": {

"customQuery": null,

"customTableAssetIds": null,

"id": 349870,

"marker": null,

"ruleId": 282143,

"tableAlias": null,

"tableAssetId": 3845235,

"tableAssetUid": null

},

"name": "SNOWFLAKE_automation_Hashed_Data_Equality_3_success",

"notificationChannels": null,

"policyGroups": [],

"rightBackingAsset": {

"customQuery": null,

"customTableAssetIds": null,

"id": 349871,

"marker": null,

"ruleId": 282143,

"tableAlias": null,

"tableAssetId": 3845233,

"tableAssetUid": null

},

"schedule": null,

"scheduled": false,

"sparkResourceConfig": null,

"tags": [],

"tenantId": "twosevenzero",

"thresholdLevel": {

"success": 100,

"warning": null

},

"timeSecondsOffset": 0,

"timeZone": "GMT",

"type": "RECONCILIATION",

"updatedAt": "2024-05-13T09:41:43.063Z",

"version": 1

}

}