canton.core Table: fact_updates Type: View
Description
Tracks Canton update-level information. An update is a transaction that contains one or more events and represents an atomic change to the blockchain state.Key Use Cases
- Understanding transaction-level activity
- Analyzing update throughput and patterns
- Joining to events to see all changes in a single transaction
- Tracking workflow and synchronizer information
Important Relationships
- Parent table to
core__fact_events(one update has many events) - Links to events via
update_id
Commonly-used Fields
update_id: Unique identifier for the updatemigration_id: Canton migration identifiereffective_at: When the update occurredsynchronizer_id: The synchronizer that processed the updateworkflow_id: Workflow identifierroot_event_ids: The top-level events in this updateevent_count: Number of events in this update
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | Unique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state. |
| MIGRATION_ID | TEXT | Canton migration identifier. Used to track different phases or migrations in the Canton network’s evolution. |
| RECORD_TIME | TEXT | Timestamp when the update was recorded in the system. |
| EFFECTIVE_AT | TEXT | Timestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events. |
| SYNCHRONIZER_ID | TEXT | Identifier for the Canton synchronizer that processed this update. |
| WORKFLOW_ID | TEXT | Identifier for the workflow associated with this update. |
| ROOT_EVENT_IDS | TEXT | Array of event IDs that are root-level events in this update. |
| EVENT_COUNT | TEXT | Number of events contained in this update. |
| FACT_UPDATE_ID | TEXT | Surrogate key generated from update_id |
| INSERTED_TIMESTAMP | TEXT | Timestamp when the record was inserted into this table (Snowflake SYSDATE). |
| MODIFIED_TIMESTAMP | TEXT | Timestamp when the record was last modified in this table (Snowflake SYSDATE). |