How do I schedule my queries to run every hour or day?

Queries and Resources
1

A common use case we see in Retool apps is scheduling queries to run every time period (an hour, a day, a week, etc.). Retool supports periodically running queries, with two important caveats (for now):

  1. Retool natively supports running queries periodically while your app is open, but not while it's closed.

In your query, head over to the advanced tab and you should see a checkbox titled "Run this query periodically?"

image
image3176×594 66.8 KB

Once you check the box, you'll be able to enter a period interval (in milliseconds) in the "Period interval" form. If we want the query to run every 10 minutes, put 10,000 in the form:

image
image3176×594 67.6 KB

This scheduling only works while your app is open. So if you close the app, the query will not run every 10 minutes.

  1. Running queries periodically doesn't work for Javascript queries.

Periodic query runs are only currently only supported for non-Javascript queries (i.e. everything else).

7 Likes
2

I wonder, any plans for supporting this with JS queries? Is it a performance issue?

E.g I tried building a moment.js clock query linked to a text block, where the periodic run would’ve been useful.

3

@roland no plans yet, but I've put in a ticket to start thinking about it / working on it. I'll post in this thread and tag you when it gets built :slight_smile:

5 Likes
4

plus one for this feature

2 Likes
5

It would be great if I didn’t have to keep the app open

2 Likes
6

I agree… the scheduler is nice but it really needs to be able to run while not logged in and running. Meanwhile the product is nice and easy to use

3 Likes
7

Any update on this @justin ?

I am keen to trigger slack notifications in the background, it was mentioned on the integrations page. I created this thread before I saw this one:

1 Like
8

I am also interested in the ability to schedule queries without the app open. Our use case is using Retool as a dashboard. We would like to run all of the Redshift queries, which can be quite slow, in the background overnight, so that they are already cached when the user loads the page.

We use this feature heavily in Mode Analytics, which is what we are looking to migrate from.

Thanks!

9

Hey everyone! One of our engineers is working on building this this sprint :slight_smile: Don’t have a concrete ship date, but it should be within the near term. If anyone has ideas on what it should look like beyond what in the thread, feel free to message me at justin@retool.com!

10

Any idea when this is going to be developed and released? I’m interested in triggering timed queries on a cadence as well!

11

Any chance this is going to be a feature? Would be an awesome upgrade if it could run without the app being open.

1 Like
12

Hi @ilsemaj and @seandawes! We're working on this for Q4 this year 😊

4 Likes
13

@justin I see you said someone was working on periodic Javascript queries last November. Did this ever get built? I could really use this; I'd like to show warnings when tokens are about to expire or a certain time-of-day is coming up.

As an ugly workaround, I'm using a periodic REST query to a gibberish domain that's guaranteed to fail and adding my actual JS query in the "On Failure" chain.

14

@victoria Is this still scheduled for Q3 release? Thanks!

16

@teamrappid There isn't an official release timeline yet, but it's being worked on now! :blush:

4 Likes
17

Hi, community! For anyone who is following this thread, we are fast approaching our early access program for this feature.

While I believe I reached out to everyone who has commented until now, if you're interested in participating (or even just chatting with our engineers and seeing a demo), feel free to message me here or reach out via email at kiersten@retool.com. Thank you all for your continued engagement!

3 Likes
18

I'm waiting for this feature.

1 Like
19

I would be highly interested to see a demo or recorded video. What is the planned release timeline?

Best,
-Arun

20

Uuuh that would be gold. Will JS queries be included?

1 Like
21

@arunava, @minijohn, and @JHLee – just messaged you all! Looking forward to connecting.

1 Like