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:

General​

Choose a name for the monitor.

Query​

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.

Schedule​

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.