GET
/
api
/
v1
/
datadiffs
/
{datadiff_id}
/
summary_results
curl --request GET \
  --url https://app.datafold.com/api/v1/datadiffs/{datadiff_id}/summary_results \
  --header 'Authorization: <api-key>'
{
  "dependencies": [
    {
      "data_source_id": 123,
      "data_source_type": "<string>",
      "item_type": "<string>",
      "name": "<string>",
      "path": [
        "<string>"
      ],
      "popularity": 123,
      "primary_key": "<string>",
      "query_type": "<string>",
      "raw_sql": "<string>",
      "remote_id": "<string>",
      "table_name": "<string>",
      "uid": "<string>"
    }
  ],
  "materialized_results": {
    "diff": [
      {
        "data_source_id": 123,
        "is_sampled": true,
        "path": [
          "<string>"
        ]
      }
    ],
    "duplicates1": [
      {
        "data_source_id": 123,
        "is_sampled": true,
        "path": [
          "<string>"
        ]
      }
    ],
    "duplicates2": [
      {
        "data_source_id": 123,
        "is_sampled": true,
        "path": [
          "<string>"
        ]
      }
    ],
    "exclusives": [
      {
        "data_source_id": 123,
        "is_sampled": true,
        "path": [
          "<string>"
        ]
      }
    ]
  },
  "pks": {
    "distincts": [
      "<any>"
    ],
    "dupes": [
      "<any>"
    ],
    "exclusives": [
      "<any>"
    ],
    "nulls": [
      "<any>"
    ],
    "total_rows": [
      "<any>"
    ]
  },
  "schema": {
    "column_counts": [
      "<any>"
    ],
    "column_reorders": 123,
    "column_type_differs": [
      "<string>"
    ],
    "column_type_mismatches": 123,
    "columns_mismatched": [
      "<any>"
    ],
    "exclusive_columns": [
      [
        "<string>"
      ]
    ]
  },
  "status": "done",
  "values": {
    "columns_diff_stats": [
      {}
    ],
    "columns_with_differences": 123,
    "compared_columns": 123,
    "rows_with_differences": 123,
    "total_rows": 123,
    "total_values": 123,
    "values_with_differences": 123
  }
}

Authorizations

​
Authorization
string
header
required

Use the 'Authorization' header with the format 'Key <api-key>'

Path Parameters

​
datadiff_id
integer
required

Response

200
application/json
Successful Response
​
dependencies
object[]
required
​
materialized_results
object
required

Results of the diff, materialized into tables.

​
pks
object
required
​
schema
object
required
​
status
enum<string>
required
Available options:
done,
success
​
values
object | null