SQL tests let you write bespoke tests that fit your business circumstances and can be run on any table tracked by Synq through a unified workflow.

Example—An SQL test runs a query to check for rows where the workspace is null. If any rows match the test, it will throw an error

Creating a SQL test

  • Head to the Health overview

  • In the SQL tests section, click Add sql test

  • Select the connection to execute your SQL query

  • Specify a SQL query. The test is considered a success if it returns zero records. If any records are returned, the test will trigger an error, and the failed records will be stored for auditing purposes.

  • Choose a schedule (hourly/daily) and a time (hh: mm) when you want the test to run.

Running an excessive amount of tests or running a test too often will impact your data warehouse costs. Avoid running tests more often than needed

  • The confirmation page will show you a summary of the setup. To make it easier to locate in the Synq UI, you can give the test a human-friendly name.

Editing a SQL test

  • Head to the Health overview

  • Click on SQL tests to see all your SQL tests

  • Select the SQL test you want to edit by clicking on it

  • In the popout, navigate to the settings tab. Click Edit under SQL test configurations to edit the name, run schedule, or SQL code. To delete the test, click Delete SQL test