canton.core Table: fact_events Type: View
What
Description
Core fact table exposing all Canton events from the blockchain with pre-extracted fields for easy analysis. This is the most granular event-level table and serves as the foundation for understanding all Canton blockchain activity.Key Use Cases
- Analyzing complete event history and patterns
- Joining to specialized fact tables for detailed analysis
- Exploring contract lifecycle (creation, exercise, archival)
- Understanding party interactions through acting_parties, signatories, and observers
Important Relationships
- Source for all other event-based fact tables
- Joins to
core__fact_updatesviaupdate_id - Can be filtered by
choiceto find specific action types - Can be filtered by
template_idto find specific contract types
Commonly-used Fields
event_id: Unique identifier for the eventevent_index: Ordering of events within an updatechoice: The action/method being executed (for exercised events)event_type: created_event or exercised_eventeffective_at: When the event occurredcontract_id: The contract being created or exercisedtemplate_id: The contract template type
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 |
| EVENT_ID | TEXT | EVENT_ID column |
| EVENT_INDEX | NUMBER | EVENT_INDEX column |
| IS_ROOT_EVENT | BOOLEAN | IS_ROOT_EVENT column |
| EVENT_TYPE | TEXT | EVENT_TYPE column |
| CHOICE | TEXT | CHOICE column |
| CONSUMING | BOOLEAN | CONSUMING column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| PACKAGE_NAME | TEXT | PACKAGE_NAME column |
| INTERFACE_ID | TEXT | INTERFACE_ID column |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| SIGNATORIES | VARIANT | SIGNATORIES column |
| OBSERVERS | VARIANT | OBSERVERS column |
| CHILD_EVENT_IDS | VARIANT | CHILD_EVENT_IDS column |
| CREATED_AT | TIMESTAMP_NTZ | CREATED_AT column |
| CHOICE_ARGUMENT | VARIANT | CHOICE_ARGUMENT column |
| EXERCISE_RESULT | VARIANT | EXERCISE_RESULT column |
| CREATE_ARGUMENTS | VARIANT | CREATE_ARGUMENTS column |
| EVENT_JSON | VARIANT | EVENT_JSON column |
| FACT_EVENT_ID | TEXT | FACT_EVENT_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |