I’m seeing the following exception from the Query drawer when running a worksheet:
This compilation error is returned by Snowflake when the intermediate result in a formula calculation produces a very large number beyond 38 digits or includes a long number of decimal digits.
For more details on the accepted limits please visit https://docs.snowflake.com/en/sql-reference/data-types-numeric.html