Add transaction_success = TRUE or FALSE to filter failed transactions on Solana (TOKEN_TRANSFERS)

[0xweb3dev]

I can't filter out failed transactions in ClickHouse. Right now, there isn't an easy way to separate successful transactions from the ones that failed, which makes it harder to analyze the data.

It would be great to have a transaction_success flag that we can set to TRUE or FALSE in queries. This would let us quickly filter transactions based on whether they succeeded or failed. For example:

transaction_success = TRUE: Shows only successful transactions. transaction_success = FALSE: Shows only failed transactions. This would make querying a lot more efficient and straightforward.

This feature would make it easier to work with transaction data

[gingerwizard]

@0xweb3dev happy to add this. Can you provide the queries you use to identify whether a transaction was successful or failed? Solana or Ethereum?

A few options:

• we can add a Materialized column if this is simple to compute to the existing transactions table
• we can filter successful and failed transactions to seperate tables using a MV.
• We can maybe consider adding it during data insertion. @jling

[AlphonsG]

@0xweb3dev dude they replied to your issue with a question, why ignore?