Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

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