How to use " Bulk Patch Records" to update a specific colum to a specific value?

Hello,

I want to update all rows in a table, about 100K records per datasource. The colum "type" is now empty for all rows, but needs to be "stringValue". All 100k records need the same value.

How do I do this using the "Bulk Patch Records" function?

I have queried all rows using sql and only the colums "id" and "type" are returned. If needed, I can also return the other colums.

Mario