> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Traces

### Table Details

| Property            | Value                                                                                              |
| ------------------- | -------------------------------------------------------------------------------------------------- |
| Table Name          | `celo.decoded.traces`                                                                              |
| Table Status        | Production-Ready                                                                                   |
| Unique Key          | `block_timestamp::date`, `trace_id`                                                                |
| Clustering Key(s)   | `to_date("block_timestamp")`                                                                       |
| Search Optimization | `trace_id`, `transaction_hash`, `from_address`, `to_address`, `block_number`, `selector`, `status` |

### Table Columns

| Column Name                   | Data Type         | Description                                                                                                 |
| ----------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------------- |
| name                          | VARCHAR(16777216) | Decoded trace call name.                                                                                    |
| input\_params                 | VARIANT           | Decoded input data in JSON format.                                                                          |
| output\_params                | VARIANT           | Decoded output data in JSON format.                                                                         |
| transaction\_hash             | VARCHAR(66)       | Unique identifier of the transaction that contains this trace.                                              |
| 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 trace.                                                             |
| to\_address                   | VARCHAR(42)       | The address of the receiving party of this trace (null for contract creation).                              |
| value                         | VARCHAR(16777216) | The amount of ether 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. More detail to come soon.                                   |
| error                         | VARCHAR(16777216) | Human readable developer error message. Examples: "Out of gas", "Reverted", etc.                            |
| 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 log 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 log.                                                      |
| trace\_id                     | VARCHAR(16777216) | Unique identifier for this trace. Generated by combining trace\_type, transaction\_hash and trace\_address. |
| selector                      | VARCHAR(10)       | Selector of the txn.                                                                                        |
| input\_params\_keys\_mapping  | ARRAY             | Input parameters mapping.                                                                                   |
| output\_params\_keys\_mapping | ARRAY             | Output parameters mapping.                                                                                  |
| interface\_id                 | VARCHAR(16777216) | Interface ID.                                                                                               |
| \_created\_at                 | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                                                            |
| \_updated\_at                 | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                                                              |

### Related Docs

* [EVM Decoded Traces](/historical-data/supported-blockchains/evm/core-schemas/decoded/traces)