Insert into database using retool SQL mode - bulk insert

Queries and Resources
1

Hi,
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
select
item.date,
item.Integration,
item.Product,
item.Provider,
item.Forecast
from {{table2.data}}  as item
2

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