Decoded
Decoded Traces
Decoded
Decoded Traces
The decoded traces table contains decoded trace inputs and outputs based the trace selector and contract ABIs.
Table Columns
Unique Key: trace_id
| Column Name | Data Type | Description | Example |
|---|---|---|---|
| name | VARCHAR | Decoded trace call name. | transfer |
| input_params | VARIANT | Decoded input data in JSON format. | { "dst": "0x7a250d5630b4cf539739df2c5dacb4c659f2488d", "wad": "78435934549592564" } |
| output_params | VARIANT | Decoded output data in JSON format. | { "arg": "True" } |
| transaction_hash | VARCHAR | Unique identifier of the transaction that contains this trace. | 0x1082e21d7a815d737447d984c9a7d10945263934b53b362a036e3812372b07ee |
| transaction_index | BIGINT | The position of this transaction in the block that it belongs to. The first transaction has index 0. | 0 |
| from_address | VARCHAR | The address of the sending party of this trace. | 0x43d6722b48b40d095e20f8ce7dd90e38f7dede47 |
| to_address | VARCHAR | The address of the receiving party of this trace (null for contract creation). | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 |
| value | VARCHAR* | The amount of ether moved from the from_address to to_address. | 0 |
| input | VARCHAR | The bytecode of the call that is made to another smart contract. | 0xa9059cbb0000000000000000000000007a250d5630b4cf539739df2c5dacb4c659f2488d0000000000000000000000000000000000000000000000000116a911207449f4 |
| output | VARCHAR | The bytecode answer the smart contract that was called gives back. | 0x0000000000000000000000000000000000000000000000000000000000000001 |
| trace_type | VARCHAR | The value of the method such as call, create, create2, suicide. | call |
| call_type | VARCHAR | The type of method such as call, delegatecall, staticcall. Learn more here. | call |
| reward_type | VARCHAR | Populated when trace_type = reward. Possible values: block, uncle | |
| gas | BIGINT | Gas provided with the trace call, in wei. | 151133 |
| gas_used | BIGINT | The amount of gas consumed, in wei. | 29962 |
| subtraces | BIGINT | Number of children traces. | 0 |
| trace_address | VARCHAR | The address of the trace within the call graph. More detail to come soon. | 3,0 |
| error | VARCHAR | Human readable developer error message. Examples: “Out of gas”, “Reverted”, etc. | |
| status | BIGINT | Success status of the trace. Either 1 (success) or 0 (failure). | 1 |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this log was included on the blockchain. | 2023-04-03 22:01:59.000 |
| block_number | BIGINT | The length of the chain, in blocks. | 16971316 |
| block_hash | VARCHAR | Unique identifier of the block that includes this log. | 0xa21af1110bb2aab30679c39bd2cfa84a19ec39e43edcc4114a5e41ccfcd34ba3 |
| trace_id | VARCHAR | Unique identifier for this trace. Generated by combining trace_type, transaction_hash and trace_address. | call_0x1082e21d7a815d737447d984c9a7d10945263934b53b362a036e3812372b07ee_3_0 |
| selector | VARCHAR | Selector of the txn. | 0xa9059cbb |
| input_params_keys_mapping | ARRAY | Input parameters mapping. | [ “dst”, “wad” ] |
| output_params_keys_mapping | ARRAY | Output parameters mapping. | [ “arg” ] |
| interface_id | VARCHAR | Interface ID. | 76c51e4145c1160d3ab0018a65355f06 |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. | 2024-02-26 22:14:24.402 |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. | 2024-02-26 22:14:24.402 |