Studio CSV import: skip type mismatched rows and download rejects #48424
Unanswered
seandmill
asked this question in
Feature Requests
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Problem
In the Table Editor --> Insert --> Import data from CSV flow, a single cell that can't cast to the specified column type fails the whole import (e.g.
$99.95into afloat8).Proposal
Add an opt-in toggle in the import configuration: Skip rows with type mismatches (default off).
When enabled:
X imported, Y skippedand offer download skipped rows (csv of skipped cells and askip_reasoncolumn)Why
NULLfor bad data)All reactions