How to load long decimal data (> 10 digit) in quick sight

[Max]

I would look into this.

Quicksight - Rounding to 2 decimals

I only use direct SPICE import for analysis, as direct import isn’t allowed due to privacy concerns. I was able to just use multiplication by 100.0000 with number format and it works fine. Though, I do hope the feature is released soon.

You might also look to multiply by 1000 or so in sql and then divide them again by 1000 in a calculated field in quicksight.