Skip to main content
All events, starting from genesis.

Table Details

PropertyValue
Table Namebabylon.raw.events
Table StatusProduction-Ready
Unique Keyblock_timestamp, transaction_hash, event_index
Clustering Key(s)to_date("block_timestamp")
Search Optimizationblock_height, transaction_hash

Table Columns

Column NameData TypeDescription
block_heightNUMBER(38,0)The sequential number of the block in the blockchain.
block_timestampTIMESTAMP_NTZ(9)The timestamp when the block was created.
block_hashVARCHAR(16777216)The hash of the block containing the transaction.
transaction_hashVARCHAR(16777216)The hash of the transaction.
transaction_indexNUMBER(38,0)The index of the transaction within the block.
message_indexNUMBER(38,0)The index of the message within the transaction.
message_actionVARCHAR(16777216)The action performed by the message.
event_indexNUMBER(38,0)The index of the event within the transaction.
typeVARCHAR(16777216)The type of event (e.g., coin_received).
event_attribute_countNUMBER(38,0)The number of attributes associated with the event.
_created_atTIMESTAMP_NTZ(9)The timestamp when the event was recorded in the table.
_updated_atTIMESTAMP_NTZ(9)The timestamp when the event data was last updated.