Table is not being updatedThe This scans the full history of the bronze table (on the order of 1 TB), so materialize the result or restrict
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
batch_run_date if you only need balances touched in a given window.Table Metadata
| Property | Configuration |
|---|---|
| Natural Key(s) | balance_id, closed_at |
| Partition Field(s) | N/A |
| Clustered Field(s) | N/A |
| Documentation | dbt docs |