The Shapes monitor detects rare or inconsistent data formats in string columns.
The following table shows the information available on the Shapes tab of the Findings page.
| Column | Description |
|---|---|
| Column | The column where Collibra DQ detects a shape. |
| Schema | The datatype schema of the column where Collibra DQ detects a shape. |
| Shape | The format of the shape. |
| Count | The number of times a particular shape format appears in a column. |
| Row Count | The number of rows in the table, file, or view where Collibra DQ detects shape issues. |
| Percent | The percentage a shape conforms to the format that Collibra DQ identifies as normal. |
| Shapes/Col | The number of shape issues in a particular column. |
| Status |
Lets you label and train a finding. The available dropdown menu options are Validate, Invalidate, and Resolve. Validate instructs Collibra DQ to either assign a finding to a specific user for review, which then appears in the View the Assignment Queue or acknowledge without an assignee that the finding is a valid observation. Invalidate instructs Collibra DQ to ignore a finding and allow the value to pass. There are two invalidation options:
Tip When you have many findings to invalidate, it may be best to use the Save option to invalidate them at the same time, once all findings are reviewed. Resolve Instructs Collibra DQ to mark the finding as an observation and prevents it from appearing in future runs. Resolving a finding does not immediately affect data quality scores. |
| Profile |
The user account that is assigned to this shapes finding. When the Status is Assigned, a user profile displays in this column. Note When a shapes finding is unassigned, the profile column is empty. |
| Action |
In Pushdown mode, you can download either a CSV or JSON file containing details of the break records. Note This column does not display for DQ Jobs created in Pullup mode. |
Exporting shape records
There are two options above the drill-in table to export the details of your outlier records as .xlsx files:
- Export generates an Excel file with the details from the drill-in.
- Export with Details generates an Excel file with the details from the drill-in and the data preview, when available.
Configuring manual options
You can configure additional shape options on the Findings page. Click the 
above the upper-right corner of the Shapes Findings table.
The following table shows the available options.
| Option | Description | Default Value |
|---|---|---|
| Occurrence % < [X] |
Only shows shapes below the given percentage threshold. |
0.001 |
| Format per Col < [X] | Only shows columns with less than the given number of formats. For example, when there are 30 formats and the Format per Column value is set to 5, then only 5 columns display. | 20 |
| Character Length < [X] | Only shows Shape issues with fewer than the given number of characters. For example, if the value is set to 9, then all values less than 9 will show. | 12 |