canton.core Table: fact_transfers Type: Base Table
What
Description
Fact table tracking individual outputs from AmuletRules_Transfer operations on the Canton network. This table is at the output level - each row represents one output from a transfer, where a single transfer event may create multiple outputs to different receivers. Contains sender, receiver, transfer amounts, and lock details. For event-level summary information including total fees and context, seecore__fact_transfer_summary.
Key Use Cases
- Analyzing transfer volume and patterns between parties at output level
- Tracking sender/receiver relationships and transfer flows
- Understanding individual output amounts per receiver
- Aggregating outputs by receiver to calculate total received amounts
- Analyzing locked amulet creation via output lock details
Important Relationships
- Links to
core__fact_transfer_summaryviaevent_idfor event-level fees, context, and aggregates - Links to
core__fact_balance_changesviaevent_idfor detailed balance impacts per party - Multiple rows with same
event_idrepresent different outputs of the same transfer - Provider field identifies validators facilitating transfers
Commonly-used Fields
event_id: Links to event-level summaryoutput_index: Index of this output within the transfer (0-based)sender: Party sending the amuletreceiver: Party receiving this output of the transferprovider: Validator facilitating the transferamount: Amount being transferred to this receiver in this outputreceiver_fee_ratio: Fee ratio for this receiver outputlock: Lock details if this output creates a locked amulettx_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 |
| OUTPUT_INDEX | NUMBER | OUTPUT_INDEX column |
| SENDER | TEXT | SENDER column |
| PROVIDER | TEXT | PROVIDER column |
| RECEIVER | TEXT | RECEIVER column |
| AMOUNT | NUMBER | AMOUNT column |
| RECEIVER_FEE_RATIO | NUMBER | RECEIVER_FEE_RATIO column |
| LOCK | VARIANT | LOCK column |
| TX_KIND | TEXT | TX_KIND column |
| FACT_TRANSFER_ID | TEXT | FACT_TRANSFER_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |