While Metaplane supports a number of tests out of the box, you can use custom SQL tests to monitor anything that isn't natively supported.

• If your query returns a scalar numeric value, Metaplane tracks that value over time and alerts you on an outlier.
• If your query returns a result set, Metaplane tracks the number of rows returned over time and alerts you on an outlier.

Adding a custom test

To add a custom test, you can navigate to the Data tests page, enter Edit mode, and click the Custom SQL cell.

In the custom test modal, you can enter a test name, description, and run any SQL. Metaplane will return the result set that will be tracked over time.