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	66	April 27, 2025
ROLLBACK - Unable to perform operation using terminated connection - Snowflake 💬 App Building bug	6	1028	March 29, 2024
How to use composite primary key for bulk updates? 💬 Queries and Resources	18	14737	June 15, 2022
Fast Bulk queries for postgres and MSSQL using JS ->JSON->SQL 🤝 Community Show & Tell javascript , sql	1	1917	July 25, 2023
Retool GUI Query to Update a Single Record Not Working as Expected 💬 Queries and Resources bug , sql , query-settings , snowflake	9	686	August 29, 2024

Snowflake Resource Query - Merge

Related topics