| transaction_hash | VARCHAR(66) | Unique identifier of the transaction that this trace belongs to. |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| from_address | VARCHAR(42) | The address of the sending party of this transaction. |
| to_address | VARCHAR(42) | The address of the receiving party of this transaction, typically a contract address for traces. |
| value | NUMBER(38,0) | The amount of gas token moved from the from_address to to_address. |
| input | VARCHAR(16777216) | The bytecode of the call that is made to another smart contract. |
| output | VARCHAR(16777216) | The bytecode answer the smart contract that was called gives back. |
| trace_type | VARCHAR(16) | The value of the method such as call, create, create2, suicide. |
| call_type | VARCHAR(16) | The type of method such as call, delegatecall, staticcall. Learn more here. |
| reward_type | VARCHAR(16) | Populated when trace_type=reward. Possible values: block, uncle. |
| gas | NUMBER(38,0) | Gas provided with the trace call, in wei. |
| gas_used | NUMBER(38,0) | The amount of gas consumed, in wei. |
| subtraces | NUMBER(38,0) | Number of children traces. |
| trace_address | VARCHAR(8192) | The address of the trace within the call graph. |
| error | VARCHAR(16777216) | Human-readable developer error message. Examples: “Out of gas”, “Reverted”, “Bad instruction”, “Bad jump destination”. |
| status | NUMBER(38,0) | Success status of the trace. Either 1 (success) or 0 (failure). |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this trace was included on the blockchain. |
| block_number | NUMBER(38,0) | The length of the chain, in blocks. |
| block_hash | VARCHAR(66) | Unique identifier of the block that includes this trace. |
| trace_id | VARCHAR(16777216) | Unique identifier for this trace. Generated by combining the trace_type, transaction_hash, and trace_address. |
| selector | VARCHAR(10) | 4-bytes of the input data. |
| before_evm_transfers | VARIANT | EVM transfers state before the trace execution. (Only applicable for Arbitrum Orbit Chains) |
| after_evm_transfers | VARIANT | EVM transfers state after the trace execution. (Only applicable for Arbitrum Orbit Chains) |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
