Updating multiple rows in a table component with Snowflake backend

I have a table component with editable fields. If multiple rows are edited, all edited rows will be passed to the triggered query in the "recordUpdates" field. For a Snowflake update query, how can I iterate through each updated row and call the SQL update one at a time? If not possible, is there any way to limit table editing to one row at a time?

Thanks,

Hey @nshi!

Great question! I believe you could use a setup similar to this one from our docs. Instead of an array, you could use table.recordUpdates and trigger your SQL update query by passing each row via additionalScope. Do you think this could work for your use case here?