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

说明与用途

在 UiPath 新的 Snowflake 连接器中，执行同步查询时最多只能返回 200 行，即使 SQL LIMIT 更高。解决方案是使用 LIMIT/OFFSET 分页，或使用异步查询（同样限制为 200 行）并按顺序分页获取数据。

问题

When using UiPath’s new Snowflake connector, Execute Select Query Synchronously returns at most 200 rows even if the SQL LIMIT is higher, causing large result sets to be truncated.

结果

By paging with LIMIT/OFFSET or using asynchronous execution, workflows can retrieve datasets of any size from Snowflake while respecting the 200-row cap of the connector.

工作流

• Write a stable SELECT query with ORDER BY on a unique key and LIMIT 200 OFFSET 0.
• Generate the output schema from the literal query; then replace the offset with a variable.
• In a Do While loop, execute Execute Select Query Synchronously, append the returned rows to a collection, and increment the offset by 200.
• Stop when a page returns fewer than 200 rows.
• (If the query takes >30s) use Execute Any Query Asynchronously to get a Query ID, poll status with Get Asynchronous Query Execution Status, and when SUCCESS, retrieve results with Get Asynchronous Query Execution Results, paging with its Offset and Limit properties.

证据

Execute Select Query Synchronously returns max 200 records even with a higher LIMIT; use LIMIT/OFFSET in the Select Query inside a Do While

来源

Always paginate large result sets with LIMIT and OFFSET

来源

Use Execute Any Query Asynchronously for queries over 30 seconds; non-SELECT commands only via the async activity

来源

Without ORDER BY, LIMIT results are non-deterministic; keep ORDER BY and LIMIT at the same query level

来源