Create a parameterized query

Replace a value in your SQL with {{name}} to turn it into a parameter. Each parameter keeps its value on the query, so you can rerun the same SQL for another chain or window without editing it.

Add parameters

Write {{name}} wherever a value should change. This query reads stablecoin supply on one chain over a number of days:

-- Circulating supply of the largest stablecoins on one chain
select
  date,
  token_symbol,
  sum(circulating_supply_usd) as circulating_supply_usd
from stablecoins.core.supply_daily
where
  date >= current_date - {{days}}
  and chain = '{{chain}}'
  and token_symbol in ('USDT', 'USDC', 'USDe', 'USDS', 'PYUSD')
group by all
order by date

Query editor with days and chain parameters inline in the SQL

Set their values

Select a parameter in the editor to set its value, here 30 for days and solana for chain.

Edit parameter dialog with the chain parameter set to solana

Run it

Run the query. Change a value and run again to read another chain or window.

Parameters through the API

The Explorer API sets parameter values per request, so one saved query can serve many filters. To make the whole query a parameter, save {{sql}} as the query text and pass the complete SQL as that parameter’s value.

Queries

Dashboards

Your Data

Beam

Issuer Intelligence

Settings

Parameters through the API

Next steps

Run a basic query

Query a previous result

Queries

Dashboards

Your Data

Beam

Issuer Intelligence

Settings

​Parameters through the API

​Next steps

Run a basic query

Query a previous result

Parameters through the API

Next steps