Forum Discussion

dufletch's avatar
dufletch
Frequent Visitor
5 years ago
Solved

Refreshing multiple dataflows that rely on each other - best approach?

Hi all,

 

I have created a series of dataflows that connect to each other in a parent/child/grandchild type relationship. 

 

When a grandchild flow needs to be refreshed, its child and parent will need to refreshed prior to that in to ensure the grandchild it refreshing current data.

 

My question is this - if I schedule all "generations" of flows to refresh at the same time, will the service automatically recognise the dependencies and wait for a parent to refresh before it triggers the child refresh? Or should I schedule the parent to refresh half an hour before the child and so-on?

 

Thanks in advance!

dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi dufletch 

    If you set the schedule refresh time at the same time, all dataflow will refresh at the same time.

    So please set an interval between parent, child and grandchild.

    And if your parent dataflow is complex and huge, please reserve enough time to refresh it.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi dufletch 

    If you set the schedule refresh time at the same time, all dataflow will refresh at the same time.

    So please set an interval between parent, child and grandchild.

    And if your parent dataflow is complex and huge, please reserve enough time to refresh it.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.