Table Description

The avalanche_c.traces table contains the traces of the transactions executed on the Ethereum Virtual Machine (EVM). It includes the traces of the transaction and the traces of the internal transactions. Traces are the result of the execution of the transaction and are used to debug and understand the execution of the transaction. They are also known as `internal transactions` and can be used to understand the execution of a transaction.

This is the raw version of this table. If the chain is a Fully Managed chain, decoded transaction calls will be available, see call tables section. If this is a Hosted chain, decoded call tables will not be available.

Column Descriptions

Datatypes on Snowflake datashare are different in some cases, read more here.

Table Sample

Example

Querying traces for a specific transaction hash

SELECT *
FROM avalanche_c.traces
WHERE tx_hash = 0xb30d6d67cf7d148c2257bf598c5f5cdf5912a3d05c7d3b000398d675d2fa912c