Is there a way to import larger then 5MB csvs into the database?

💬 App Building
1

I am trying to import some data from a csv into the database and when I try to import it I receive a error saying that I cannot import since it is to large. Is there a way around this?

1 Like
2

Split the CSV into Smaller Chunks

  1. Use a tool like Excel, Google Sheets, or a command-line tool to split your CSV into multiple smaller files
  2. Import each file separately through Retool
1 Like
3

Can you provide more details? What's your use case? Thru which component you upload the file?

  • If you're just using the file input component, make sure the validation rule - max size is set properly.

  • If you have configured nginx reverse proxy for SSL, client_max_body_size can limit the max size of file you can upload.

Once you can upload the file and parse it (within Retool) successfully, there shouldn't be issue pushing the records to your db and there're actually various ways to do it.

4

Welcome to the community, @Treydog24! Thanks for reaching out. :slightly_smiling_face:

We just pushed out an update that raises the limit to 10MB for .csv uploads, which is hopefully enough to unblock you. If not, I recommend splitting your file up as @qandeelcc described above.

Let me know if you have any follow-up questions!