Snowflake: Numeric value 'X' is not recognized
A text value couldn't be converted to a number while loading or casting.
Numeric value is not recognizedNumeric value '' is not recognized100038 (22018): Numeric valueNumeric value 'N/A' is not recognizedSnowflake COPY INTO numeric value not recognized Meaning
Find the bad values with TRY_TO_NUMBER/TRY_CAST, fix the source (empty strings, 'N/A', thousands separators, decimal commas), and use COPY INTO ... ON_ERROR = CONTINUE and NULL_IF to tolerate them. Check file format options (FIELD_OPTIONALLY_ENCLOSED_BY, delimiter).
Common causes
- Empty string or text in a numeric column
- Thousands separator/currency symbol
- Wrong delimiter shifting columns
- Header row loaded as data
- Locale decimal comma
⚡ Quick fix
- Find rows:
SELECT * FROM t WHERE TRY_TO_NUMBER(col) IS NULL AND col IS NOT NULL - Set
NULL_IF = ('', 'N/A')in the file format - Fix the delimiter/header settings
Detailed fix by platform
SQL
COPY INTO sales FROM @stage FILE_FORMAT = (TYPE = CSV SKIP_HEADER = 1 NULL_IF = ('', 'N/A') FIELD_OPTIONALLY_ENCLOSED_BY = '"') ON_ERROR = CONTINUE;
How to diagnose
- Bad value — Which row?
- Delimiter — Correct?
- Header — Skipped?
🔧 Still not fixed?
Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:
Similar errors
Most viewed in SQL
Other ways to find it
Where this error sits
Origin: Data. Errors that are often confused with or caused by this one (click to open):
🧠 Still stuck? Analyze your error
Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.
💬 What worked for others
No tips yet — did something else fix this for you?
Share what worked for you
Tips are checked by an editor before they appear. Links are removed.
Report a correction or suggest an improvement
Last updated 18 Nov 2026