Table Details
| Property | Value |
|---|---|
| Table Name | stellar.raw.diagnostic_events |
| Table Status | Beta 🌱 |
| Unique Key | ledger_close_time, unique_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | ledger_sequence, transaction_hash, contract_id |
Important: Stellar’s raw and assets datasets are migrating from the Horizon API to the Stellar RPC. The Stellar-RPC-sourced (
v2) tables are available now, switch your queries to the v2 datasets. See Deprecated Stellar v1 for more information.Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| contract_id | VARCHAR(16777216) | The ID of the smart contract that generated this diagnostic event |
| topics | VARIANT | Array of topics associated with this diagnostic event |
| data | VARIANT | The diagnostic event data in hexadecimal format |
| event_type | VARCHAR(16777216) | The type of diagnostic event |
| in_successful_contract_call | BOOLEAN | Whether this diagnostic event was generated during a successful contract call |
| event_index | NUMBER(38,0) | The index of this diagnostic event within the transaction |
| transaction_details | VARIANT | Additional transaction details in JSON format |
| extension | VARCHAR(16777216) | Extension data for the diagnostic event |
| ledger_sequence | NUMBER(38,0) | The sequence number of the ledger containing this diagnostic event |
| ledger_close_time | TIMESTAMP_NTZ(9) | The close time of the ledger containing this diagnostic event |
| ledger_hash | VARCHAR(16777216) | The hash of the ledger containing this diagnostic event |
| transaction_hash | VARCHAR(16777216) | The hash of the transaction that generated this diagnostic event |
| transaction_index | NUMBER(38,0) | The index of the transaction within the ledger |
| transaction_result | VARCHAR(16777216) | The result code of the transaction that generated this diagnostic event |
| transaction_successful | BOOLEAN | Whether the transaction that generated this diagnostic event was successful |
| unique_id | VARCHAR(16777216) | A unique identifier for this diagnostic event |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |
| transaction_events | VARIANT | Array of token-transfer and SEP-41 events emitted in the transaction |