| 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. |
| EVENT_ID | TEXT | Unique identifier for the event within the Canton blockchain. |
| EVENT_INDEX | TEXT | Ordering index of events within an update. Events within the same update are sequentially numbered starting from 0. |
| ROUND_NUMBER | TEXT | Sequential number identifying a mining round in the Canton network. |
| AMULET_TO_ISSUE_PER_YEAR | TEXT | Target annual issuance rate of amulets in the issuance configuration. |
| VALIDATOR_REWARD_PERCENTAGE | TEXT | Percentage of issuance allocated to validator rewards. |
| APP_REWARD_PERCENTAGE | TEXT | Percentage of issuance allocated to application rewards. |
| VALIDATOR_REWARD_CAP | TEXT | Maximum amulet amount for validator rewards. |
| FEATURED_APP_REWARD_CAP | TEXT | Maximum amulet amount for featured app rewards. |
| UNFEATURED_APP_REWARD_CAP | TEXT | Maximum amulet amount for unfeatured app rewards. |
| VALIDATOR_FAUCET_CAP | TEXT | Maximum amulet amount for validator faucet (optional/may be NULL). |
| AMULET_PRICE_USD | TEXT | USD price of one amulet. |
| TICK_DURATION_MICROSECONDS | TEXT | Duration of each tick in microseconds. |
| DSO_PARTY | TEXT | Party identifier for the DSO (Digital Synchronizer Operator) that manages network governance and operations. |
| EVENT_TYPE | TEXT | Type of event: ‘created_event’ for contract creation or ‘exercised_event’ for method execution on existing contracts. |
| CONTRACT_ID | TEXT | Unique identifier for the contract being created or exercised in this event. |
| PACKAGE_NAME | TEXT | The Canton package name containing the contract template. |
| TEMPLATE_ID | TEXT | The template/type of the contract, including package information. Format: ‘package_id:ModuleName:ContractType’ |
| CREATED_AT | TEXT | Timestamp when the contract was created. |
| SIGNATORIES | TEXT | Array of party identifiers who are signatories to the contract. |
| OBSERVERS | TEXT | Array of party identifiers who can observe the contract but are not signatories. |
| ISSUANCE_CONFIG | TEXT | JSON object containing full issuance configuration. |
| EVENT_JSON | TEXT | Full JSON object containing all event data. Useful for detailed analysis and accessing fields not explicitly extracted. |
| FACT_MINING_ROUND_ID | TEXT | Surrogate key generated from round_number |
| 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). |
