deprecated
Schema Update for Ethereum Mainnet Tables and APIs: Essential Changes and Actions for Users
7 months ago by Ruimin Shi
Following the schema update of Ethereum data lake tables, ZettaBlock is carrying out the same update on Ethereum tables in realtime database.
The schema update will be performed in a 2-hour maintenance window on Tuesday, March 5 (10am-12pm PST / 1-3 pm EST), during which, user APIs will be migrated to fit the new schema.
Users’ saved queries might not work after the schema update. Please check your saved queries and update them accordingly.
What to expect
- The schema of Ethereum tables in realtime database will be updated to match that of data lake tables.
- The data models of Ethereum Realtime API will be updated to reflect the schema changes as well.
- Tables impacted:
ethereum_mainnet.blocks
ethereum_mainnet.logs
ethereum_mainnet.traces
ethereum_mainnet.transactions
ethereum_mainnet.erc20_evt_transfer
ethereum_mainnet.erc721_evt_transfer
ethereum_mainnet.erc1155_evt_transfer_batch
ethereum_mainnet.erc1155_evt_transfer_single
ethereum_mainnet.contract_creations
ethereum_mainnet.eth_transfers
(to be renamed asethereum_mainnet.native_token_transfers
)
- Ethereum Realtime API models impacted:
- Block
- Transaction
- Log
- Trace
- EthTransfer
- ERC20EvtTranfer
- ERC721EvtTranfer
- ERC1155EvtTranferSingle
- ERC1155EvtTranferBatch
Summary of changes
-
Table renaming:
- Table
eth_transfers
is renamed tonative_token_transfers
- Table
-
Column changes:
- Partition column is renamed from
**data_creation_date**
to**block_date**
- Columns of type
**decimal(p,s)**
are unified to**decimal(38,0)**
- ERC token metadata columns are removed from realtime table / Realtime API model
erc20_evt_transfer
,erc721_evt_transfer
,erc1155_evt_transfer_batch
, anderc1155_evt_transfer_single
. As a substitute, we recommend users to use table**erc20_tokens**
and**nft_tokens**
tables to get token metadata.
- Partition column is renamed from
If you have any questions or troubles that occur during this migration, please let us know in our Discord server.