external.avalanche Table: fact_x_vertices Type: View
What
Avalanche X-Chain Vertices. Please visit https://discord.gg/avax for any questions.Columns
| Column Name | Data Type | Description |
|---|---|---|
| VERTEX_HASH | TEXT | Unique identifier hash for the vertex |
| PARENT_HASH | TEXT | Hash of the parent vertex |
| VERTEX_HEIGHT | NUMBER | VERTEX_HEIGHT column |
| VERTEX_INDEX | NUMBER | VERTEX_INDEX column |
| VERTEX_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the vertex was created |
| TRANSACTION_COUNT | NUMBER | Number of transactions contained in the vertex |
| VERTEX_SIZE | NUMBER | VERTEX_SIZE column |
| LAST_UPDATED | TIMESTAMP_NTZ | LAST_UPDATED column |
| LOAD_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when data was loaded into Snowflake |
| IS_STOP_VERTEX | BOOLEAN | Indicates if this is a stop vertex in the DAG |