external.avalanche Table: fact_x_transactions Type: View
What
Avalanche X-Chain Transactions. Please visit https://discord.gg/avax for any questions.Columns
| Column Name | Data Type | Description |
|---|---|---|
| TRANSACTION_HASH | TEXT | Unique identifier for the transaction |
| TIMESTAMP | TIMESTAMP_NTZ | Timestamp when the transaction was processed |
| TYPE | TEXT | Type of transaction (e.g. import, export, operation) |
| BLOCK_HASH | TEXT | Hash of the block containing the transaction |
| BLOCK_INDEX | NUMBER | Index of the block in which the transaction occured |
| BLOCK_HEIGHT | NUMBER | Height of the block in the blockchain |
| MEMO | TEXT | Optional memo associated with the transaction |
| FEE | NUMBER | Transaction fee in smallest denomination |
| ASSET_NAME | TEXT | Name of the asset involved in the transaction |
| SYMBOL | TEXT | Symbol of the asset |
| DENOMINATION | NUMBER | Denomination of the asset (10^denomination) |
| SOURCE_CHAIN | TEXT | Source chain for cross-chain transactions |
| DESTINATION_CHAIN | TEXT | Destination chain for cross-chain transactions |
| METADATA | TEXT | METADATA column |
| BYTES | BINARY | BYTES column |
| LAST_UPDATED | TIMESTAMP_NTZ | Last update timestamp |
| LOAD_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when data was loaded into Snowflake |
| IS_LINEAR | BOOLEAN | IS_LINEAR column |
| TX_BLOCK_POSITION | NUMBER | Position of the transaction in the block |