Table Details
| Property | Value |
|---|---|
| Table Name | beacon_hoodi.raw.block_rewards |
| Table Status | Beta 🌱 |
| 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 | Boolean indicating whether the reward execution was optimistic. |
| finalized | BOOLEAN | Boolean indicating whether the block rewards have been 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) | Beacon Chain slot number of the proposed block. |
| slot_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the Beacon Chain slot. |
| 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. |