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
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)
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
1
Share
Report
All responses (
Answers (
