Snowflake connector 200-row cap in UiPath Integration Service: how to paginate or go async

Why the UiPath Snowflake connector stops at 200 rows, and two patterns that work: paging the sync query or going async.