akshaymahajan2023-08-10 01:25 PM
    SELECT *
    FROM axelar.core.fact_transactions
    limit 10
    -- where --tx_log like '%0xb1401599afc70ee9e59c7317ba951a6c4604ff8eb20d3d10c99b61f673b39703%' and
    -- -- TRY_PARSE_JSON(tx_log)[0]:events[0]:type='axelar.evm.v1beta1.EVMEventConfirmed'
    -- --TRY_PARSE_JSON(tx_log)[0]:events[0]:type='axelar.evm.v1beta1.ContractCallWithToken'
    -- tx_log like '%ContractCallWithToken%' or tx_log like '%ContractCall%'
    -- --ContractCallWithToken
    -- --limit 1000
    -- and tx_succeeded=TRUE

    Run a query to Download Data