Does Snowflake Truncate, Round, or Error When Number Precision Is Exceeded?

Question

What happens when I sync a number with more decimal places than the Snowflake destination column allows? Does Snowflake truncate, round, or generate an error?

Environment

Destination: Snowflake

Answer

When you sync a number with more decimal places than the Snowflake column’s scale, Snowflake truncates the extra digits instead of rounding or generating an error.

For example, if you sync a number with 18 decimal places into a NUMBER(38,10) column, Snowflake retains only the first 10 decimal places and discards the rest. However, if the total number of digits, once truncated to the column’s scale, exceeds the defined precision, Snowflake generates an error.