Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.ideal_rewards |
| Table Status | Production-Ready |
| Unique Key | epoch_number, effective_balance |
| Clustering Key(s) | to_date("epoch_timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| epoch_timestamp | TIMESTAMP_NTZ(9) | Epoch timestamp when the validator is scheduled to propose a block. |
| execution_optimistic | BOOLEAN | If the slot/epoch is executed optimistically. |
| effective_balance | NUMBER(38,0) | Effective balance of the validator. |
| head | VARCHAR(16777216) | 534132 |
| target | VARCHAR(16777216) | 1034226 |
| source | VARCHAR(16777216) | 552116 |
| inclusion_delay | VARCHAR(16777216) | 0 |
| inactivity | VARCHAR(16777216) | 0 |
| _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. |
| epoch_number | NUMBER(38,0) | Epoch number of the state where the pending deposits to beacon chain is fetched. |