canton.core Table: fact_balance_changes Type: Base Table
What
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__eventswhere exercise_result contains balanceChanges - Links to transfer events via
event_id
Commonly-used Fields
party: The party whose balance changedchange_to_initial_amount: Change to the party’s initial amountchange_to_holding_fees_rate: Change to holding fees rateamulet_price: USD price of amulet at time of changeeffective_at: When the balance change occurred
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 |
| CHOICE | TEXT | CHOICE column |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| PARTY | TEXT | PARTY column |
| CHANGE_TO_HOLDING_FEES_RATE | NUMBER | CHANGE_TO_HOLDING_FEES_RATE column |
| CHANGE_TO_INITIAL_AMOUNT | NUMBER | CHANGE_TO_INITIAL_AMOUNT column |
| AMULET_PRICE | NUMBER | AMULET_PRICE column |
| FACT_BALANCE_CHANGE_ID | TEXT | FACT_BALANCE_CHANGE_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |