Query timeout not honored

I'm trying to insert ~25k rows into Retool DB from a csv import. Unfortunately write perfomance seemds quite bad so the query exceeds the max timeout of 120s.

Hence, I'm splitting the insert into batches of 1k rows and I'm manually triggering the insert query. However, when I do that, some of the queries start timing out after 20-25s.

Is this a bug?

Hi @thomas_k_x Did you already get the data saved in Retool DB?

Is this a one time import or something you'll need to run regularly? ~25k rows is a decent amount of data to be working with. I'd try adding a delay between batches or setting this up in Workflows and adding a retry. This post might be helpful