Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.block_rewards |
| Table Status | Production-Ready |
| Unique Key | slot_number |
| Clustering Key(s) | to_date("slot_timestamp") |
| Search Optimization | slot_number |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| attestations | VARCHAR(16777216) | Total rewards from attestations included in the block. |
| attester_slashings | VARCHAR(16777216) | Rewards from attester slashings included in the block. |
| execution_optimistic | BOOLEAN | If the slot/epoch is executed optimistically. |
| finalized | BOOLEAN | If the slot/epoch is finalized. |
| proposer_index | NUMBER(38,0) | Index of the validator who proposed the block. |
| proposer_slashings | VARCHAR(16777216) | Rewards from proposer slashings included in the block. |
| 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. |
| sync_aggregate | VARCHAR(16777216) | Total rewards from sync committee participation included in the block. |
| total | VARCHAR(16777216) | Total reward for the block, combining all reward components. |
| _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. |