Migrate Balancer's balancer.view_lbps Dune abstraction to a Dune spellbook.
For Dune Engine V2
I've checked that:
General checks:
[x] I tested the query on dune.com after compiling the model with dbt compile (compiled queries are written to the target directory)
[x] I used "refs" to reference other models in this repo and "sources" to reference raw or decoded tables
[x] if adding a new model, I added a test
[x] the filename is unique and ends with .sql
[x] each sql file is a select statement and has only one view, table or function defined
[x] column names are lowercase_snake_cased
[ ] if adding a new model, I edited the dbt project YAML file with new directory path for both models and seeds (if applicable)
[x] if wanting to expose a model in the UI (Dune data explorer), I added a post-hook in the JINJA config to add metadata (blockchains, sector/project, name and contributor Dune usernames)
Pricing checks:
[ ] coin_id represents the ID of the coin on coinpaprika.com
[ ] all the coins are active on coinpaprika.com (please remove inactive ones)
Join logic:
[ ] if joining to base table (i.e. ethereum transactions or traces), I looked to make it an inner join if possible
Incremental logic:
[ ] I used is_incremental & not is_incremental jinja block filters on both base tables and decoded tables
[ ] if joining to base table (i.e. ethereum transactions or traces), I applied join condition where block_time >= date_trunc("day", now() - interval '1 week')
[ ] if joining to prices view, I applied join condition where minute >= date_trunc("day", now() - interval '1 week')
Brief comments on the purpose of your changes:
Migrate Balancer's
balancer.view_lbps
Dune abstraction to a Dune spellbook.For Dune Engine V2
I've checked that:
General checks:
lowercase_snake_cased
Pricing checks:
coin_id
represents the ID of the coin on coinpaprika.comJoin logic:
Incremental logic: