@dune.eth team: we're finding 50h+ delay since last update of tokens_base.balances_latest table 

is there someone please who can take a look -- it's blocking a major release of ours

thanks!

chef at moxie.xyz | Moxie is your onchain AI assistant—analyzing transactions, unlocking social alpha, and executing trades on your behalf.

Thanks for reporting. We're looking into it.

Gm just checked the dbt code maybe incremental_predicates for the destination table could help, so that the merge can perform faster (if this is the bottleneck)

Good idea! Because there are a few issues with `tokens_base.balances_latest`, our first best solution is enabling the same query with `tokens_base.balances`.

What also could help is to persist the incoming delta, then remove duplicates via remove or where configuring and then insert only instead of merge… but this are just things I did in the past and can’t say if this is really the best for this case.