synBuildTable throws unexpected error

Description

I am trying to upload a large table (2 gb) as a table so that I can query it easily.

My workflow looks like this:

Download the csv: https://drugtargetcommons.fimm.fi/static/Excell_files/DTC_data.csv

Read into R:

 

This runs for a bit but then throws the following error:

 

This is confusing, because the data frame (a tibble) only has 33 columns.

Row 835529 (ignoring the header...) looks like this:

I'm guessing it's the 'title' column that is tripping up synapser, but regardless, it appears to be interpreting the data in that column differently than readr::read_csv is.

Environment

None

Assignee

Unassigned

Reporter

Robert Allaway

Labels

None

Validator

Robert Allaway

Development Area

None

Release Version History

None

Priority

Minor
Configure