canton.core Table: fact_updates Type: View
What
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 | UPDATE_ID column |
| MIGRATION_ID | NUMBER | MIGRATION_ID column |
| RECORD_TIME | TIMESTAMP_NTZ | RECORD_TIME column |
| EFFECTIVE_AT | TIMESTAMP_NTZ | EFFECTIVE_AT column |
| SYNCHRONIZER_ID | TEXT | SYNCHRONIZER_ID column |
| WORKFLOW_ID | TEXT | WORKFLOW_ID column |
| ROOT_EVENT_IDS | VARIANT | ROOT_EVENT_IDS column |
| EVENT_COUNT | NUMBER | EVENT_COUNT column |
| FACT_UPDATE_ID | TEXT | FACT_UPDATE_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |