Table Details
| Property | Value |
|---|---|
| Table Name | stellar.raw.operations |
| Table Status | Production-Ready |
| Unique Key | ledger_close_time, operation_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | ledger_sequence, transaction_hash, operation_id, source_account, type |
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 |
|---|---|---|
| source_account | VARCHAR(16777216) | The account that submitted the operation |
| source_account_muxed | VARCHAR(16777216) | The muxed account address (if applicable) |
| source_account_muxed_id | VARCHAR(16777216) | The muxed ID of the source account |
| operation_id | VARCHAR(16777216) | The unique identifier for this operation |
| type | VARCHAR(16777216) | The type of operation (e.g., payment, create_account, etc.) |
| type_id | NUMBER(38,0) | The numeric ID of the operation type |
| ledger_sequence | NUMBER(38,0) | The sequence number of the ledger containing this operation |
| ledger_close_time | TIMESTAMP_NTZ(9) | The close time of the ledger containing this operation |
| ledger_hash | VARCHAR(16777216) | The hash of the ledger containing this operation |
| transaction_hash | VARCHAR(16777216) | The hash of the transaction containing this operation |
| transaction_index | NUMBER(38,0) | The index of the transaction within the ledger |
| transaction_result | VARCHAR(16777216) | The result code of the transaction containing this operation |
| transaction_successful | BOOLEAN | Whether the transaction containing this operation was successful |
| operation_index | NUMBER(38,0) | The index of this operation within the transaction |
| operation_details | VARIANT | Detailed information about the operation in JSON format |
| _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 |