Overview
This schema contains 10 tables and views for Sui data. Data Coverage Note: Most core tables have full historical coverage from April 2023. However, FACT_BALANCE_CHANGES, FACT_CHANGES, FACT_TRANSACTION_INPUTS, and EZ_TRANSFERS contain data starting from January 2025, as they rely on the balance changes object from the RPC response.Tables and Views
Dim Labels
The labels table is a store of one-to-one address identifiers, or an address name.
Dim Tokens
Dimension table providing authoritative metadata for all fungible and non-fungible tokens on the
Sui blockchain.
Ez Transfers
Enhanced fact table providing user-friendly transfer analytics by joining core transfer data
with token metadata.
Fact Balance Changes
Fact table recording every token and coin balance change event on the Sui blockchain at the
finest granularity.
Fact Changes
Fact table capturing all object state transitions on the Sui blockchain, including creation,
mutation, deletion, wrapping, and unwrapping of objects.
Fact Checkpoints
Fact table representing all finalized checkpoints on the Sui blockchain, which serve as
consensus points bundling multiple transactions for finalit…
Fact Events
Fact table logging all events emitted by Move smart contracts and system operations during
transaction execution on Sui.
Fact Transaction Blocks
Fact table providing detailed metadata for every transaction block executed on the Sui
blockchain.
Fact Transaction Inputs
Fact table enumerating all inputs consumed by transactions on the Sui blockchain, including
owned objects, shared objects, pure values, and input t…
Fact Transactions
Fact table decomposing every transaction on the Sui blockchain into its constituent commands and
payloads.