Table: t_beacon_committees
Table Documentation: t_beacon_committees
t_beacon_committeesSummary:
The t_beacon_committees table stores information about committee assignments for validators at specific slots in the Beacon Chain. Committees are responsible for proposing blocks and attesting to block states, playing a crucial role in the consensus mechanism.
Description:
To avoid the overload on the network, voting in the attestation takes place in committees - groups of validators.
Each entry in this table represents a committee assignment at a given slot. It includes the slot number, the committee index within that slot, and a list of validator indices that are part of the committee. This data is vital for analyzing the participation of validators in the consensus process and the distribution of responsibilities across slots.
Schema Overview
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
f_slot | INT64 | YES | The slot number for which the committee is responsible. |
f_index | INT64 | YES | The index of the committee within the slot, providing a unique identifier. |
f_committee | STRING | YES | An array of validator indices that compose the committee, responsible for attesting to or proposing blocks during the slot. |
Example SQL Query
SELECT *
FROM raw_beacon_chain.t_beacon_committees
LIMIT 3;
Sample Query Result
| f_slot | f_index | f_committee |
|---|---|---|
| 626838 | 8 | {8853, 66922, 16487, ..., 62595} |
| 626856 | 1 | {61609, 18760, 88492, ..., 75126} |
| 626862 | 2 | {45342, 67006, 12030, ..., 78760} |
This sample result set shows the committee assignments for validators at specific slots. Each row includes the slot number (f_slot), committee index (f_index), and a list of validator indices (f_committee) that are part of the committee. The f_committee column lists are truncated to demonstrate the structure of the data.
The t_beacon_committees table is an essential resource for understanding the dynamics of validator committee assignments and their roles in securing the network through participation in consensus activities.
Updated 25 days ago