Changes Flipside users need to make: EVM Nomenclature tables

This year, Polygon is changing their gas token from MATIC to POL. In the event that any other EVM chain changes their gas token, and to ensure your queries don't break, we will be applying a standardized nomenclature structure to column names in three tables for all EVM chains (Arbitrum, Avalanche, Base, Ethereum, Gnosis, Optimism, Polygon, BSC).

There are three tables that are affected by this change:  

• ez_<asset>_transfers
• fact_transactions
• fact_traces

The changes you must make for those tables are outlined below. The old names are in italics, the new names are bolded.

_____________

Table 1: ez_<asset>_transfers table

Change table name: ez_<asset>_transfers table --> ez_native_transfers

Change column name: <asset>_from_address --> from_address

Change column name: <asset>_to address --> to_address

Table 2: fact_transactions

Change column name: <asset>_value --> value

Change column name: <asset>_value_precise_raw --> value_precise_raw

Change column name: <asset>_value_precise --> value_precise

Table 3: fact_traces

Change column name: <asset>_value --> value  

Change column name: <asset>_value_precise_raw --> value_precise_raw

Change column name: <asset>_value_precise --> value_precise

_____________

We appreciate that this can be a time-consuming process to update, but it is our top priority to ensure high data integrity. Making these systematic updates ensure our data is always accurate and easy for you to use.  

Please make all changes by January 31st. The old table names and columns will be deprecated on February 1.