Table Details
| Property | Value |
|---|---|
| Table Name | stellar.raw.effects |
| Table Status | Production-Ready |
| Unique Key | ledger_close_time, unique_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | ledger_sequence, transaction_hash, operation_id, 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 |
|---|---|---|
| account | VARCHAR(16777216) | The account that was affected by this effect |
| account_muxed | VARCHAR(16777216) | The muxed account address (if applicable) |
| account_muxed_id | VARCHAR(16777216) | The muxed ID of the affected account |
| operation_id | VARCHAR(16777216) | The ID of the operation that caused this effect |
| type | VARCHAR(16777216) | The type of effect (e.g., account_created, payment_sent, etc.) |
| type_id | NUMBER(38,0) | The numeric ID of the effect type |
| ledger_sequence | NUMBER(38,0) | The sequence number of the ledger containing this effect |
| ledger_close_time | TIMESTAMP_NTZ(9) | The close time of the ledger containing this effect |
| ledger_hash | VARCHAR(16777216) | The hash of the ledger containing this effect |
| transaction_hash | VARCHAR(16777216) | The hash of the transaction that caused this effect |
| transaction_index | NUMBER(38,0) | The index of the transaction within the ledger |
| transaction_result | VARCHAR(16777216) | The result code of the transaction that caused this effect |
| operation_index | NUMBER(38,0) | The index of the operation within the transaction |
| effect_index | NUMBER(38,0) | The index of this effect within the operation |
| unique_id | VARCHAR(16777216) | A unique identifier for this effect |
| effect_details | VARIANT | Detailed information about the effect 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 |
| _extra_fields | VARIANT | Additional fields not explicitly defined |
| transaction_events | VARIANT | Array of token-transfer and SEP-41 events emitted in the transaction |