| BLOCK_NUMBER | NUMBER | Also known as block height. The block number indicates the position of a block in the blockchain, increasing sequentially after the addition of each new block. Data type: Integer Example: 12345678 98765432 Business Context: Primary identifier for ordering and filtering blockchain data chronologically. Essential for block-level analysis and network growth tracking. Enables correlation of transactions, transfers, and events to specific blocks. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced on the Aptos blockchain. Data type: Timestamp Example: 2024-01-15 14:30:25.123456 Business Context: Primary field for time-series analysis and temporal filtering of blockchain activity. Essential for trend analysis, volume calculations, and historical comparisons. Enables time-based grouping and aggregation for analytics and reporting. |
| VERSION | NUMBER | The version number, also known as the height, represents the sequential position of a transaction in the Aptos blockchain. The first transaction has a version of 0, and each subsequent transaction increments by 1. Data type: Integer Example: 0 (genesis transaction) 12345678 98765432 Business Context: Unique identifier for ordering transactions chronologically across the entire blockchain. Essential for transaction sequencing and version-based analysis. Enables precise transaction tracking and… |
| TX_HASH | TEXT | Transaction hash is a unique 66-character identifier that is generated when a transaction is executed on the Aptos blockchain. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Primary identifier for linking transaction data across all related tables. Essential for transaction verification and blockchain explorer lookups. Enables correlation of transfers, events, and state changes to specific transactions. |
| PLATFORM | TEXT | The platform or protocol from which the bridge transaction or event originates. Data type: String Example: LayerZero Wormhole Stargate Business Context: Used for identifying and analyzing bridge protocol usage. Enables platform-level analytics, volume tracking, and protocol comparisons. Supports bridge ecosystem analysis and user behavior insights. |
| BRIDGE_ADDRESS | TEXT | The address of the contract responsible for handling the bridge deposit or transfer. This contract mediates the transfer and ensures that assets are sent and received appropriately. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Used for identifying bridge contracts and their deployment locations. Enables contract-level analytics, security analysis, and bridge protocol tracking. Supports bridge ecosystem monitoring and contract… |
| EVENT_NAME | TEXT | The third segment of the event type, representing the specific resource or event name. Data type: String Example: DepositEvent WithdrawEvent TransferEvent Business Context: Essential for identifying the specific event type and resource. Critical for event categorization and specific event analysis. Enables resource-specific analytics and event type correlation. |
| DIRECTION | TEXT | DIRECTION column |
| TX_SENDER | TEXT | The address of the originator account that initiated and signed the transaction on the Aptos blockchain. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Essential for user behavior analysis and wallet activity tracking. Critical for transaction attribution and sender-based analytics. Enables correlation with address labels for enhanced user profiling. |
| SENDER | TEXT | The address that initiated the bridge deposit or transfer. This address is the sender of the tokens/assets being bridged to the destination chain. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Used for tracking bridge users and their cross-chain activity. Enables user-level analytics, bridge usage patterns, and sender behavior analysis. Supports linking to address labels and user profiles. |
| RECEIVER | TEXT | The designated address set to receive the bridged tokens on the target chain after the completion of the bridge transaction. For non-evm chains, the hex address is decoded/encoded to match the data format of the destination chain, where possible. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Used for tracking bridge recipients and cross-chain asset flows. Enables user-level analytics, bridge destination patterns, and receiver b… |
| SOURCE_CHAIN_ID | NUMBER | The numeric identifier associated with the source blockchain network. This is specific to the chain and helps in uniquely identifying it. Data type: Integer Example: 1 (Ethereum Mainnet) 137 (Polygon) 42161 (Arbitrum One) Business Context: Used for programmatic chain identification and filtering. Enables automated chain-level analytics and cross-chain data processing. Supports bridge protocol integration and chain-specific logic. |
| SOURCE_CHAIN_NAME | TEXT | The name of the blockchain network from which the assets are being bridged. Data type: String Example: Ethereum Polygon Arbitrum Optimism Business Context: Used for analyzing cross-chain asset flows and source chain preferences. Enables chain-level analytics, volume tracking, and cross-chain comparisons. Supports bridge ecosystem analysis and user behavior insights. |
| DESTINATION_CHAIN_ID | NUMBER | The numeric identifier associated with the destination blockchain network. This is specific to the chain and helps in uniquely identifying it. Data type: Integer Example: 1 (Ethereum Mainnet) 137 (Polygon) 42161 (Arbitrum One) Business Context: Used for programmatic chain identification and filtering. Enables automated chain-level analytics and cross-chain data processing. Supports bridge protocol integration and chain-specific logic. |
| DESTINATION_CHAIN_NAME | TEXT | The name of the blockchain network to which the assets are being bridged. Data type: String Example: Ethereum Polygon Arbitrum Optimism Business Context: Used for analyzing cross-chain asset flows and destination preferences. Enables chain-level analytics, volume tracking, and cross-chain comparisons. Supports bridge ecosystem analysis and user behavior insights. |
| TOKEN_ADDRESS | TEXT | The address associated with the token that is being bridged. It provides a unique identifier for the token within its origin blockchain. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Used for identifying bridged tokens and their cross-chain flows. Enables token-level analytics, volume tracking, and cross-chain token analysis. Supports bridge ecosystem monitoring and token flow visualization. |
| AMOUNT_UNADJ | NUMBER | The non-decimal adjusted amount of a token, representing the raw on-chain value before decimal precision is applied. Data type: Decimal Example: 1500000000000000000 (for 1.5 tokens with 18 decimals) 1000000000000000000000 (for 1000 tokens with 18 decimals) Business Context: Preserves the exact on-chain representation for precise calculations and verification. Essential for blockchain-level accuracy and cross-reference with external data sources. Used when decimal precision needs to be maintai… |
| EVENT_INDEX | NUMBER | EVENT_INDEX column |
| FACT_BRIDGE_ACTIVITY_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. |
| _INVOCATION_ID | TEXT | _INVOCATION_ID column |
