100038 SQL Origin: Data OSI layer 7 · Application Last updated 18 Nov 2026

Snowflake: Numeric value 'X' is not recognized

A text value couldn't be converted to a number while loading or casting.

Exact message you may see Numeric value is not recognizedNumeric value '' is not recognized100038 (22018): Numeric valueNumeric value 'N/A' is not recognizedSnowflake COPY INTO numeric value not recognized
Seen on: Snowflake SQL

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

  1. Find rows: SELECT * FROM t WHERE TRY_TO_NUMBER(col) IS NULL AND col IS NOT NULL
  2. Set NULL_IF = ('', 'N/A') in the file format
  3. Fix the delimiter/header settings

Detailed fix by platform

SQL

  1. 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

  1. Bad value — Which row?
  2. Delimiter — Correct?
  3. 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:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

000606 — Snowflake: No active warehouse selected in the current session (SQL)000606002003 — Snowflake SQL compilation error: Object 'X' does not exist or not authorized (SQL)00200322P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02242 — SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value (SQL)242245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)2458114 — SQL Server Msg 8114: Error converting data type varchar to numeric (SQL)8114CASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASEload job — BigQuery load job failed: schema mismatch / Provided Schema does not match table (Google Cloud / Firebase)load job100038

Explore the map of this error Full error map →

🧠 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.