Unified Changes Clusters table

The Unified Changes Clusters table contains a history of changes to cluster graphs, relative to the previous Stitch run.

The Unified Changes Clusters table is automatically added to the Stitch QA database as a passthrough table when it is generated using the “Stitch QA” database template.

Note

Thirty days of history are stored by default for the Unified Changes Clusters and Unified Changes PKS tables. This number of days is configurable.

Use with Stitch QA

Use the Unified Changes Clusters table as part of the Stitch QA process to compare the previous state of clusters to the current state and understand why a primary key was added, deleted, or updated.

Column reference

The Unified Changes Clusters table contains the following columns:

Column name

Data type

Description

Amperity ID

String

The unique identifier that is assigned to clusters of customer records that all represent the same individual. The Amperity ID does not replace primary and foreign keys, but exists alongside them within unified profiles.

Note

The Amperity ID is a universally unique identifier (UUID) that is represented by 36 characters spread across five groups separated by hyphens: 8-4-4-4-12.

For example:

123e4567-e89b-12d3-a456-426614174000

Change Type

String

The type of change that occurred within the Stitch job. Possible values include: added, deleted, and updated:

  • The added change type indicates a new cluster was created during this run.

  • The deleted change type indicates a cluster was deleted during this run.

  • The updated change type indicates the cluster existed in the past run, and continues to exist in this run but the set of PKs that comprise it has changed.

Also in: Unified Changes PKS

Job ID

String

The job ID for database table generation. For example: db-gen-20210202-12345-AbCd67EFgH8.

Also in: Unified Changes PKS

Timestamp

Datetime

The timestamp that is associated with Job ID. Each row that shares the same job ID will have the same value for Timestamp.

Also in: Unified Changes PKS