Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.attestations |
| Table Status | Production-Ready |
| Unique Key | slot_timestamp::date, unique_id |
| Clustering Key(s) | slot_timestamp::date |
| Search Optimization | slot_number, proposer_index, target_epoch |
beacon.raw.attestations table contains the attestations included in each block, flattened from beacon.raw.blocks.
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. |
| eth1_block_hash | VARCHAR(134217728) | 0xc0efee09619b108b8c184d7c4981b96bcef8fe63e6887f3ee20728d5ca6d6e67 |
| eth1_block_number | NUMBER(38,0) | 17,030,996 |
| eth1_block_timestamp | TIMESTAMP_NTZ(9) | 2023-04-12 09:19:47 |
| array_index | NUMBER(38,0) | 178,393 |
| proposer_index | NUMBER(38,0) | Index of the validator who proposed the block. |
| attestation_index | NUMBER(38,0) | 9 |
| aggregation_bits | VARCHAR(134217728) | 0xfdfffffffffffffffffffffffffffff9fffff7fff7ffffffffffffbfffffffffffff0f |
| beacon_block_root | VARCHAR(134217728) | 0xb5879b53ac4f9909860b3d072538e20e89cd3dc68beb93bcbd0e3309c6f2a367 |
| attestation_slot | NUMBER(38,0) | 6,205,596 |
| source_epoch | NUMBER(38,0) | 193,923 |
| source_root | VARCHAR(134217728) | 0x224f895b66497a41d80a68425721ac2b76a08a03464c2811dab4bd306d9d69fb |
| target_epoch | NUMBER(38,0) | 193,924 |
| target_root | VARCHAR(134217728) | 0x9f1552c4c27be5ba449eab378015bfd9a5e36c0829586fa6c51a8319ac852071 |
| attestation_signature | VARCHAR(134217728) | 0x94a253070e95f22cb83a295f1ee5b19438701ff1aa60de46ee5aa05df459762776a1d58dc36cbaa973f7e0e009360eba10a1f6995ffd719af209597206b737d2793c533236edb7c73aa59e0dddf47560eb1968f7e665022bfa2ba51dfadc5247 |
| 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. |