Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.consolidations |
| Table Status | Production-Ready |
| Unique Key | slot_timestamp::date, unique_id |
| Clustering Key(s) | slot_timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| 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. |
| array_index | NUMBER(38,0) | 178,393 |
| source_address | VARCHAR(134217728) | The address of the source validator. |
| source_pubkey | VARCHAR(134217728) | The source validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| source_validator_index | NUMBER(38,0) | The index of the source validator in the validator registry. |
| target_pubkey | VARCHAR(134217728) | The target validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive |
| target_validator_index | NUMBER(38,0) | The index of the target validator in the validator registry. |
| unique_id | VARCHAR(134217728) | date-2023-05-10_validator_index-459015 |
| _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. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |