Snowflake SUM aggregate causes value overflow about soda-sql

[dirkgroenen]

Thanks for your report @IsaacSee. I've modified your title to include a short description of the issue and set the soda-sql version to 2.0.0b10 (cause I assumed that's what you meant with latest).

We'll take a look at this! 🚀

[IsaacSee]

Thanks @dirkgroenen, quick investigation from our end find that this is just snowflake not able to sum very large columns.
Dunno if there is a workaround here.

[milanaleksic]

Can you provide data types used in your columns? In case you know for which column from your data this occurred even better. Redshift has similar issue but there we typecasted the number into highest possible (yet still lossless) data type; I am not sure this is applicable for snowflake but we might be able to do the same thing here

[vijaykiran]

Hi @IsaacSee you can use https://docs.soda.io/soda-sql/scan-yaml.html#excluded-columns-example to prevent calculating SUM for problematic columns.