Skip to main content

Table Details

PropertyValue
Table Nameethereum_sepolia.decoded.traces
Table StatusProduction-Ready
Unique Keyblock_timestamp::date, trace_id
Clustering Key(s)to_date("block_timestamp")
Search Optimizationtransaction_hash, from_address, to_address, selector

Table Columns

Column NameData TypeDescription
nameVARCHAR(16777216)Decoded trace call name.
input_paramsVARIANTDecoded input data in JSON format.
output_paramsVARIANTDecoded output data in JSON format.
transaction_hashVARCHAR(66)Unique identifier of the transaction that contains this trace.
transaction_indexNUMBER(38,0)The position of this transaction in the block that it belongs to. The first transaction has index 0.
from_addressVARCHAR(42)The address of the sending party of this trace.
to_addressVARCHAR(42)The address of the receiving party of this trace (null for contract creation).
valueVARCHAR(16777216)The amount of ether moved from the from_address to to_address.
inputVARCHAR(16777216)The bytecode of the call that is made to another smart contract.
outputVARCHAR(16777216)The bytecode answer the smart contract that was called gives back.
trace_typeVARCHAR(16)The value of the method such as call, create, create2, suicide.
call_typeVARCHAR(16)The type of method such as call, delegatecall, staticcall. Learn more here.
reward_typeVARCHAR(16)Populated when trace_type = reward. Possible values: block, uncle
gasNUMBER(38,0)Gas provided with the trace call, in wei.
gas_usedNUMBER(38,0)The amount of gas consumed, in wei.
subtracesNUMBER(38,0)Number of children traces.
trace_addressVARCHAR(8192)The address of the trace within the call graph. More detail to come soon.
errorVARCHAR(16777216)Human readable developer error message. Examples: “Out of gas”, “Reverted”, etc.
statusNUMBER(38,0)Success status of the trace. Either 1 (success) or 0 (failure).
block_timestampTIMESTAMP_NTZ(9)The time when the block that contains this log was included on the blockchain.
block_numberNUMBER(38,0)The length of the chain, in blocks.
block_hashVARCHAR(66)Unique identifier of the block that includes this log.
trace_idVARCHAR(16777216)Unique identifier for this trace. Generated by combining trace_type, transaction_hash and trace_address.
selectorVARCHAR(10)Selector of the txn.
input_params_keys_mappingARRAYInput parameters mapping.
output_params_keys_mappingARRAYOutput parameters mapping.
interface_idVARCHAR(16777216)Interface ID.
_created_atTIMESTAMP_NTZ(9)Timestamp of the entry creation.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the entry update.