> For the complete documentation index, see [llms.txt](https://docs.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.collibra.com/data-quality-self-hosted/core-concepts/findings/data-quality-monitors/shapes.md).

# Shapes

The Shapes monitor detects rare or inconsistent data formats in string columns. Collibra DQ uses a sampling of the metadata to detect potential data issues, which can then be drilled into by creating queries from the data model finding.

{% hint style="info" %}
The sampling of metadata may change and the number of shapes returned may differ.
{% endhint %}

The following table shows the information available on the Shapes tab of the Findings page.

<table><thead><tr><th width="152">Column</th><th>Description</th></tr></thead><tbody><tr><td>Column</td><td>The column where Collibra DQ detects a shape.</td></tr><tr><td>Schema</td><td>The datatype schema of the column where Collibra DQ detects a shape.</td></tr><tr><td>Shape</td><td>The format of the shape.</td></tr><tr><td>Count</td><td>The number of times a particular shape format appears in a column.</td></tr><tr><td>Row Count</td><td>The number of rows in the table, file, or view where Collibra DQ detects shape issues.</td></tr><tr><td>Percent</td><td>The percentage a shape conforms to the format that Collibra DQ identifies as normal.</td></tr><tr><td>Shapes/Col</td><td>The number of shape issues in a particular column.</td></tr><tr><td>Status</td><td><p>Lets you <a href="/data-quality-self-hosted/core-concepts/findings/working-with-assignments.md">label and train</a> a finding. The available dropdown menu options are Validate, Invalidate, and Resolve.</p><p><strong>Validate</strong> 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.</p><p><strong>Invalidate</strong> instructs Collibra DQ to ignore a finding and allow the value to pass. There are two invalidation options:</p><ul><li><strong>Save</strong> lets you mark a finding as invalidated.</li><li><p><strong>Save &#x26; Retrain</strong> lets you invalidate a finding and any previously saved invalidated findings, if any.</p><div data-gb-custom-block data-tag="hint" data-style="success" class="hint hint-success"><p>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.</p></div></li></ul><p><strong>Resolve</strong> 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.</p></td></tr><tr><td>Profile</td><td><p>The user account that is assigned to this shapes finding. When the Status is Assigned, a user profile displays in this column.</p><div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>When a shapes finding is unassigned, the profile column is empty.</p></div></td></tr><tr><td>Action</td><td><p>In Pushdown mode, you can download either a CSV or JSON file containing details of the break records.</p><div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><p>This column does not display for DQ Jobs created in Pullup mode.</p></div></td></tr></tbody></table>

### 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 <img src="https://4121921244-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWCrP7Albs8DfJjIQxUxw%2Fuploads%2Fgit-blob-75245abf5c50ddf56f1d2d727ccaacf757d11145%2Fcogwheel-large%402x.png?alt=media" alt="" data-size="line"> 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            |

## Retrain

Updates the DQ models used for automated data-quality checks. The Retrain process consumes current training data (and optionally labels/config), builds a new model or rule-set, validates it, and publishes a new version that will be used to score incoming data and compute DQ metrics. Use **Retrain** when data distributions change, new labels/ground truth are available, business rules change, or on a scheduled cadence to prevent model drift.
