curl -X POST "https://YOUR_BASE_URL/comparisons" \
-H "Authorization: Bearer <api-key>" \
-H "Workspace-Id: <workspace-id>" \
-H "Content-Type: application/json" \
-d '{
"name": "orders table comparison",
"source_datasource_id": "aaaaaaaa-0000-0000-0000-000000000001",
"target_datasource_id": "bbbbbbbb-0000-0000-0000-000000000002",
"source_dataset_id": "cccccccc-0000-0000-0000-000000000003",
"target_dataset_id": "dddddddd-0000-0000-0000-000000000004",
"configuration": {
"source_columns": ["order_id", "customer_id", "total"],
"target_columns": ["order_id", "customer_id", "total"],
"primary_keys_source": ["order_id"],
"primary_keys_target": ["order_id"]
}
}'
{
"message": "Comparison created successfully",
"data": {
"id": "eeeeeeee-0000-0000-0000-000000000005",
"name": "orders table comparison",
"source_dataset_id": "cccccccc-0000-0000-0000-000000000003",
"target_dataset_id": "dddddddd-0000-0000-0000-000000000004",
"configuration": {
"source_columns": ["order_id", "customer_id", "total"],
"target_columns": ["order_id", "customer_id", "total"],
"primary_keys_source": ["order_id"],
"primary_keys_target": ["order_id"],
"case_sensitive": false,
"quick_comparison": false
},
"workspace_id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"user_id": "ffffffff-0000-0000-0000-000000000006"
}
}
Create a new comparison between a source and target dataset.
curl -X POST "https://YOUR_BASE_URL/comparisons" \
-H "Authorization: Bearer <api-key>" \
-H "Workspace-Id: <workspace-id>" \
-H "Content-Type: application/json" \
-d '{
"name": "orders table comparison",
"source_datasource_id": "aaaaaaaa-0000-0000-0000-000000000001",
"target_datasource_id": "bbbbbbbb-0000-0000-0000-000000000002",
"source_dataset_id": "cccccccc-0000-0000-0000-000000000003",
"target_dataset_id": "dddddddd-0000-0000-0000-000000000004",
"configuration": {
"source_columns": ["order_id", "customer_id", "total"],
"target_columns": ["order_id", "customer_id", "total"],
"primary_keys_source": ["order_id"],
"primary_keys_target": ["order_id"]
}
}'
{
"message": "Comparison created successfully",
"data": {
"id": "eeeeeeee-0000-0000-0000-000000000005",
"name": "orders table comparison",
"source_dataset_id": "cccccccc-0000-0000-0000-000000000003",
"target_dataset_id": "dddddddd-0000-0000-0000-000000000004",
"configuration": {
"source_columns": ["order_id", "customer_id", "total"],
"target_columns": ["order_id", "customer_id", "total"],
"primary_keys_source": ["order_id"],
"primary_keys_target": ["order_id"],
"case_sensitive": false,
"quick_comparison": false
},
"workspace_id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"user_id": "ffffffff-0000-0000-0000-000000000006"
}
}
Bearer <api-key>true, creates the comparison without triggering execution.source_query is not set.target_query is not set.Show configuration
source_dataset_id.target_dataset_id.Show data
curl -X POST "https://YOUR_BASE_URL/comparisons" \
-H "Authorization: Bearer <api-key>" \
-H "Workspace-Id: <workspace-id>" \
-H "Content-Type: application/json" \
-d '{
"name": "orders table comparison",
"source_datasource_id": "aaaaaaaa-0000-0000-0000-000000000001",
"target_datasource_id": "bbbbbbbb-0000-0000-0000-000000000002",
"source_dataset_id": "cccccccc-0000-0000-0000-000000000003",
"target_dataset_id": "dddddddd-0000-0000-0000-000000000004",
"configuration": {
"source_columns": ["order_id", "customer_id", "total"],
"target_columns": ["order_id", "customer_id", "total"],
"primary_keys_source": ["order_id"],
"primary_keys_target": ["order_id"]
}
}'
{
"message": "Comparison created successfully",
"data": {
"id": "eeeeeeee-0000-0000-0000-000000000005",
"name": "orders table comparison",
"source_dataset_id": "cccccccc-0000-0000-0000-000000000003",
"target_dataset_id": "dddddddd-0000-0000-0000-000000000004",
"configuration": {
"source_columns": ["order_id", "customer_id", "total"],
"target_columns": ["order_id", "customer_id", "total"],
"primary_keys_source": ["order_id"],
"primary_keys_target": ["order_id"],
"case_sensitive": false,
"quick_comparison": false
},
"workspace_id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
"user_id": "ffffffff-0000-0000-0000-000000000006"
}
}