[genesis + N seconds, genesis + (N+1) seconds).
Table Details
| Property | Value |
|---|---|
| Table Name | canton.raw.blocks |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, block_number |
| Clustering Key(s) | to_date("block_timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_number | NUMBER(38,0) | Synthetic block index derived as floor(unix(record_time) - genesis_epoch). One block per second starting from genesis on 2024-06-24T21:00:00Z. |
| migration_id | NUMBER(38,0) | Synchronizer migration epoch. Canton upgrades increment this value (currently 0–4). The active migration_id must match the time range being queried. |
| genesis_epoch | NUMBER(38,0) | Unix timestamp of Canton’s genesis block (1719266400, corresponding to 2024-06-24T21:00:00Z). Used to compute block_number from record_time. |
| genesis_timestamp | TIMESTAMP_NTZ(9) | Timestamp of Canton’s genesis block (2024-06-24T21:00:00Z). The start of the 1-second windowed block numbering scheme. |
| block_timestamp | TIMESTAMP_NTZ(9) | Start of the 1-second window for this synthetic block, equal to genesis_timestamp + block_number seconds. |
| block_timestamp_unix | NUMBER(38,0) | Unix timestamp of block_timestamp. Equal to genesis_epoch + block_number. |
| update_count | NUMBER(38,0) | Number of Canton transactions (updates) whose record_time falls within this 1-second block window. |
| event_count | NUMBER(38,0) | Total number of events across all updates in this block window. Each update produces multiple events (created_event and exercised_event). |
| _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. |
| private_update_count | NUMBER(38,0) | Number of verdict-only private updates (transactions we are not an informee on) processed in this Canton block. |