Skip to main content

Claimable Balances Current

Table is not being updated

The claimable_balances_current model is disabled in stellar-dbt-public (+enabled: false in dbt_project.yml), so this table is no longer refreshed and its contents are frozen.

To derive current state yourself, read the bronze Claimable Balances table and take the latest row per balance. That table is append-only and holds many historical rows per balance_id, so selecting from it without deduplicating will return stale rows:

select * except (row_num)
from (
  select *
    , row_number() over (partition by balance_id order by closed_at desc) as row_num
  from `crypto-stellar.crypto_stellar.claimable_balances`
)
where row_num = 1
  and not deleted  -- drop balances that have since been claimed or clawed back

This scans the full history of the bronze table (on the order of 1 TB), so materialize the result or restrict batch_run_date if you only need balances touched in a given window.

Table Metadata​

PropertyConfiguration
Natural Key(s)balance_id, closed_at
Partition Field(s)N/A
Clustered Field(s)N/A
Documentationdbt docs

Column Details​

Column details are equivalent to the bronze Claimable Balances table. Filters down to only latest state information.