Skip to main content

Custom SQL Monitors

Create a new custom SQL monitor

Setting up a new custom SQL monitor in Datafold Cloud is straightforward. You can configure it with the following parameters and options:


Choose a name for the monitor.


Pick your connected data source and input your SQL query. Note that the query should return either:

  • Time dimension and one or more explicitly defined metrics
  • Time dimension, single metric, along with an additional GROUP BY clause

Toggle the Trigger on missing data if missing data is present in your data.


Customize the frequency and timing of monitor executions. You can choose a specific hourly or daily time in UTC, or input a crontab expression for more complex scheduling.

You can add notifications, sent through Slack or emails, which indicate whether a monitor has been executed.