messarisolana_txn_type
    Updated 2023-04-08
    select
    *
    from
    solana.core.fact_transactions
    limit
    10;

    select
    tx_id,
    value
    from
    solana.core.fact_transactions,
    table (flatten(instructions)) as f
    where
    solana.core.fact_transactions = f."$1"
    limit
    10;

    SELECT
    id,
    value
    FROM
    my_table,
    TABLE (FLATTEN(array_column)) as f
    WHERE
    my_table.id = f."$1";
    Run a query to Download Data