Skip to main content
Schema: canton.core Table: fact_balance_changes Type: Incremental

​
Description

Tracks balance changes for parties resulting from transfer operations. Uses LATERAL FLATTEN to extract individual balance changes from the balanceChanges array in transfer event results.

​
Key Use Cases

  • Analyzing balance movements for specific parties
  • Understanding holding fee impacts
  • Tracking initial amount changes per party
  • Monitoring amulet price at time of balance changes

​
Important Relationships

  • Derived from silver__events where exercise_result contains balanceChanges
  • Links to transfer events via event_id

​
Commonly-used Fields

  • party: The party whose balance changed
  • change_to_initial_amount: Change to the party’s initial amount
  • change_to_holding_fees_rate: Change to holding fees rate
  • amulet_price: USD price of amulet at time of change
  • effective_at: When the balance change occurred

​
Columns

Column NameData TypeDescription
UPDATE_IDTEXTUnique identifier for the Canton update/transaction. An update contains one or more events and represents an atomic change to the blockchain state.
MIGRATION_IDTEXTCanton migration identifier. Used to track different phases or migrations in the Canton network’s evolution.
RECORD_TIMETEXTTimestamp when the update was recorded in the system.
EFFECTIVE_ATTEXTTimestamp when the event or update became effective on the blockchain. This is the canonical time for ordering and analyzing blockchain events.
EVENT_IDTEXTUnique identifier for the event within the Canton blockchain.
EVENT_INDEXTEXTOrdering index of events within an update. Events within the same update are sequentially numbered starting from 0.
CHOICETEXTThe choice/action/method being executed on a contract. Examples include ‘DsoRules_RequestVote’, ‘AmuletRules_Transfer’, ‘LockedAmulet_Unlock’, etc.
ACTING_PARTIESTEXTArray of party identifiers who are executing this action/choice.
PARTYTEXTParty identifier representing a participant in the Canton network. Can be a validator, user, app provider, or other entity.
CHANGE_TO_HOLDING_FEES_RATETEXTNumeric change to the holding fees rate for a party.
CHANGE_TO_INITIAL_AMOUNTTEXTNumeric change to a party’s initial amulet amount from a balance change operation.
AMULET_PRICETEXTUSD price of one amulet at the time of the event.
FACT_BALANCE_CHANGE_IDTEXTSurrogate key generated from event_id and party
INSERTED_TIMESTAMPTEXTTimestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMPTEXTTimestamp when the record was last modified in this table (Snowflake SYSDATE).