Scheduling a query

The default for every newly created query is no scheduling, meaning that it only runs when you click on Execute.

Obviously, that scenario is not good for non-static dashboards, such as dashboards that can be used for monitoring. There, we would like to have auto-refresh enabled.

To do this, we must enable scheduling for the query.

When you locate the query you wish to schedule, look at the bottom left part to find the scheduling information:

The Never word is clickable, and will show you the scheduling popup (titled Refresh Schedule), which has two selectors. One says No Refresh and the other has a time selection option:

There are two scheduling options:

  • Once a day, at specific time
  • Every X minutes (hours, days)

If we want periodical scheduling, click on the No Refresh option, and you will see a pop-up menu of all the possible intervals:

If you want a specific time once a day, select the clock option, and set it to the hour you wish.

For example, in the following screenshot, I set the query to run once a day at 01:25 (1:25 AM). The time zone is the time zone of the computer where Redash runs:

After the scheduler is set, Redash will execute that query automatically according to your settings.

Parametrized scheduled queries will use default values when performing the scheduled run.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset