Can I schedule a date flow to run at a specified time?

Jim_Medina
Jim_Medina Member
edited March 2023 in Datasets

I created a data flow (thanks to answers from the Community!) which seems to take quite a long time to run manually.  I've submitted it to run twice manually and cancelled it after 30 minutes.  I haven't run it successfully yet, so I don't even know if it works.  If it fails, at least I'll get to find my errors.

 

I'd like to schedule it to run sometime in the early morning before I get in.  Is there a way to do that?

Best Answer

  • quinnj
    quinnj Domo Employee
    Answer ✓

    Hey @Jim_Medina,

     

    I like to use a simple trick to accomplish this using the NOAA Weather connector. As you know, DataFlows can be set to run when any of their datasources update. An easy way to "schedule" a DataFlow to run at a specific time is to setup a "dummy" datasource that will update at the time you'd like the DataFlow to run.

     

    I like to use the NOAA Weather connector for this since it only requires a zip code to setup and we can leverage the connector scheduling abilities to essentially "schedule" our DataFlow.

     

    To setup the NOAA Weather connector, head to your Data Center and click the "New DataSet" button in the top right. Scroll down and select the NOAA Weather connector (not the weather alerts version). You can then put in any zip code you'd like, click "Next" and then you have the ability to schedule how often you want this connector to update (daily, weekly, every 15 minutes, etc.). Note that the time of day setting is based on UTC time, which will be 5-7 hours ahead of USA timezones.

     

    Then you simply include this new "dummy" weather dataset as an input to your DataFlow and scroll down to check the "Run DataFlow when [X] updates" for the weather dataset. You don't even have to do anything with the weather dataset in the actual dataflow, just ignore it; we're just using it for the scheduled update.

     

    Hope that helps!

Answers

  • quinnj
    quinnj Domo Employee
    Answer ✓

    Hey @Jim_Medina,

     

    I like to use a simple trick to accomplish this using the NOAA Weather connector. As you know, DataFlows can be set to run when any of their datasources update. An easy way to "schedule" a DataFlow to run at a specific time is to setup a "dummy" datasource that will update at the time you'd like the DataFlow to run.

     

    I like to use the NOAA Weather connector for this since it only requires a zip code to setup and we can leverage the connector scheduling abilities to essentially "schedule" our DataFlow.

     

    To setup the NOAA Weather connector, head to your Data Center and click the "New DataSet" button in the top right. Scroll down and select the NOAA Weather connector (not the weather alerts version). You can then put in any zip code you'd like, click "Next" and then you have the ability to schedule how often you want this connector to update (daily, weekly, every 15 minutes, etc.). Note that the time of day setting is based on UTC time, which will be 5-7 hours ahead of USA timezones.

     

    Then you simply include this new "dummy" weather dataset as an input to your DataFlow and scroll down to check the "Run DataFlow when [X] updates" for the weather dataset. You don't even have to do anything with the weather dataset in the actual dataflow, just ignore it; we're just using it for the scheduled update.

     

    Hope that helps!

  • kshah008
    kshah008 Contributor

    @Jim_Medina, did quinnj's reply help answer your question? 

  • Jim_Medina
    Jim_Medina Member

    This is an exremely klugee way to employ what is relatively basic functionality and should be a simple 'schedule time'. Apparently this functionality just doesn't exist in Domo.

     

    I'll "accept" this so I won't be annoyed with reminders to "accept":  althought it kind of answers my question the solution of acceptable.

  • Josh-REO
    Josh-REO Member

    I'm going to revive this since I haven't been able to find a more current thread, but Jim is correct, this isn't a solution.

    Has there been any progress with forcing a dataflow to run on a schedule, even if the underlying dataset hasn't changed?

  • AS
    AS Coach

    @Josh-REO A year and a half later, still no upgrade in place.  Dataflows are still only directly driven by dataset updates.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories