Forum Discussion

swatifunde's avatar
swatifunde
Contributor
3 years ago
Solved

How to iterate the pipeline

Hello Community, I want to iterate the pipeline when expression get true,below is my current pipeline design In this pipeline I am checking count of Null values of column if all values Null ...
  • koryknick's avatar
    koryknick
    3 years ago

    @swatifunde - Here is an example that calls a triggered task until a desired result is returned. I’ve also attached the pipeline that it is calling so you can correlate the query results with the Has Next property in the REST Get.
    Community 13497 - Child - Query Snowflake Table_2022_09_28.slp (2.7 KB)
    Community 13497 - Poll Snowflake Table_2022_09_28.slp (6.6 KB)

    Please note that calling a triggered task on an extremely frequent schedule will create a large amount of noise in your Dashboard. It is possible you may also experience some occasional failures calling the task due to network traffic. If your org has Ultra Tasks enabled, this would resolve the additional traffic in Dashboard and has excellent response since it avoids instantiating a new pipeline with each call.

swatifunde's avatar
swatifunde
Contributor
3 years ago

yes, I did it

  • swatifunde's avatar
    swatifunde
    Contributor
    3 years ago

    its working now but can you just confirm on thing here

    I used Has Next parameter as per attachment so I want to know that until unless this condition get false it will continuously check the data on source system, right??

    • koryknick's avatar
      koryknick
      Employee
      3 years ago

      Yes - it will continually check until the Not_null value is non-zero and then it will stop calling URL.