Having trouble importing CSV files into DuckDB-Wasm

[yilan007]

I am trying to call insertCSVFromPath(conn: number, path: string, option: CSVInsertOptions) to import a csv file into DuckDB-Wasm. In the function signature, what is conn referring to? Here is how I call it. I don't know what conn is referring to, so I just randomly pick a number.

In this case, I got an error as follows:

Could anyone help me with it? Thank you very much!

[domoritz]

conn is a connection. Here is a code snippet from the DuckDB Observable client. So note that you call insertCSVFromPath on the connection.

 async insertCSV(name, buffer, options) {
    const db = await this.db();
    await db.registerFileBuffer(name, new Uint8Array(buffer));
    const conn = await db.connect();
    await conn.insertCSVFromPath(name, { name, schema: "main", ...options });
    await conn.close();
 }

[yilan007]

Thank you so much! I got confused by the API documentation which said conn must be a number. This makes a lot more sense!