Trying to load data into a Snowflake table might result in a warning similar to the following:

WARNING: During insert: [Snowflake][Support] (40460) Fractional data truncated while performing conversion.

The issue might occur when the following is true:

• You are not using the BULKLOAD= LIBNAME option or data set option along with one of the following:
  • the INSERTBUFF= LIBNAME option or data set option
  • allow the setting to automatically calculate based on row length
• The number of rows that you are trying to insert is larger than the included INSERTBUFF= setting, or the value that was automatically calculated for you with the INSERTBUFF= option was not included.
• The Snowflake table contains a variable defined with the NUMBER data type.

Workaround

The workaround for this issue is to remove the INSERTBUFF= LIBNAME option or data set option. Instead, add the BULKLOAD= yes option. Note that you might need to include additional required options for the method that you choose for the bulk loading.