Discussion posts and replies are publicly visible
Actually you can write up to 50 000 rows at once in the Write Records node: docs.appian.com/.../Write_Records_Smart_Service.html. If you want to write more than that, you can create a loop with batches.
Also the 1000 limit is for batches of syncing data - that's where the processing of data in batches matters. And like others have mentioned, the keep data available at high volumes isn't intended to limit high volumes of batching, but high volumes of data in the sources (>4M rows).