Can a workflow be used to set off a dataset update and ETL run?

cgshinn3

Can a workflow be used to set off a dataset update and ETL run? It's currently on a schedule for every 4 hours M - F but every Tuesday at 10:45 I need to run it one extra time.

ellibot

@cgshinn3 you can accomplish more custom schedules using the streams API. Here's an example:

https://www.youtube.com/watch?v=0cTMM9xOuxw&t=8s

MarkSnodgrass

Yes, you can create multiple triggers for when an ETL to run. You can create one trigger that runs every 4 hours M-F. Then create another trigger by pressing the Add Trigger button that runs every Tuesday at 10:45.

cgshinn3

Can I do this on a raw dataset from Salesforce?

MarkSnodgrass

Are you saying that you want the raw dataset that pulls data from Salesforce to be on this custom schedule and not a Magic ETL dataflow that uses this dataset?

cgshinn3

Yes. That's correct.

ellibot

@cgshinn3 you can accomplish more custom schedules using the streams API. Here's an example:

https://www.youtube.com/watch?v=0cTMM9xOuxw&t=8s

ellibot

https://www.youtube.com/watch?v=kjVZ5-dR6LE