Hey @victoria :slight_smile:, I am wanting to convert a Bulk Update/Upsert via GUI Mode to a Snowflake Merge Statement in SQL Mode. Wanting to do this conversion so I can get around the performance limitations of the Bulk Update/Upsert in GUI Mode. My use case is bulk updating a table I have on Sn…

Sorry for the delay here everyone! We've been tinkering with this and one solution that a user we spoke with recently found is to use a transient table from the csv data. Then run the merge on the original table and the temp table. As a solution, I used transient table: 1. CREATE transient table…

Snowflake Resource Query - Merge

💬 Queries and Resources

victoria October 6, 2022, 10:57pm 2

Looking into this!

1 Like

Topic		Replies	Views
Write Data SQL not finishing 💬 Workflows sql	19	80	April 27, 2025
ROLLBACK - Unable to perform operation using terminated connection - Snowflake 💬 App Building bug	6	1077	March 29, 2024
How to use composite primary key for bulk updates? 💬 Queries and Resources	18	14859	June 15, 2022
Retool GUI Query to Update a Single Record Not Working as Expected 💬 Queries and Resources bug , sql , query-settings , snowflake	9	718	August 29, 2024
How to use save changes to update records of a join table? 💬 Queries and Resources sql	10	6295	July 18, 2023

Snowflake Resource Query - Merge

Related topics