dune

anyone good at dune?  trying to figure out why I am coming empty handed on some sql. feels like I am missing a simple thing (yes I tried Claude)

Michelada connoisseur. Chief Onchain Officer at /area51 since 2022 AD. Focused on digital art & crypto

CARDBOARD

Elevating onchain creators 

@nodefoundation @brightmoments 
@ampsfun

Pretty busy right now, but send me the query in dm and i'll see if i can help!

@jondar would be epic, I forked their work 😂 and tweaked from there

enjoy cats, running, bread, and a bit of w̶e̶b̶3̶ onchain data

Yeah let me send you via DM I think I may know what’s up

i’m about to step out but could take a quick look later tonight if no one else unsticks you

Best debug tool is sliding in between your tables (cte) and adding a 

select * from CTE 
limit 10 

Then running that to see the output from intermediary tables

Often there are join issues or you aren’t getting what you expected from your intermediate tables/the dune datasets

(Left join -> not picky, join very specific, filters only to data in both tables)