title: Snowflake Number out of representable range
body: <p>I am trying to insert a number value e.g: -20833.33 in a column data type number(10,6). There is an error in snowflake regarding &quot;number out of representable range&quot;. I tried to find an answer why this is happening in <a href="https://docs.snowflake.com/en/sql-reference/data-types-numeric.html#number" rel="nofollow noreferrer">numeric data types</a>, but I could not find any plausible explanation.</p>
  <p>Here is the representation of the case:</p>
  <pre><code>create table test (
     VALUE    number(10, 6)
  );
  
  
  INSERT test 
  with TESTTABLE as (
      select '-20833.33' AS VALUE)
  SELECT * FROM TESTTABLE
  </code></pre>
  <p>I am receiving the following error:
  &quot;Number out of representable range: type FIXEDSB8{nullable},value -20833.33</p>
  <p>Would someone know why this is happening and have some references that explains this error?</p>