Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
| Property | Value |
|---|---|
| Table Name | beacon.raw.consolidations |
| Table Status | Production-Ready |
| Unique Key | slot_timestamp::date, unique_id |
| Clustering Key(s) | slot_timestamp::date |
beacon.raw.consolidations table provides the validator consolidation requests (EIP-7251) included in Beacon Chain blocks, flattened from the execution_requests field of beacon.raw.blocks.
This feature was added in the Pectra upgrade, so the table only covers slots after 2025-05-07. A request where the source and target pubkey are the same is a switch to compounding (0x02) withdrawal credentials rather than a merge of two validators.
| Column Name | Data Type | Description |
|---|---|---|
| slot_number | NUMBER(38,0) | Slot number of the state where the pending deposits to beacon chain is fetched. |
| slot_timestamp | TIMESTAMP_NTZ(9) | Slot timestamp of the state where the pending deposits to beacon chain is fetched. |
| array_index | NUMBER(38,0) | 178,393 |
| source_address | VARCHAR(134217728) | The address of the source validator. |
| source_pubkey | VARCHAR(134217728) | The source validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| source_validator_index | NUMBER(38,0) | The index of the source validator in the validator registry. |
| target_pubkey | VARCHAR(134217728) | The target validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| target_validator_index | NUMBER(38,0) | The index of the target validator in the validator registry. |
| unique_id | VARCHAR(134217728) | date-2023-05-10_validator_index-459015 |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
Was this page helpful?