Table: t_deposits

Table Documentation: t_deposits

Summary

The t_deposits table logs deposit events on the Ethereum 2.0 Beacon Chain, essential for validator activation. These records are pivotal for tracking the staking process required for network consensus participation.

Description

This table provides detailed insights into each deposit, including the associated slot, block root, index within the block, validator's public key, withdrawal credentials, and the deposited amount. These elements are crucial for understanding the onboarding process of validators onto the Beacon Chain and the allocation of funds within the Ethereum 2.0 staking mechanism.

Schema Overview

• f_inclusion_slot(INT64, Nullable): The slot number where the deposit was included on the Beacon Chain.
• f_inclusion_block_root(STRING, Nullable): The root hash of the block that included the deposit.
• f_inclusion_index(INT64, Nullable): Index of the deposit within the block it was included.
• f_validator_pubkey(STRING, Nullable): Public key of the validator making the deposit.
• f_withdrawal_credentials(STRING, Nullable): Withdrawal credentials for the deposit, specifying the withdrawal address.
• f_amount(INT64, Nullable): Amount of the deposit, in Gwei.

Example SQL Query

SELECT *
FROM raw_beacon_chain.t_deposits
LIMIT 3;

Sample Query Result

This sample output illustrates the structure of data returned by querying the t_deposits table. It includes details such as the inclusion slot, block root, index, validator's public key, withdrawal credentials, and the amount deposited for the first few records.

This comprehensive documentation outlines the structure and purpose of the t_deposits table, including how to query it and interpret its data, essential for understanding validator onboarding and fund allocation within the Ethereum 2.0 ecosystem.