Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.validator_duties |
| Table Status | Production-Ready |
| Unique Key | slot_number |
| Clustering Key(s) | to_date("slot_timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| slot_timestamp | TIMESTAMP_NTZ(9) | Slot timestamp of the state where the pending deposits to beacon chain is fetched. |
| epoch_timestamp | TIMESTAMP_NTZ(9) | Epoch timestamp when the validator is scheduled to propose a block. |
| dependent_root | VARCHAR(16777216) | The block root that this validator duties is dependent on. |
| validator_index | NUMBER(38,0) | 916,865 |
| pubkey | VARCHAR(16777216) | 0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f |
| execution_optimistic | BOOLEAN | If the slot/epoch is executed optimistically. |
| _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. |
| slot_number | NUMBER(38,0) | Slot number of the state where the pending deposits to beacon chain is fetched. |
| epoch_number | NUMBER(38,0) | Epoch number of the state where the pending deposits to beacon chain is fetched. |