Skip to main content
Schema: canton.core Table: dim_labels Type: Base Table

​
What

Dimension table containing address labels and metadata for Canton blockchain. This table provides human-readable names, project associations, and categorization for Canton addresses (party IDs), including validators, dApps, and other entities. Key Use Cases:
  • Enriching transfer and balance tables with readable address names
  • Identifying validator addresses and their associated entities
  • Categorizing addresses by project, type, and subtype
  • Filtering for specific entity types (e.g., validators, DSO members)
Important Relationships:
  • Join to any table with party IDs/addresses using the address field
  • Common joins: core__fact_transfers, gov__fact_validator_onboarding_events
Commonly-used Fields:
  • address: Canton party ID for joining with transaction/event tables
  • label: Project name providing high-level identification
  • address_name: Specific name for the address/entity
  • label_type/label_subtype: Hierarchical categorization
Important Notes:
  • Deleted labels are automatically removed via post-hook
  • Incremental updates based on modified_timestamp
  • Search optimized for address lookups

​
Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBlockchain identifier (always ‘canton’ for this model)
CREATORTEXTEntity or system that created the label
ADDRESSTEXTCanton party ID/address being labeled
LABEL_TYPETEXTHigh-level category of the label (e.g., validator, dapp, dso_member)
LABEL_SUBTYPETEXTSubcategory providing more specific classification
LABELTEXTProject name providing primary identification for the address
ADDRESS_NAMETEXTHuman-readable name for the specific address
DIM_LABELS_IDTEXTUnique identifier for the label record
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the label was first created
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the label was last modified