Skip to main content
Schema: sui.core Table: dim_tokens Type: Base Table

​
Description

This table serves as the authoritative token metadata dimension for the Sui blockchain, combining information from on-chain coin metadata including decimals, symbols, names, descriptions, and icon URLs. It provides a canonical reference for token identification and decimal normalization across all Sui analytics.

​
Key Use Cases

  • Token identification and metadata lookups for analytics and reporting
  • Decimal normalization for converting raw token amounts to human-readable values
  • Token discovery and cataloging for DeFi protocols
  • Building token directories and reference data for applications
  • Supporting cross-token analysis and portfolio tracking

​
Important Relationships

  • Referenced by core.ez_transfers for token metadata enrichment
  • Referenced by defi.ez_dex_swaps for token symbol and decimal lookups
  • Referenced by defi.ez_bridge_activity for bridge token identification
  • Provides metadata for all token-based analytics across the Sui ecosystem

​
Commonly-used Fields

  • coin_type: Primary identifier for tokens (full Move type path)
  • symbol: User-friendly token symbol
  • decimals: Essential for converting raw amounts to decimal-adjusted values
  • name: Full token name for display purposes
  • icon_url: Token logo/icon for UI applications

​
Columns

Column NameData TypeDescription
COIN_TYPETEXTThe full Move type identifier for the coin/token on Sui blockchain.
Data type: String Example:
  • 0x2::sui::SUI
  • 0x5d4b302506645c37ff133b98c4b50a5ae14841659738d6d733d59d0d217a93bf::coin::COIN
Business Context:
  • Primary identifier for token lookups and joins across all tables.
  • Essential for token-specific analysis and filtering.
  • Enables correlation of token activity across transfers, swaps, and bridges. | | DECIMALS | NUMBER | The number of decimal places for the token, used to convert raw amounts to human-readable values.
Data type: Integer Example:
  • 9 (SUI has 9 decimals)
  • 6 (USDC typically has 6 decimals)
  • 18 (common for many ERC20-style tokens)
Business Context:
  • Critical for converting raw on-chain amounts to decimal-adjusted values.
  • Essential for financial calculations and value comparisons.
  • Enables accurate token amount normalization across analytics. | | SYMBOL | TEXT | The token symbol, providing a short, human-readable identifier.
Data type: String Example:
  • SUI
  • USDC
  • CETUS
Business Context:
  • Used for user-friendly displays, reports, and dashboards.
  • Enables token filtering and grouping in analytics.
  • Supports cross-token comparisons and portfolio analysis. | | NAME | TEXT | The full name of the token.
Data type: String Example:
  • Sui
  • USD Coin
  • Cetus Protocol
Business Context:
  • Provides complete token identification for reports and documentation.
  • Used in token directories and reference materials.
  • Supports token discovery and cataloging. | | DESCRIPTION | TEXT | A description of the token, providing additional context about its purpose or features.
Data type: String Example:
  • The native token of the Sui blockchain
  • A stablecoin pegged to the US Dollar
Business Context:
  • Provides context for token research and analysis.
  • Used in token documentation and educational materials.
  • Supports token categorization and classification. | | ICON_URL | TEXT | URL to the token’s icon or logo image.
Data type: String Example: Business Context:
  • Essential for UI/UX in applications and dashboards.
  • Enables branded token displays and visualizations.
  • Supports user-friendly token identification. | | OBJECT_ID | TEXT | The on-chain object identifier for the coin metadata.
Data type: String Example:
  • 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
Business Context:
  • Links to on-chain metadata object for verification.
  • Enables blockchain explorer lookups and validation.
  • Supports metadata provenance and integrity checks. | | DIM_TOKENS_ID | TEXT | The unique primary key identifier for each row in the table, ensuring data integrity and uniqueness.
Data type: String Example:
  • 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef
Business Context:
  • Essential for data integrity and unique row identification.
  • Critical for join operations and data relationship management.
  • Enables precise data retrieval and referential integrity maintenance. | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was inserted into the table, representing when the data was first recorded.
Data type: Timestamp Example:
  • 2024-01-15 14:30:25.123456
Business Context:
  • Essential for data lineage tracking and insertion timing analysis.
  • Critical for understanding data freshness and processing delays.
  • Enables data quality analysis and processing performance monitoring. | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was last modified, representing when the data was most recently updated.
Data type: Timestamp Example:
  • 2024-01-15 14:30:25.123456
Business Context:
  • Essential for data freshness analysis and update tracking.
  • Critical for understanding data modification patterns and change frequency.
  • Enables data quality monitoring and update performance analysis. |