Check the Status and Get Results SnowFlake connector not working

(1) Share

Report

Posted on by CR-13031356-0

Snowflake Submit SQL Statement for Execution connector splits the Data into separate partitions when there is large chunk of data.

I attempted to retrieve all the data from the partitions and stored the results in an array variable using the "Apply to each" loop

In the apply to each loop used the Check the Status and Get Results connector with the StatementHandle from the previous Submit SQL Statement for Execution step, and loop through all the partitions.

However, the Check the Status and Get Results connector only works when setting partition = 0. When I try any other partition (1+)/(Dynamic value), It keeps running in the loop without returning any data

Categories:

Licensing

All responses (1)

Answers (0)

Michael E. Gernaey 40,947 Super User 2025 Season 1 on at

Like (0)

Report

Check the Status and Get Results SnowFlake connector not working

Hi

Can you go in and look at what the error is please on the apply to each. Since its doing Retries, it should have an error there (I can see the red circle of doom lol)