Skip to main content

Table Details

PropertyValue
Table Nameethereal.raw.contracts
Table StatusProduction-Ready
Unique Keyblock_number, address, trace_id
Clustering Key(s)to_date("block_timestamp")
Search Optimizationaddress

Table Columns

Column NameData TypeDescription
addressVARCHAR(42)Contract address.
bytecodeVARCHAR(16777216)The bytecode data of this contract.
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block that this contract was created in.
block_numberNUMBER(38,0)The number of the block that this contract was created in.
block_hashVARCHAR(66)The hash of the block that this contract was created in.
transaction_hashVARCHAR(66)The transaction hash of the block that this contract was created in.
deployerVARCHAR(42)Address of the contract deployer.
trace_idVARCHAR(16777216)Unique identifier for this contract creation trace. Generated by combining the trace_type, transaction_hash, and trace_address in trace data.
found_signature_hashesARRAYSignature hashes identified in the deployed contract. In an array format.
_created_atTIMESTAMP_NTZ(9)Timestamp of the entry creation.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the entry update.