KaskoazulInitial_eval_follows
    Updated 2023-01-24
    WITH tx_with_method AS (
    SELECT
    ft.block_id
    , COALESCE(ft.block_timestamp, b.block_timestamp) AS block_timestamp
    , ft.tx_hash
    , SPLIT_PART(ft.action_id, '-', 2) AS action_no
    , ft.action_name
    , ft.method_name
    , ft.args
    , ft.deposit / POW(10,24) AS deposit_near
    , t.tx_signer as user_name
    , t.tx_receiver
    , PARSE_JSON(args) as message
    FROM
    near.core.fact_actions_events_function_call ft
    LEFT JOIN
    near.core.fact_blocks b
    ON
    ft.block_id = b.block_id
    LEFT JOIN
    near.core.fact_transactions t
    ON
    ft.tx_hash = t.tx_hash
    WHERE
    tx_receiver = 'social.near'
    AND tx_signer != 'social.near'
    )

    , FLATTEN1 AS (
    SELECT
    t.block_timestamp
    , t.block_id
    , t.user_name
    , t.tx_hash
    , t.action_no
    , t.action_name
    Run a query to Download Data