Custom SQL tests
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 Create Custom SQL Test
button.


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.


Updated 5 months ago
Did this page help you?