Redash bug while displaying BIGINT values

Support Usage Support
, ,
1

Redash has the following issues while displaying BIGINT values.
Issue in the visualization as well as the difference in the actual returned value. Example below -

Screen Shot 2022-02-07 at 10.49.03 PM (2)
Screen Shot 2022-02-07 at 10.49.03 PM (2)914×704 37.1 KB

I am using Redash 6, but I have also tried the same on Redash 10 and I am facing the same issue with v10 as well. Is this an existing issue? Can someone please suggest a solution for this?

2

Pls check this url - Schema listing for Big data is not working

3

Secret is easy – redash processes bigint as float and gains overflow:

>>> int(float(252672899128697211))                                                                                               
252672899128697216