canton.core Table: fact_transfer_summary Type: Base Table
What
Description
Event-level summary table for AmuletRules_Transfer operations on the Canton network. This table contains one row per transfer event with aggregate information including total fees, output counts, mining round context, and full arrays of inputs/outputs. For individual output details, seecore__fact_transfers.
Key Use Cases
- Analyzing total transfer fees and costs per event
- Understanding transfer context (mining round, DSO state, validator rights)
- Tracking aggregate transfer metrics (number of outputs, total fees)
- Examining balance changes and created amulets from transfers
- Linking transfers to mining rounds and pricing information
Important Relationships
- Links to
core__fact_transfersviaevent_idfor flattened output details - Links to
core__fact_balance_changesviaevent_idfor detailed balance impacts per party - References mining rounds via
round_number - Contains full
outputsarray that is flattened incore__fact_transfers
Commonly-used Fields
event_id: Unique identifier linking to output-level detailssender: Party sending the amuletprovider: Validator facilitating the transferreceivers: Array of all receiver parties ordered by output indexsender_change_fee: Total sender change fee for the transferholding_fees: Total holding fees for the transfernum_outputs: Count of outputs in this transfertotal_output_fees: Sum of all output feesamulet_price: USD price of amulet at time of transferinput_amulet_amount: Total amount of input amuletssender_change_amount: Change returned to senderround_number: Mining round when transfer occurredoutputs: Full array of transfer outputsbalance_changes: Array of balance changes per partytransfer_meta: Metadata including sender and tx-kindtx_kind: Transaction kind (e.g., payment, reward)
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 |
| SENDER | TEXT | SENDER column |
| PROVIDER | TEXT | PROVIDER column |
| RECEIVERS | ARRAY | RECEIVERS column |
| SENDER_CHANGE_FEE | NUMBER | SENDER_CHANGE_FEE column |
| HOLDING_FEES | NUMBER | HOLDING_FEES column |
| NUM_OUTPUTS | NUMBER | NUM_OUTPUTS column |
| TOTAL_RECEIVER_FEE_RATIO | NUMBER | TOTAL_RECEIVER_FEE_RATIO column |
| TOTAL_OUTPUT_FEES | NUMBER | TOTAL_OUTPUT_FEES column |
| AMULET_PRICE | NUMBER | AMULET_PRICE column |
| INPUT_AMULET_AMOUNT | NUMBER | INPUT_AMULET_AMOUNT column |
| SENDER_CHANGE_AMOUNT | NUMBER | SENDER_CHANGE_AMOUNT column |
| BALANCE_CHANGES | VARIANT | BALANCE_CHANGES column |
| INPUTS | VARIANT | INPUTS column |
| OUTPUTS | VARIANT | OUTPUTS column |
| BENEFICIARIES | VARIANT | BENEFICIARIES column |
| EXPECTED_DSO | TEXT | EXPECTED_DSO column |
| FEATURED_APP_RIGHT | TEXT | FEATURED_APP_RIGHT column |
| OPEN_MINING_ROUND | TEXT | OPEN_MINING_ROUND column |
| ISSUING_MINING_ROUNDS | VARIANT | ISSUING_MINING_ROUNDS column |
| VALIDATOR_RIGHTS | VARIANT | VALIDATOR_RIGHTS column |
| ROUND_NUMBER | NUMBER | ROUND_NUMBER column |
| CREATED_AMULETS | VARIANT | CREATED_AMULETS column |
| SENDER_CHANGE_AMULET | TEXT | SENDER_CHANGE_AMULET column |
| TRANSFER_META | VARIANT | TRANSFER_META column |
| TX_KIND | TEXT | TX_KIND column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| TEMPLATE_ID | TEXT | TEMPLATE_ID column |
| CONSUMING | BOOLEAN | CONSUMING column |
| FACT_TRANSFER_SUMMARY_ID | TEXT | FACT_TRANSFER_SUMMARY_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |