datafold/data-diff

Column sums causing exceptions in some cases

dlawin opened this issue · 0 comments

Describe the bug
I'm using the --dbt integration with BQ and a query like this is causing an integer overflow:

    SELECT sum(`some_foreign_key_id`) AS `sum_some_foreign_key_id`
,   sum(`another_foreign_key_id`) AS `sum)another_foreign_key_id`, count(*) AS `count` 
from etc.

Got error: 400 Error in SUM aggregation: integer overflow

These summations are not displayed when using --dbt so the queries can be skipped when using this integration.