external.layerzero Table: fact_transactions_snapshot Type: View
What
This table records transactions data provided by LayerZero in their Sybil Reporting effort. You may refer to this github link for more information - https://github.com/LayerZero-Labs/sybil-report/?tab=readme-ov-file . Please reach out to the LayerZero team for any data discrepancies or questions.Columns
| Column Name | Data Type | Description |
|---|---|---|
| SOURCE_CHAIN | TEXT | The chain where the transaction originated from. |
| SOURCE_TRANSACTION_HASH | TEXT | The transaction hash from the source chain. |
| SOURCE_CONTRACT | TEXT | The contract address from the source transaction. |
| DESTINATION_CHAIN | TEXT | The chain where the transaction is directed to. |
| DESTINATION_TRANSACTION_HASH | TEXT | The transaction hash on the destination chain. |
| DESTINATION_CONTRACT | TEXT | The contract address from the destination transaction. |
| SENDER_WALLET | TEXT | The wallet address that initiated the source transaction hash. |
| SOURCE_TIMESTAMP_UTC | TIMESTAMP_NTZ | The timestamp of the source transaction hash in UTC. |
| PROJECT | TEXT | The name of the project. |
| NATIVE_DROP_USD | TEXT | The native drop in USD. |
| STARGATE_SWAP_USD | TEXT | The stargate swap in USD. |
| SNAPSHOT_VERSION | TEXT | The version number of the snapshot taken. |
| LAYERZERO_TXS_SNAPSHOT_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. |