To turn hex values into decimals, use our UDF:

select common.udfs.js_hextoint_secure('0x10') -- returns '16'

If the number is known to be little-endian formatted, use:

select common.udfs.js_hextoint_littleendian_secure('0x10') -- returns '256'

Since blockchain numbers can be really big and exceed the size limit of a numerical column on Snowflake, our UDF returns strings.

But you can convert it by casting the return value to int:

select common.udfs.js_hextoint_secure('0x10')::int -- returns 16