Numeric value 'xyz' is not recognized. How to fix the Snowflake Error message

While executing a sql query in Snowflake, you often stumble upon this error:

Numeric value 'xyz' is not recognized

It simply means, 

  • You have a varchar column that you are trying to compare with a numeric value
  • Or, Trying to cast a varchar to number, but the column has characters

For example:

select * from customer_address WHERE address_ind = 1;

Convert it to :

select * from customer_address WHERE try_to_number(address_ind) = 1;

This will try to convert the column first to number and if there are any unsupported columns, it will use NULL for them


posted on 29 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds