Browse documentation
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.
Navigating the Error Console
When validation fails, click the Errors tab in your right side panel to open the Error Console:
- 1Rule Progress Bar: Check the progress bar at the top for a column-by-column health indicator. Red columns require attention.
- 2Isolate Columns: Columns containing errors are flagged with an error count badge (e.g., 12 errors). Click a column to filter the grid.
- 3Filter by Violation Type: Click a specific error type under the active column (e.g., Range) to see suggestions for only that rule.
- 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.
_1781289874514-BbS0f2b-.png)
Making Spreadsheet-Style Manual Edits
For small, one-off corrections, you can edit the grid manually:
Locate the failing cell
Find the red-bordered failing cell in the grid.
Open the cell for editing
Double-click directly inside the cell.
Enter the correct value
Type in the correct value and hit Enter.
Confirm the queued change
The cell background will change to orange, indicating a Queued Change.
_1781289874515-DytG-dAJ.png)
Executing AI Bulk Fixes
For widespread errors (e.g., 200 invalid phone numbers), let the AI Assistant handle it:
- 1Select the column and error type in the Error Console.
- 2Review the AI-generated Suggestions list.
- 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.
_1781289874514-DEptQg3u.png)
Applying Changes & Re-running Validation
Once your manual edits and AI bulk suggestions are queued:
- 1Click the purple Apply Pending Changes button at the top of your workspace.
- 2Elvity sends your overrides to the backend pipeline, re-runs the validation rules, and refreshes the data grid.
- 3Ensure your column progress indicators turn green, then click Approve & Next to export your validated data.
Ready to put this into practice?
Spin up your first pipeline and watch Elvity map your data in minutes.