Table Details
| Property | Value |
|---|---|
| Table Name | beacon.raw.pending_deposits |
| Table Status | Beta 🌱 |
| Unique Key | slot_number, pubkey, pending_deposit_index, amount |
| Clustering Key(s) | to_date("slot_timestamp") |
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. |
| epoch_number | NUMBER(38,0) | Epoch number of the state where the pending deposits to beacon chain is fetched. |
| pubkey | VARCHAR(16777216) | 0xb20cbf80ded11e4089be8ff68c3150aa19f1a5dc064450a1a10097194f1d09d470261c183d8ca44717a4da7cafa11c4f |
| amount | VARCHAR(16777216) | Amount of reward normalized. |
| withdrawal_credentials | VARCHAR(16777216) | 0x010000000000000000000000e839a3e9efb32c6a56ab7128e51056585275506c |
| signature | VARCHAR(16777216) | 0x82a96e6e9a0ed5e55f6e6df5d1cb0c90d42ebf03b30dba2c202b8decc9261b077552794b89c8e330bb64256bbb9a5c9a012bb211bbd02ca01b2472cba8d5f033e0deef4de4617bcafa4c706db43333ba417c92a97c3bb9c9c1edfea088654c82 |
| execution_optimistic | BOOLEAN | If the slot/epoch is executed optimistically. |
| finalized | BOOLEAN | If the slot/epoch is finalized. |
| pending_deposit_index | NUMBER(38,0) | Array index of the pending deposit for the given epoch. |
| _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(38,0) | The slot number of the block. |