I’m seeing a mismatch between results from my database and Amazon QuickSight when running the same query. For one specific column, QuickSight’s value is consistently off by 1 compared to the database result.
I’ve already confirmed the column data type matches in the database and in QuickSight, but the discrepancy remains.
Without having further information to identify the root of the issue, here are some potential theories:
In addition to confirming the data type matches, the issue may be due to rounding differences between your data source and your calculation in Quick Sight
Are you ingesting your data into SPICE, or is it a direct query? This should not cause the error, however you can test switching between these 2 modes to further narrow down the root cause of the issue
Check values such as nulls as they may be interpreted differently between your data source and the calculation you are doing in Quick Sight.
Please verify the above, and if you determine this is a bug please raise a support ticket.