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