Skip to main content
Schema: canton.gov Table: fact_validator_rewards Type: Incremental

​
Description

Tracks validator reward claims via AmuletRules_Transfer events where metadata contains validator-rewards information. Captures reward amounts, burned amounts, and net rewards.

​
Key Use Cases

  • Analyzing validator reward distribution
  • Calculating net rewards after burns
  • Tracking reward timing by mining round
  • Monitoring validator economics and incentives

​
Important Relationships

  • Links to mining rounds via round_number
  • Links to validators via validator_party
  • Related to gov__fact_validator_activity (activity enables rewards)

​
Commonly-used Fields

  • validator_party: Party receiving the reward
  • reward_amount: Gross reward amount from metadata
  • burned_amount: Amount burned in the process
  • net_reward_amount: Calculated field (reward_amount - burned_amount)
  • mining_round: Round number associated with reward
  • round_number: Round from exercise result

​
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.
VALIDATOR_RIGHTSTEXTJSON object describing validator rights and capabilities.
ISSUING_MINING_ROUNDSTEXTJSON array of issuing mining rounds from context.
MINING_ROUNDTEXTMining round number from context or choice arguments.
VALIDATOR_PARTYTEXTParty identifier for a validator.
EXERCISE_RESULTTEXTJSON object containing the full result of exercising a choice on a contract.
REWARD_AMOUNTTEXTAmount of reward (in amulets) being distributed or processed.
BURNED_AMOUNTTEXTAmount of amulets burned in a transaction.
NET_REWARD_AMOUNTTEXTNet reward amount after subtracting burns (reward_amount - burned_amount).
ALL_META_VALUESTEXTJSON object containing all metadata key-value pairs.
TRANSFER_SUMMARYTEXTJSON object summarizing transfer results including fees and amounts.
ROUND_NUMBERTEXTSequential number identifying a mining round in the Canton network.
CONTRACT_IDTEXTUnique identifier for the contract being created or exercised in this event.
FACT_VALIDATOR_REWARD_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).