cosmos.core Table: fact_msg_attributes Type: View
Records of all message attributes associated to messages that have occurred on Cosmos from chain
version 4 and beyond. (This info may be available in the msgs column in core.fact_transactions, but
we are not parsing it out at this time.)
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_ID | TEXT | A unique key that identifies a transaction. Called “TxHash” on block explorers. |
| TX_SUCCEEDED | BOOLEAN | Transaction status is “TRUE” if the transaction went through, “FALSE” if the transaction failed. |
| MSG_GROUP | TEXT | Value grouping different messages together to represent a single action. Format will include the numeric msg_group and msg_sub_group with a ”:” seperator. The subgroup will always be 0 except for “Exec” actions. NULL group means messages are related to the header (overall transaction) |
| MSG_INDEX | NUMBER | Short for “message index,” the position in which messages occur in a transaction. |
| MSG_TYPE | TEXT | A string containing information about the type of message occurring. |
| ATTRIBUTE_INDEX | NUMBER | The position in which attributes occur within a message |
| ATTRIBUTE_KEY | TEXT | The key from the key-value pair from the message attribute |
| ATTRIBUTE_VALUE | TEXT | The value from the key-value pair from the message attribute |
| UNIQUE_KEY | TEXT | The unique key for the table. |
| FACT_MSG_ATTRIBUTES_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. |