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

# Schema changes overview

> Beacon Chain deprecation timeline, replacement tables, and publication status

As part of ongoing schema updates and standardization, legacy `beacon.validator.*` tables are being replaced by `beacon.raw.*` tables. Use this overview for timelines and status; open each migration page for full column mappings and breaking changes.

<Warning>
  **Schema changes**

  The following tables will be replaced by **May 23, 2026**:

  * `beacon.validator.balances_latest` → `beacon.raw.balances_latest`
  * `beacon.validator.balances` → `beacon.raw.balances_daily`
  * `beacon.validator.index` → use `beacon.raw.balances_latest` (no separate registry table)
</Warning>

## At a glance

| Legacy table                                                                                                                 | Replacement                  | Replacement live (est.)               | End of life  | Last published |
| ---------------------------------------------------------------------------------------------------------------------------- | ---------------------------- | ------------------------------------- | ------------ | -------------- |
| [`beacon.validator.balances_latest`](/historical-data/supported-blockchains/evm/beacon-chain/schema-changes/balances-latest) | `beacon.raw.balances_latest` | April 7, 2026                         | May 23, 2026 | April 7, 2026  |
| [`beacon.validator.balances`](/historical-data/supported-blockchains/evm/beacon-chain/schema-changes/balances)               | `beacon.raw.balances_daily`  | April 14, 2026                        | May 23, 2026 | April 7, 2026  |
| [`beacon.validator.index`](/historical-data/supported-blockchains/evm/beacon-chain/schema-changes/validator-index)           | `beacon.raw.balances_latest` | April 7, 2026 (fields on replacement) | May 23, 2026 | April 7, 2026  |

**Document version:** 1.2 · **Last updated:** April 7, 2026

## Per-table migration guides

* **[`beacon.validator.balances_latest` → `beacon.raw.balances_latest`](/historical-data/supported-blockchains/evm/beacon-chain/schema-changes/balances-latest)** — Latest snapshot per validator; Wei → ETH floats, new withdrawal columns, `UNIQUE_ID`.
* **[`beacon.validator.balances` → `beacon.raw.balances_daily`](/historical-data/supported-blockchains/evm/beacon-chain/schema-changes/balances)** — Daily history; column reorder, `IS_SLASHED` → `SLASHED`, `UNIQUE_ID` format change.
* **[`beacon.validator.index`](/historical-data/supported-blockchains/evm/beacon-chain/schema-changes/validator-index)** — Registry retired; read equivalent fields from `beacon.raw.balances_latest`.

***

## FAQ

**Will queries break immediately?**\
No. Deprecated tables remain available until **May 23, 2026**.

**How do I convert Wei to ETH/Gwei?**

```sql theme={null}
raw_balance::numeric / 1e9
```

**Why use strings for balances?**\
To prevent floating-point precision loss. Wei values can exceed safe float precision.

***

## Support

**Questions?** Contact Allium Support at [support@allium.so](mailto:support@allium.so)

**Related tables:**

* `beacon.raw.balances_latest` (replacement for `beacon.validator.balances_latest` and `beacon.validator.index`)
* `beacon.raw.balances_daily` (replacement for `beacon.validator.balances`)
