Table: t_attestations

Table Documentation: `t_attestations`

Summary:
Records evidence of validator attestations, which are crucial for the consensus mechanism of the Ethereum PoS Beacon Chain.

Description:
The t_attestations table captures instances where validators vote and agree on the state of the blockchain. Each attestation includes details about the validator's view of the blockchain's state at a particular point in time.
Attestations are the votes of each validators for new block to agree common vision of the new added blocks and to avoid forks and the network. Attestations provided by each validator every blockchain period - epoch - and they can be called an indicator of the performance of validators. To avoid the overload on the network, voting in the attestation takes place in committees - groups of validators

Schema Overview

Column Name	Data Type	Nullable	Description
`f_inclusion_slot`	INT64	YES	The slot number in which the attestation was included.
`f_inclusion_block_root`	STRING	YES	The root of the block in which the attestation was included.
`f_inclusion_index`	INT64	YES	The index of the attestation within the block.
`f_slot`	INT64	YES	The slot number to which the attestation pertains.
`f_committee_index`	INT64	YES	The index of the committee making the attestation.
`f_aggregation_bits`	STRING	YES	The bitfield representing the validators that agree with the attestation.
`f_aggregation_indices`	STRING	YES	The indices of the validators that are part of the committee.
`f_beacon_block_root`	STRING	YES	The root of the beacon block at the attested slot.
`f_source_epoch`	INT64	YES	The epoch of the attestation's source checkpoint.
`f_source_root`	STRING	YES	The root of the attestation's source checkpoint.
`f_target_epoch`	INT64	YES	The epoch of the attestation's target checkpoint.
`f_target_root`	STRING	YES	The root of the attestation's target checkpoint.
`f_canonical`	BOOL	YES	Indicates if the attestation is for a block that is part of the canonical chain.
`f_target_correct`	BOOL	YES	Indicates if the target root is correct according to the chain view.
`f_head_correct`	BOOL	YES	Indicates if the attested beacon block root is the head of the chain view.

Example SQL Query

SELECT *
FROM raw_beacon_chain.t_attestations
LIMIT 3;

Sample Query Result

f_inclusion_slot	f_inclusion_block_root	f_inclusion_index	f_slot	...	f_head_correct
615347	\xddec6246f1ca9d854234fcc87f1df1c83f719b924...	12	615346	...	TRUE
615354	\x6abdd2f4a8a7713118f1c0d6fe995bb18ac352548...	43	615352	...	TRUE
615358	\xcb2ad38717ae628e03fd24d9c3d1ad2aa317940...	43	615353	...	TRUE

The table above displays a truncated view of the results from querying the t_attestations table. Each row corresponds to an attestation record, providing insight into validator participation and consensus on the network state.

Table Documentation: t_attestations

Schema Overview

Example SQL Query

Sample Query Result

Table Documentation: `t_attestations`