Adam Harris
Adam Harris6mo ago

Issue trying to import csv via Airbyte

Hi, I'm trying to import a csv into a Convex table via the Airbyte integration. I've successfully set up convex as a destination and I've tried to import the csv by using a Google sheet as an Airbyte source for the csv and also by using the File (CSV, JSON, Excel, Feather, Parquet) v0.5.3 Airbyte source (using a private AWS bucket). The full csv has around 23k rows. However if I take the first few (eg 20) rows from the csv and try and import that then it works fine via the AWS bucket. Here is the last error I got when trying to sync the full csv via the File connector:
Warning from destination: Something went wrong in the connector. See the logs for more details.

Expecting value: line 1 column 1 (char 0)
Warning from destination: Something went wrong in the connector. See the logs for more details.

Expecting value: line 1 column 1 (char 0)
2 Replies
Adam Harris
Adam HarrisOP6mo ago
Also here are the logs from that failed sync
nipunn
nipunn5mo ago
What's the name and/or URL of the deployment you're importing into? May make it easier for us to take a look from our side. Also I might note that npx convex import can work for simple non-streaming imports. Airbyte is really powerful for streaming import, especially when the source data changes over time. For one-offs, it might be a bit easier to just try that. I'd still be curious to find out deployment name

Did you find this page helpful?