Overview
This schema contains 15 tables and views for Canton data.Tables and Views
Dim Labels
Dimension table containing address labels and metadata for Canton blockchain.
Ez Amulet Lock Lifecycle
Comprehensive EZ view showing the complete lifecycle of locked amulets from initial lock through unlock or expiration.
Ez Cex Flows
Centralized exchange (CEX) deposit, withdrawal, and internal transfer flows for Canton.
Ez Token Transfers
Analytics-ready token transfers with price enrichment for Canton blockchain.
Fact Amulet Locks
Tracks when amulets are locked/staked by creating LockedAmulet contracts.
Fact Amulet Unlocks
Tracks unlocking/unstaking of locked amulets through exercise events.
Fact App Reward Coupons
Tracks the creation of app reward coupons for application providers.
Fact App Rewards
Tracks app reward coupon expirations when the DSO expires app reward coupons.
Fact Balance Changes
Tracks balance changes for parties resulting from transfer operations.
Fact Events
Core fact table exposing all Canton events from the blockchain with pre-extracted fields for easy analysis.
Fact Round Closes
Tracks SummarizingMiningRound contract creation events, representing when mining rounds close and summarize their results.
Fact Round Opens
Tracks IssuingMiningRound contract creation events, representing when new mining rounds are opened and become active.
Fact Transfer Summary
Event-level summary table for AmuletRules_Transfer operations on the Canton network.
Fact Transfers
Fact table tracking individual outputs from AmuletRules_Transfer operations on the Canton network.
Fact Updates
Tracks Canton update-level information.