external.avalanche Table: fact_p_blocks Type: View
What
Avalanche P-Chain Blocks. Please visit https://discord.gg/avax for any questions.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_HASH | TEXT | Unique identifier (hash) for the block |
| BLOCK_INDEX | NUMBER | Sequential index of the block within the chain |
| TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the block was produced |
| TYPE | TEXT | Type of block (e.g., proposal, commit, abort, etc.) |
| TX_COUNT | NUMBER | Number of transactions included in the block |
| BLOCK_SIZE | NUMBER | BLOCK_SIZE column |
| PARENT_HASH | TEXT | Hash of the parent block in the chain |
| PROPOSER_ID | TEXT | Identifier for the entity that proposed the block |
| PROPOSER_PARENT_ID | TEXT | PROPOSER_PARENT_ID column |
| PROPOSER_NODE_ID | TEXT | Unique node ID of the block proposer |
| PROPOSER_P_CHAIN_HEIGHT | NUMBER | The P‑Chain height as reported by the proposer (useful for cross-chain consistency checks) |
| PROPOSER_TIMESTAMP | TIMESTAMP_NTZ | Timestamp recorded by the proposer when creating the block |
| LAST_UPDATED | TIMESTAMP_NTZ | Timestamp of the last update to this record |
| LOAD_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the block data was loaded into Snowflake |
| BLOCK_HEIGHT | NUMBER | Block height on the chain indicating its position in the ledger |
| CURRENT_SUPPLY | TEXT | Current supply of AVAX (or chain native token) following block issuance (stored as VARCHAR for precision/format reasons) |
| L1_VALIDATOR_EXCESS_GAS | NUMBER | L1_VALIDATOR_EXCESS_GAS column |
| L1_VALIDATOR_ACCRUED_FEES | NUMBER | A fee counter that applies to the balance of all active Avalanche L1 Validators (non-primary network) |
| L1_VALIDATOR_ACTIVE_COUNT | NUMBER | Count of active validators on the L1 at the time of block creation |
| FEE_STATE_EXCESS | NUMBER | FEE_STATE_EXCESS column |
| FEE_STATE_CAPACITY | NUMBER | FEE_STATE_CAPACITY column |
| GAS_PRICE | NUMBER | Gas price used for transactions within the block |