Can't upload table to My DB

Question

Hello, i'm currently trying to upload a 2.5MB .csv that is formatted as follows:

id1_1,id1_2

iDR4_3_SPLUS-n19s11_dual_0012382,iDR4_3_SPLUS-n19s11_dual_0010034

iDR4_3_SPLUS-n19s11_dual_0021877,iDR4_3_SPLUS-n19s11_dual_0021851

iDR4_3_SPLUS-n19s07_dual_0006718,iDR4_3_SPLUS-n19s07_dual_0005682

...

but when i try to upload it via qc.mydb_create() i get the error "Connection aborted. ConnectionResetError(10054, "An existing connection was forcibly closed by the remote host", None, 10054, None"

if i try to upload it from the web service i get the error "Unable to process upload. Verify that the csv headers are present and that they match the table schema (for existing tables)".

This is the first table that i try to upload and create to myDB.

Best Regards.

Answer 1

To import data into a MyDB table you should use `mydb_import`. This works for existing tables or the table can be created on the fly. The method `mydb_create` only creates a table using a provided schema.

Additionally, be sure your table name is only using lowercase letters and underscores.

See our documentation which provides more information and examples.