Skip to main content
Schema: crosschain.cosmos Table: fact_transactions Type: View

What

Records of transactions that have occurred on Axelar, Cosmos, and Osmosis.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTThe name of the blockchain
BLOCK_IDNUMBERThe block height the block was recorded at.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block began.
TX_IDTEXTA unique key that identifies a transaction. Called “TxHash” on block explorers.
TX_FROMTEXTThe wallet address of the individual who initiated the transaction
CODESPACEVARIANTNamespace for the code.
FEETEXTThe fee is paid by the initiator of the transaction. Fee = gas * gas price.
FEE_DENOMTEXTThe denominator of the transaction fee.
GAS_USEDNUMBERThe amount of gas consumed by the transaction.
GAS_WANTEDNUMBERAmount of gas requested for a transaction. It is provided by users when the transaction is generated.
TX_CODENUMBERA number that corresponds to various error codes. When “0”, the transaction is successful. Non-zero numbers signify different types of transaction failures.
TX_LOGTEXTA string that contains the transaction logs, which are logs written by the program interacted with during the transaction.
MSGSVARIANTThe underlying json from the messages or events within the transactions
TX_SUCCEEDEDBOOLEANTransaction status is “TRUE” if the transaction was successful, “FALSE” if the transaction failed.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
FACT_TRANSACTIONS_IDTEXTThe unique identifier for each row in the table.