Understanding Tables (Raw, Decoded, Curated/Spellbook, Views, Uploads)
The video provides an overview of navigating and understanding the different types of tables on the Dune platform. Key points include:
- Introduction to Tables: Dune hosts tens of millions of tables, which can be overwhelming to navigate. The video aims to help users understand the different kinds of tables, including how they are constructed from raw data to decoded tables and curated datasets.
- Top Tables to Know: The video highlights commonly used tables, such as those related to tokens, ENS labels, contract names, and trading data. These are found in the curated datasets within Dune's data explorer.
- Data Lineage: The video explains the flow of data on Dune, starting from raw data collected from blockchain RPCs, to decoded tables (using ABIs to make data more accessible), and finally to curated datasets created by the community. It also touches on external uploaded data.
- Identifying Table Types: Users are shown how to identify different table types by their prefixes—such as
dataset_
for uploads,result_
for materialized views, andquery_
for query views. The video also explains how raw tables follow a specific naming convention tied to the blockchain. - Curated Data and Spellbook: The video introduces Spellbook, a community-driven repository with over 4,000 models, where curated data sets like Dex trades are defined. Users can explore the source of these tables via GitHub to understand the underlying SQL.
- Finding the Right Tables: The video offers tools and tips for finding the right tables to query, particularly when working with specific contracts or transaction hashes. Users can use dashboards to input contract addresses or transaction hashes to find relevant functions and event tables.
- Requesting Data: If users cannot find a specific table, they are encouraged to request it via the Spellbook GitHub repository, where they can suggest new tables or ask for assistance.
Overall, the video helps users navigate Dune's vast array of tables, understand their construction and types, and efficiently find the data they need for querying.