post https://app.bigeye.com/api/v1/metrics/comparisons/tables
In order to get the metrics that make sense, use the delta applicable types API. This produces the metrics for the type detected of each column.
Sample configuration:
{
"comparisonTableConfiguration": {
"id": 33,
"sourceTableId": 436055,
"targetTableId": 436052,
"name": "My delta comparison between Table1 and Table2",
"columnMappings": [
{
"sourceColumn": {
"id": 2975251,
"displayName": "t1-col1"
},
"targetColumn": {
"id": 2975225,
"displayName": "T2-col1"
},
"metrics": [
{
"predefinedMetric": {
"metricName": "COUNT_NULL"
}
},
{
"predefinedMetric": {
"metricName": "MIN"
}
},
{
"predefinedMetric": {
"metricName": "MAX"
}
},
{
"predefinedMetric": {
"metricName": "AVERAGE"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_DISTINCT"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_DUPLICATES"
}
}
],
"userDefined": true
},
{
"sourceColumn": {
"id": 2975250,
"displayName": "t1-col2"
},
"targetColumn": {
"id": 2975224,
"displayName": "t2-col2"
},
"metrics": [
{
"predefinedMetric": {
"metricName": "COUNT_NULL"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_DISTINCT"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_DUPLICATES"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_EMPTY_STRING"
}
}
],
"userDefined": true
},
{
"sourceColumn": {
"id": 2975249,
"displayName": "t1-col3"
},
"targetColumn": {
"id": 2975223,
"displayName": "t2-col3"
},
"metrics": [
{
"predefinedMetric": {
"metricName": "COUNT_NULL"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_DISTINCT"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_DUPLICATES"
}
},
{
"predefinedMetric": {
"metricName": "COUNT_EMPTY_STRING"
}
}
],
"userDefined": true
}
],
"groupBys": [],
"sourceFilters": [],
"targetFilters": []
}
}