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

​
Description

Comprehensive fact table tracking all amulet transfer operations across multiple transfer-related choices. Handles various transfer types including direct transfers, transfer commands, factory transfers, and preapproved transfers.

​
Key Use Cases

  • Analyzing transfer volume and patterns
  • Tracking sender/receiver relationships
  • Understanding transfer amounts and fees
  • Monitoring different transfer mechanisms (direct, command, preapproval, factory)

​
Important Relationships

  • Links to balance changes through event_id
  • References rounds and amulet rules through context
  • Provider field links to service providers facilitating transfers

​
Commonly-used Fields

  • choice: Type of transfer (AmuletRules_Transfer, TransferCommand_Send, etc.)
  • amount: Transfer amount (from choice_argument)
  • sender: Sending party
  • receiver: Receiving party
  • provider: Service provider facilitating the transfer
  • amulet_amount: Actual amulet paid (from exercise_result)
  • transfer_summary: Summary of transfer including fees and amounts

​
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.
AMOUNTTEXTGeneric numeric amount field. Context determines what is being measured (transfer amount, reward amount, etc.).
SENDERTEXTParty identifier for the sender in a transfer operation.
RECEIVERTEXTParty identifier for the receiver in a transfer operation.
PROVIDERTEXTParty identifier for a service provider facilitating an operation (often transfers).
DELEGATETEXTParty identifier for a delegate who can act on behalf of another party.
DESCRIPTIONTEXTText description providing context for an operation.
NONCETEXTUnique nonce value for ensuring transaction uniqueness.
EXPIRES_ATTEXTTimestamp when something expires (transfer preapproval, lock, etc.).
EXPECTED_DSOTEXTExpected DSO party identifier for validation purposes.
CONTEXTTEXTJSON object containing contextual information for an operation.
TRANSFER_OBJECTTEXTJSON object containing full transfer details.
TRANSFER_COMMAND_CIDTEXTContract ID for a TransferCommand contract.
TRANSFER_PREAPPROVAL_CIDTEXTContract ID for a TransferPreapproval contract.
AMULET_AMOUNTTEXTSpecific amount of amulets paid or transferred.
TRANSFER_SUMMARYTEXTJSON object summarizing transfer results including fees and amounts.
TRANSFER_METATEXTJSON object containing transfer metadata.
EVENT_TYPETEXTType of event: ‘created_event’ for contract creation or ‘exercised_event’ for method execution on existing contracts.
CONTRACT_IDTEXTUnique identifier for the contract being created or exercised in this event.
PACKAGE_NAMETEXTThe Canton package name containing the contract template.
TEMPLATE_IDTEXTThe template/type of the contract, including package information. Format: ‘package_id:ModuleName:ContractType’
CONSUMINGTEXTBoolean indicating whether this action consumes/archives the contract.
FACT_TRANSFER_IDTEXTSurrogate key generated from event_id
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).