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.

    Try Elvity Free

    Get access to a trial edition

    Enter your work email and we'll give you access to a trial edition of Elvity — no credit card, no setup fees.

    No credit card required. We'll reach out within one business day.