Pain point · Reliability & bugs · Blocks work
Very large integer IDs are rounded in the UI
1 source thread · first seen 2017-08
Summary
8-byte BIGINT IDs are displayed rounded, and drilling through foreign key links fails, while CSV downloads show the correct values.
- Affects
- Teams with BIGINT primary and foreign keys
- Workaround
- Download the result as CSV to see exact values
Evidence
Excerpts are copied word for word from the source; follow the link to read it in full.
“Metabase is unable to display the large numbers as answers, and appears to round them off when displaying them”