Currently claimable_balances_current is disabled because it has performance issues that require an increase in bq slot reservations to complete in a timely manner. We should optimize claimable_balances_current to finish around the same time as other *_current tables (5-15 mins) without the need for more slot reservations.
Some ideas that may help with performance:
- Update dbt model to include clustering
- Run BQ EXPLAIN on claimable_balances_current to see if there is weird shuffling or skew and try to optimize the query and optimize from there
- Add new field farmfingerprint(balance_id) to integer
- Make claimants JSON
Currently
claimable_balances_currentis disabled because it has performance issues that require an increase in bq slot reservations to complete in a timely manner. We should optimizeclaimable_balances_currentto finish around the same time as other *_current tables (5-15 mins) without the need for more slot reservations.Some ideas that may help with performance: