Schedule your queries to run any time and automate your reporting. This feature is only available to Premium Team users.
To schedule your query, look for the
Schedule Query button under the name of your query.
That will open the scheduler modal:
Run Against, choose your database connection. You can only schedule queries against a cloud connection.
Run On, you can schedule a query to run once at a specific day/time, or you can have it repeat every hour, day, week, etc.
Next Rungives you a preview of when PopSQL will run your query.
If your query has variables, you'll see a
Variables tab where you can create specify the value PopSQL should use when it runs your query. Multiple people can create multiple schedules with their own variable values. For example, your account managers might want to schedule the same query to run every morning, but with a different
Notifications tab, you can specify when PopSQL should notify you about the scheduled query.
By default, the notification email will contain a link to view the CSV. This link can only be accessed by members of your organization. However, you can optionally include the CSV as an attachment of the email: