SELECT

*

from

(

SELECT

*,

CASE

when ORIGIN_FUNCTION_SIGNATURE = '0x954fa5ee' then 'ClaimAllGas'

when ORIGIN_FUNCTION_SIGNATURE = '0x860043b6' then 'ClaimAllYield'

when ORIGIN_FUNCTION_SIGNATURE = '0xfafce39e' then 'ClaimGas'

when ORIGIN_FUNCTION_SIGNATURE = '0x0951888f' then 'ClaimGasAtMinClaimRate'

when ORIGIN_FUNCTION_SIGNATURE = '0x662aa11d' then 'ClaimMaxGas'

when ORIGIN_FUNCTION_SIGNATURE = '0xf9719662' then 'ClaimYield'

when ORIGIN_FUNCTION_SIGNATURE = '0xc8992e61' then 'Configure'

when ORIGIN_FUNCTION_SIGNATURE = '0x7114177a' then 'ConfigureAutomaticYield'

when ORIGIN_FUNCTION_SIGNATURE = '0x3ba5713e' then 'ConfigureAutomaticYieldOnBehlaf'

when ORIGIN_FUNCTION_SIGNATURE = '0x4e606c47' then 'ConfigureClaimableGas'

when ORIGIN_FUNCTION_SIGNATURE = '0x908c8502' then 'ConfigureClaimableGasOnBehalf'

when ORIGIN_FUNCTION_SIGNATURE = '0xf098767a' then 'ConfigureClaimableYield'

when ORIGIN_FUNCTION_SIGNATURE = '0x4c802f38' then 'ConfigureContract'

when ORIGIN_FUNCTION_SIGNATURE = '0x37ebe3a8' then 'ConfigureClaimableYieldOnBehalf'

when ORIGIN_FUNCTION_SIGNATURE = '0xeb864698' then 'ConfigureGoverner'

when ORIGIN_FUNCTION_SIGNATURE = '0x0ca12c4b' then 'ConfigureGovernerOnBehalf'

when ORIGIN_FUNCTION_SIGNATURE = '0x2210dfb1' then 'ConfigureVoidGas'

when ORIGIN_FUNCTION_SIGNATURE = '0xeb59acdc' then 'ConfigureVoidGasOnBehalf'

when ORIGIN_FUNCTION_SIGNATURE = '0xaa857d98' then 'ConfigureVoidYield'

when ORIGIN_FUNCTION_SIGNATURE = '0xb71d6dd4' then 'ConfigureVoidYieldOnBehalf'

Else 'initialize'

end as event_name

FROM

blast.core.fact_transactions

where

to_Address = '0x4300000000000000000000000000000000000002'

and STATUS = 'SUCCESS'

)