Insert into database using retool SQL mode - bulk insert

I am trying to do bulk insert into database table using the csv file data using retool
The below query is throwing an error. Can you please help with it

insert into tablename
from {{}}  as item

Hi there,

Thanks for reaching out to us!

I'm assuming your workflow currently is upload CSV -> apply it to table -> then bulk insert to RetoolDB, correct?

For bulk inserts, it is usually much easier to use GUI Mode in these cases as it is much easier! (Though some users have created workarounds)

In my case, bulk inserting via GUI mode successfully updated my DB

Would GUI mode assist you here? Please let me know!

1 Like