Ethereum Data Warehouse: Transitioning from Beta to Better
We’re super excited to say that that Ethereum Data Warehouse (EDW) has graduated from beta phase and is now fully live – and ready to empower you with an even better data experience!
So what’s new?
Our focus has been on enhancing the usability of data and making queries simpler and more effective. Let’s dive into the key changes:
- Merging Raw and Decoded Tables: We’ve combined raw and decoded tables into single, unified tables for all entities. This means you no longer need to worry about the distinction between RAW and DECODED schemas. A “decoded” column now clearly indicates the status of the decoding process, making querying data more straightforward.
- Simplified Column Structure: We’ve made modifications to column names, removed redundant ones, and added new columns where necessary across all tables. To facilitate a seamless transition, we’ve prepared a change log for each table, making it easier for you to adapt your queries.
- Business data to complement core tables: We’ve integrated essential business data, such as Transfers and Tokens, into the same database and schema. Using business data, you can now run simpler, less compute-intensive queries. We’ll be regularly adding new business datasets to enrich your analytical capabilities.
- Better Ethereum data across the board: We’ve listened to your feedback and addressed various bugs. Also we’re continuously working behind the scenes enhancing data quality and implementing robust data pipelines to cater even for the most sensitive use cases.
For those who have been with us since the beta days, we’ve got you covered with a migration guide available in our documentation. We’ve already started the process of sunsetting the old beta dataset, so ensure a smooth transition to the new EDW before November.
Get access to Ethereum Data Warehouse
EDW is now available through Snowflake Marketplace as a part of our Ethereum Data Wizard package. Not convinced our data meets your needs? Don’t take our word, try it out for yourself. Explore our demo package, which features a 7-day snapshot of Ethereum data, complete with state and storage diffs, and our business datasets.
Going forward, EDW will be available through our paid plans. You can find the updated pricing details on our website, but don’t hesitate to reach out to dicuss custom offering.
We have a few surprises in store till the end of the year that will further improve the way our data is accessible to you (Big Query fans keep an eye out). Going forward, you can also expect more chains and – of course – more decoded data.
Lastly, massive kudos for your incredible support during the beta phase. We received tons of valuable feedback – with hundreds of users and tens of thousands of queries being run we were able to significantly improve our product.
Stay curious, stay data-hungry, and get ready for the next chapter in the world of Token Flow data!
Optimism Data Warehouse is live(state and storage diffs included) We are thrilled to announce the latest addition to Token Flow’s comprehensive blockchain datasets – Optimism.
Imagine logging in to your bank to check your historic balance, but only seeing the history of your transactions, not your balance? You could go through all transactions and calculate your balance at any point in time, but it’s hardly the best way to do it.
This is how most analyses on Ethereum data work now. Direct querying becomes nearly impossible due to the way storage is organized. This is because memory locations are actually hashes of variable slots and keys, which are incomprehensible to most.
AnyTx transaction decoder reveals the full spectrum of blockchain interactions to get better understanding of what’s going on chain.