Skip to content

Tag: snowflake-schema

Not able to resolve “Numeric Value ‘-‘ is not recognized” error in Snowflake SQL Query

I’m working on converting the sql query below over to Snowflake, and got the error “Numeric Value ‘-‘ is not recognized” but it did not have a line number. I assume it’s in reference to the various “-1” instances throughout the query but there’s no line referenced so it’s unclear what’s causing the problem. If it’s the various references to