monad.gov Table: dim_miner_validators Type: Base Table
What
Slowly Changing Dimension (Type 2) tracking miner address to validator ID relationships. Each row represents a period where a specific miner was the block producer for a validator. Ranges are defined by start/end blocks showing when each miner-validator association was active. A new range is created when a validator switches to a different miner address.Columns
| Column Name | Data Type | Description |
|---|---|---|
| VALIDATOR_ID | NUMBER | ID of the validator |
| MINER | TEXT | Block producer address from block headers |
| START_BLOCK | NUMBER | First block where this miner-validator association was active |
| END_BLOCK | NUMBER | Last block where this miner-validator association was active (updated incrementally) |
| START_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of the start block |
| END_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of the end block |
| BLOCKS_PRODUCED | NUMBER | Number of blocks produced during this range |
| DURATION_SECONDS | NUMBER | Duration of this range in seconds |
| IS_CURRENT | BOOLEAN | Whether this is the current active range for this validator |
| NEXT_MINER | TEXT | The miner address that took over after this range (NULL if current) |
| DIM_MINER_VALIDATORS_ID | TEXT | Unique identifier for this record |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was inserted |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the record was last modified |