flow.core_evm Table: dim_labels Type: Base Table
Description
A dimensional table containing address labels and categorization data for EVM-compatible blockchains. This table serves as the foundation for address identification and categorization, providing human-readable names and labels for addresses including contracts, users, and protocols. The table supports address analysis, user identification, and ecosystem understanding across multiple EVM chains. Each record represents a labeled address with comprehensive categorization and metadata.Key Use Cases
- Address Identification: Providing human-readable names for blockchain addresses
- User Analysis: Identifying and categorizing user addresses and their activities
- Protocol Analysis: Understanding protocol addresses and their roles in the ecosystem
- Contract Categorization: Labeling and categorizing smart contract addresses
- Cross-Chain Labeling: Maintaining consistent labels across different EVM-compatible blockchains
- Ecosystem Mapping: Understanding the relationships and roles of different addresses
Important Relationships
- core_evm__fact_transactions: Links to transactions involving labeled addresses
- core_evm__fact_event_logs: Links to events involving labeled addresses
- core_evm__dim_contracts: Links to contract metadata for labeled contract addresses
- core_evm__ez_token_transfers: Links to token transfers involving labeled addresses
- core_evm__ez_native_transfers: Links to native transfers involving labeled addresses
- core__dim_labels: May provide comparison data with native Flow labels
Commonly-used Fields
- ADDRESS: Essential for address identification and cross-table joins
- ADDRESS_NAME: Critical for human-readable address identification
- LABEL_TYPE: Important for address categorization and filtering
- LABEL_SUBTYPE: Key for detailed address categorization and analysis
- LABEL: Essential for address labeling and user interface display
- BLOCKCHAIN: Critical for cross-chain analysis and chain-specific labeling
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | The name of the blockchain. |
| CREATOR | TEXT | The name of the creator of the label. |
| ADDRESS | TEXT | Address that the label is for. This is the field that should be used to join other tables with labels. |
| ADDRESS_NAME | TEXT | The most granular label for this address. |
| LABEL_TYPE | TEXT | A high-level category describing the address’s main function or ownership. |
| LABEL_SUBTYPE | TEXT | A sub-category nested within label type providing further detail. |
| LABEL | TEXT | The label for this address. |
| DIM_LABELS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp at which the row was last modified. |