Scheduled Workflow should run only after the source is refreshed

[arunb]

Hello,

I'm working on an Alteryx workflow. I have multiple data sources in the workflow. Now my scheduled workflow should run on a daily basis only after all the sources are refreshed. Please help me with step by step procedure in implement this.

Thanks.

[abacon]

@arunb This request depends on how the data sources are refreshed. If they are refreshed in an alteryx workflow, there are a few ways to do this. If it is refreshed by another process, your options are more limited.

Before I list out options, could you detail how the sources are refreshed and within what tool?

abacon

[arunb]

Thanks abacon for the response.

We are not refreshing any of the sources in alteryx and we have multiple sources like Snowflake, Microsoft SQL Servers, DBeaver Oracle, Excel,  etc.

[abacon]

@arunb So you have a few options, I am sure others may find more but I have listed what I would do below:

1. I one of the sources getting refreshed can make api calls, I would have it trigger the alteryx workflow using an api call from the server apis. This would trigger the workflow you want once the refresh is completed.
2. If there is a known time the sources refresh, stagger your schedule on the alteryx server to not run up against the data source refresh. This is not preferred but it would be the easiest method.

Since alteryx isn't doing the refreshing, it will be tricky to make it a truly dependent process.

abacon

[KGT]

Option 1 from @abacon is the best solution.

The other option if that is not available, is to have a workflow run every 5 minutes on the gallery around the time the sources are refreshed. When it detects that a source is refreshed, it runs the workflow (via API is the best option). This is a workaround type option, but you can keep adding checks to that workflow if you have a couple of situations like this.