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

​
Description

Tracks successful validator onboarding events for both regular validators (DsoRules_OnboardValidator) and super validators (DsoRules_ConfirmSvOnboarding). Represents the final confirmation step in validator onboarding.

​
Key Use Cases

  • Monitoring successful validator onboardings
  • Distinguishing between validator and super validator onboardings
  • Tracking validator party identifiers and names
  • Analyzing onboarding timing and actors

​
Important Relationships

  • Final step after gov__fact_validator_onboarding_requests
  • Links to gov__fact_validator_offboarding_events for complete lifecycle
  • Core table in gov__ez_validator_onboarding_lifecycle comprehensive view

​
Commonly-used Fields

  • onboarding_type: ‘validator’ or ‘super_validator’
  • validator_party: Party ID of the onboarded validator
  • validator_name: Name of the validator
  • sv_party: Party ID if onboarding as super validator
  • sv_onboarding_confirmed: Contract ID from SV onboarding
  • new_dso_rules_contract_id: Updated DSO rules contract

​
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.
ONBOARDING_TYPETEXTType of onboarding: ‘validator’ for regular validators or ‘super_validator’ for super validators.
VALIDATOR_PARTYTEXTParty identifier for a validator.
VALIDATOR_NAMETEXTHuman-readable name for a validator.
SV_PARTYTEXTParty identifier specifically for a super validator.
SV_ONBOARDING_CONFIRMEDTEXTContract ID confirming super validator onboarding.
NEW_DSO_RULES_CONTRACT_IDTEXTContract ID for updated DSO rules after a governance action.
CONTRACT_IDTEXTUnique identifier for the contract being created or exercised in this event.
FACT_VALIDATOR_ONBOARDING_EVENT_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).