View the original community article here
Last Tested: Jul 3, 2018
Yes, the limitation will happen at around 16-17 digits and it will round the additional integers into "0"s. For example:
5820847388981125942 becomes
5820847388981126000
Overall it is a precision limit of javascript.
Workarounds
- Use {{ rendered_value }}
dimension: id {
primary_key: yes
type: number
sql: ${TABLE}.id ;;
html: {{ rendered_value }} ;;
}
- Use two dimensions
- dimension: string_value
type: string
sql: ${TABLE}.myfield
order_by_field: int_value
- dimension: int_value
type: number
sql: ${TABLE}.myfield
SQL Runner
SQL Runner will also render the lost precision numbers. The workaround for SQL Runner is to have the value casted as a STRING in the query itself. This can vary dialect to dialect.
This content is subject to limited support.