Chain utility functions
Chain Utility Functions
Dune SQL offers a series of functions designed to ease some common tasks when working with blockchain data.
These functions are helpful to generate links to the explorer of a chain, to specific addresses, or to specific transactions.
Most of the time you’ll want to use get_href()
in combination with one of the other functions to generate a clickable link to a specific address or transaction.
Select
get_href(get_chain_explorer_address('ethereum', to), cast(to as varchar))
FROM ethereum.transactions
limit 100
This sql code will generate a clickable link pointing to the explorer of the Ethereum chain for each address in the to
column. The displayed link will be the address itself.
You can find all the functions in action on this dashboard: Chain Utility Functions
get_href()
get_href(varchar, varchar)
→ varchar
This function converts a link and associated text into a clickable hyperlink. The first argument is the link, and the second argument is the text to be displayed.
SELECT
get_href('https://dune.com', 'Dune')
get_chain_explorer_address()
get_chain_explorer_address(varchar, varchar)
→ varchar
This function generates a URL for the explorer of a specified chain (provided as a varchar) for a given address (also provided as a varchar).
SELECT
get_chain_explorer_address('ethereum', cast(to as varchar))
FROM ethereum.transactions
limit 100
get_chain_explorer_address()
get_chain_explorer_address(varchar, varbinary)
→ varchar
This function generates a URL for the explorer of a specified chain (provided as a varchar) for a given address (provided as a varbinary).
SELECT
get_chain_explorer_address('ethereum', to)
FROM ethereum.transactions
limit 100
get_chain_explorer_tx_hash()
get_chain_explorer_tx_hash(varchar, varchar)
→ varchar
This function generates a URL for the explorer of a specified chain (provided as a varchar) for a given transaction hash (also provided as a varchar).
SELECT
get_chain_explorer_tx_hash('ethereum', cast(hash as varchar))
FROM ethereum.transactions
limit 100
get_chain_explorer_tx_hash()
get_chain_explorer_tx_hash(varchar, varbinary)
→ varchar
This function generates a URL for the explorer of a specified chain (provided as a varchar) for a given transaction hash (provided as a varbinary).
SELECT
get_chain_explorer_tx_hash('ethereum', hash)
FROM ethereum.transactions
limit 100
get_chain_explorer()
get_chain_explorer(varchar)
→ varchar
This function returns the URL of the explorer for a specified chain (provided as a varchar).
SELECT
get_chain_explorer('ethereum')
get_balancer_link()
get_balancer_link(varchar, varchar)
→ varchar
This function returns a link to access a specific pool on the Balancer app. The first argument is the chain, and the second argument is the pool Id (provided as varchar).
SELECT
get_balancer_link(blockchain, cast(pool_id as varchar))
FROM balancer.trades
limit 100
get_balancer_link()
get_balancer_link(varchar, varbinary)
→ varchar
This function returns a link to access a specific pool on the Balancer app. The first argument is the chain, and the second argument is the pool Id (provided as varbinary).
SELECT
get_balancer_link(blockchain, pool_id)
FROM balancer.trades
limit 100
all_evm_chains()
all_evm_chains()
→ array(varchar)
SELECT
all_evm_chains()
This function returns an array listing all the EVM chains available on Dune.
all_op_chains()
all_op_chains()
→ array(varchar)
SELECT
all_op_chains()
This function returns an array listing all the Optimism chains available on Dune.
Was this page helpful?