bro-n-bro / spacebox

MIT License
35 stars 4 forks source link

Add genesis_balances table #72

Closed bro-n-bro-0 closed 1 month ago

bro-n-bro-0 commented 2 months ago

the table definition

CREATE TABLE spacebox.genesis_balances
(
    `height` Int64,
    `type` String,
    `address` String,
    `coins` String,
    `amount` Int64,
    `denom` String
)
ENGINE = MergeTree
ORDER BY (height,
 address,
 denom)
SETTINGS index_granularity = 8192;

there is no writer MV for that, this is only static data to get a starting point of balances. One insert is enough

iljagrabar14 commented 2 months ago

select * from spacebox.raw_genesis rg (app state, balances, type= "coin_received" (like in debs and creds), height is 0, coins not need