Denormalized records

Use this query to look for foreign key clusters with large row expansions for denormalized records. This query performs 3x3x3 or 5x5x5 denormalization with a maximum of five rows that contain columns for email, phone, and address values and provides a condensed option for examining PII values.

Configure query

1. From the Queries page, open the Stitch QA folder, and then select this query.

   Tip

   Add the Stitch QA queries template folder if it does not already exist.

2. Update the uc_filter_query to the desired threshold, which is currently set to “50”.

3. Click Run Query and debug any issues that may arise.

4. Click Activate.