data-diff icon indicating copy to clipboard operation
data-diff copied to clipboard

Column sums causing exceptions in some cases

Open dlawin opened this issue 2 years ago • 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.

dlawin avatar Jun 21 '23 21:06 dlawin