[BUG] bonkbot_solana.trades spellbook stopped indexing new records

[whalehunting]

Description

The Bonkbot Solana Trades spellbook, introduced in #5520 is not updating anymore.

To reproduce:

SELECT
  *
FROM
  bonkbot_solana.trades
ORDER BY
  block_time DESC
LIMIT
  1

Current behavior

The last indexed trade has a timestamp of 2024-03-26 12:51

Expected behavior

Trades should have a more recent timestamp by now, as the fee wallet still has activity every few seconds:
https://solana.fm/address/ZG98FUCjb8mJ824Gbs6RsgVmr1FhXb2oNiJHa2dwmPd/transactions

Impacted model(s)

bonkbot_solana.trades

Possible solution

[jeff-dude]

remember, the whole lineage is now alias bot_trades :)

updated query:

SELECT
  *
FROM
  bonkbot_solana.bot_trades
ORDER BY
  block_time DESC
LIMIT
  1

[jeff-dude]

i imagine you'll use dex_solana.bot_trades for downstream dashboards?

[jeff-dude]

we have an automated process to drop spells in the metastore / data lake after removed from main branch, so i'd expected the trade alias spell to be gone soon

[whalehunting]

remember, the whole lineage is now alias bot_trades :)

updated query:

SELECT
  *
FROM
  bonkbot_solana.bot_trades
ORDER BY
  block_time DESC
LIMIT
  1

oh ok that makes sense! thanks for pointing it out, didn't see that bonkbot was also changed :)