Table Details
| Property | Value |
|---|---|
| Table Name | ethereum.ens.primary_records_latest |
| Table Status | Production-Ready |
| Unique Key | address |
| Search Optimization | address, name |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(42) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| name | VARCHAR(16777216) | Market display name. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |