Table Details
| Property | Value |
|---|---|
| Table Name | spark.raw.blocks |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp_unix, block_number |
| Clustering Key(s) | to_date("block_timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_timestamp | TIMESTAMP_NTZ(9) | UTC timestamp of the block. Spark uses synthetic blocks minted once per second, so this advances by one second per block. |
| block_number | NUMBER(38,0) | Sequential block height. Spark mints one synthetic block per second, so block_number corresponds one-to-one with block_timestamp_unix. |
| genesis_epoch | NUMBER(38,0) | The genesis epoch identifier for the Spark network the block belongs to. |
| transaction_count | NUMBER(38,0) | Number of transactions included in this block. |
| block_timestamp_unix | NUMBER(38,0) | Unix timestamp (seconds) of the block. Equal to block_number plus a fixed offset, since blocks are minted one per second. |
| _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. |