search

Giveth / GIVeconomy

The Giveth Economy is the collective of projects, donors, builders, and community members builders that build the future of giving
GNU General Public License v3.0
6 stars 0 forks source link

Migrate and Update information from Dune analytics #810

Open divine-comedian opened 2 years ago

divine-comedian commented 2 years ago

dune v1 scripts are set to stop working in the next few weeks as part of the upgrade to dune v2 analytics -

found this from a friend in the TEC: image

This dashboard has lots of out of date or irrelevant data anyway: https://dune.com/metacrypto/giveconomy

We'll need to cherry pick the stats we want to keep and then figure out how to migrate or re-capture the data in this new dashboard. We should also consider any new GIVeconomy related data we'll want to find a way to track - but I'll put this in a separate issue.

I know @clara-zi was investigating dune and this dashboard so please contribute to this issue with your observations.

Things I think we'll need to migrate:

General GIV token things

GIVgarden

clara-zi commented 2 years ago

v1 to v2 migration means updating query lang. to sparkSQL. This means renaming data tables as they've changed naming conventions, formats. Some structures will probably be ok but the task will be to go through each line, checking what the differences are in v2 sparksql code.

fyi - it looks like you can get a Dune API if we wanted to display Dune dashboard alongside other offchain info

@Santigs - fyi this was the issue I was talking about.

also tagging @mendesfabio - can you assist upgrading queries to v2 - not all queries will need to updated, as some data in the dashboard is no longer required.

divine-comedian commented 2 years ago

I also suggested it would be awesome if @RamRamez could spend some time learning how dune works. He'll be checking it out when he has time.

mendesfabio commented 2 years ago

First of all, Dune V1 won't stop working in the next few weeks.

I have so much going on that I forgot we migrated some queries to V2 months ago and submitted the contracts for decoding - as you can see on the V2 engine. I also secured the Giveth handler at Dune to move the dashboard from my own account.

I just want to highlight that there's no need to rush on migrating the queries. You're wondering how to perform the migration when should be wondering which charts/data you want to have there.

FWIW regarding the API, I wouldn't count on that because I'm not sure Giveth will pay for it.

oyealmond commented 1 year ago

@divine-comedian can we close this issue as well?