decoded.contracts table contains metadata and ABI information for decoded smart contracts on EVM-compatible blockchains.
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(16777216) | The contract address on the blockchain. |
| name | VARCHAR(16777216) | The name of the contract. |
| abi | VARCHAR(16777216) | The Application Binary Interface (ABI) of the contract in JSON format. |
| abi_source | VARCHAR(6) | The source of the ABI information (e.g., public, verified). |
| code | VARCHAR(2) | The bytecode of the contract. |
| source_code | VARCHAR(2) | The source code of the contract, if available. |
| metadata_json | VARCHAR(16777216) | Additional metadata about the contract in JSON format. |
| _updated_at__implementation_address | VARCHAR(16777216) | Timestamp when the implementation address was last updated (for proxy contracts). |
| implementation_address | VARCHAR(16777216) | The address of the implementation contract (for proxy contracts). |
| standard | VARCHAR(16777216) | The token standard implemented by the contract (e.g., ERC-20, ERC-721, ERC-1155). |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |