> ## Documentation Index
> Fetch the complete documentation index at: https://developers.stellar.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Claimable Balances Current

> Column details are equivalent to the bronze Claimable Balances table.

> [!WARNING]
>
> **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](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/bronze/claimable-balances.md) 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:
>
> ```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
> 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

| Property | Configuration |
| - | - |
| Natural Key(s) | balance\_id, closed\_at |
| Partition Field(s) | N/A |
| Clustered Field(s) | N/A |
| Documentation | [dbt docs](http://www.stellar-dbt-docs.com/#!/model/model.stellar_dbt_public.claimable_balances_current) |

## Column Details

Column details are equivalent to the bronze [Claimable Balances](https://developers.stellar.org/docs/data/analytics/hubble/data-catalog/data-dictionary/bronze/claimable-balances.md) table. Filters down to only latest state information.