Debugging Out of Memory error

[justsparsh]

I am currently running into the following error when reading a large .geojson file into a table and could use some help understanding what's going on behind the scenes here.

async_bindings.ts:150 Uncaught (in promise) Error: Out of Memory Error: Allocation failure

This was preceded by the following warning:

runtime_browser.ts:292 Buffering missing file: /tmp/duckdb-tmp/duckdb_temp_storage-0

This is the relevant bits of code which trigger the error:

const db = new duckdb.AsyncDuckDB(logger, worker);
await db.instantiate(bundle.mainModule, bundle.pthreadWorker);
URL.revokeObjectURL(worker_url);

const connection = await db.connect();

await connection.query(`
    INSTALL spatial;
    INSTALL json;
    LOAD spatial;
    LOAD json;
    SET temp_directory = '/tmp/duckdb-tmp'
`);

const rowCount = await conn.query(`
        CREATE OR REPLACE TEMPORARY TABLE temp_raw_data AS
        SELECT * FROM ${reader}('${fileUrl}'${reader === 'read_csv' ? ", nullstr=['NA']" : reader === 'st_read' ? ", open_options=['FLATTEN_NESTED_ATTRIBUTES=YES','SHAPE_RESTORE_SHX=YES']" : ''});
        SELECT count(*) FROM temp_raw_data;
    `)

Is there a work around for the 4GB memory limit? When I alternatively try to ATTACH a .db file, I get an error related to the nonexistent .wal file.