Fact Updates

core.fact_updates

Schema: 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 update
• migration_id: Canton migration identifier
• effective_at: When the update occurred
• synchronizer_id: The synchronizer that processed the update
• workflow_id: Workflow identifier
• root_event_ids: The top-level events in this update
• event_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).