Hi, I am new to Retool, but enjoying learning how to use it. My request is around a workflow, where I have selected data from a retool database and am trying to use the "Bulk upsert via primary key" to write the information to an SQL database. When executing this in a workflow I get the error mess…

@Flemming_Troelsen , You can also try the approach of bulk inserting your data into a staging table first, then using a MERGE statement to sync that data into your production table. With the right conditions in the MERGE, you can control exactly what happens — for example, insert only if a row doesn…

Write Data SQL not finishing

💬 Workflows

lindakwoo April 27, 2025, 9:58pm 19

@Flemming_Troelsen,
For future reference, check this out: Speed up Bulk Upserts and Updates in Retool with MERGE + Staging Tables

Topic		Replies	Views
Bulk upsert to PostgreSQL 💬 Queries and Resources	8	1727	June 10, 2024
How do I make Retool use one query to bulk upsert instead of thousands? 💬 Queries and Resources	5	1075	July 29, 2024
Parameter Limit on Bulk Insert 💬 Queries and Resources	7	2333	August 30, 2023
How do I keep a table updated? 💬 Queries and Resources	5	4552	August 1, 2023
Speed up Bulk Upserts and Updates in Retool with MERGE + Staging Tables 🧑‍💻 Retool Tips & Tricks sql , bulk-update , bulk-upsert	2	80	April 29, 2025

Write Data SQL not finishing

Related topics