Browse documentation
HomeDocsError Console
Audit & Errors

Resolving Ingestion Errors (The Error Console)

Isolate validation failures and resolve them in bulk — with manual edits or AI-driven fixes — without touching local files.


When incoming data violates your Target Schema’s rules, Elvity isolates the issues so you can resolve them in bulk — without modifying files on your computer.

8.1

Navigating the Error Console

When validation fails, click the Errors tab in your right side panel to open the Error Console:

  1. 1Rule Progress Bar: Check the progress bar at the top for a column-by-column health indicator. Red columns require attention.
  2. 2Isolate Columns: Columns containing errors are flagged with an error count badge (e.g., 12 errors). Click a column to filter the grid.
  3. 3Filter by Violation Type: Click a specific error type under the active column (e.g., Range) to see suggestions for only that rule.
  4. 4Auto-Scroll to Error Instances: Hover over an error type and click the Prev/Next arrow controls. The main data grid automatically scrolls and highlights the exact failing cell in red.
Error Console with a CaseMatch error count badge, failing first_name cells highlighted in red, and a suggestions list in the right panel.
The Error Console isolates failing cells and surfaces AI fix suggestions.
8.2

Making Spreadsheet-Style Manual Edits

For small, one-off corrections, you can edit the grid manually:

1

Locate the failing cell

Find the red-bordered failing cell in the grid.

2

Open the cell for editing

Double-click directly inside the cell.

3

Enter the correct value

Type in the correct value and hit Enter.

4

Confirm the queued change

The cell background will change to orange, indicating a Queued Change.

Data grid with a first_name cell open for inline editing, set against an otherwise clean, all-valid batch.
Double-click any cell to make a quick, spreadsheet-style manual correction.
8.3

Executing AI Bulk Fixes

For widespread errors (e.g., 200 invalid phone numbers), let the AI Assistant handle it:

  1. 1Select the column and error type in the Error Console.
  2. 2Review the AI-generated Suggestions list.
  3. 3The affected cells will instantly highlight in orange (Queued Changes).
  • Standard Suggestions: Select standard fixes like "Drop all rows with this error" or "Fill in placeholder value."
  • Specify Custom Fix: Click Choose on the custom option, type your specific correction in plain English (e.g., “Strip the currency symbols and format as a plain decimal”), and click Apply.
Workspace showing queued first_name fixes highlighted in orange with a Queued Fix panel and the Apply Pending Changes button.
A bulk fix queued as non-destructive Queued Changes, ready to apply.
8.4

Applying Changes & Re-running Validation

Once your manual edits and AI bulk suggestions are queued:

  1. 1Click the purple Apply Pending Changes button at the top of your workspace.
  2. 2Elvity sends your overrides to the backend pipeline, re-runs the validation rules, and refreshes the data grid.
  3. 3Ensure your column progress indicators turn green, then click Approve & Next to export your validated data.
Queued changes are non-destructive
Edits are staged as Queued Changes and only sent to the backend when you click Apply Pending Changes — so you can review every override before it runs.

Ready to put this into practice?

Spin up your first pipeline and watch Elvity map your data in minutes.