3. Test against reality

It is now time to test your expectations against the actual data in your database.

Set up DataConformance

While you have now defined your expectations as assertions with code, DataConformance does not yet know about them. Let's change that.

1. Sign up or log in
   1. Go to dataconformance.com
   2. Click on Start 14-day Free Trial
   3. Complete sign up process
2. Create definition
   1. Click on Definitions in main navigation
   2. Click on + Add Definition
   3. Choose a name and click on Add
   4. In form section Definition file click on Choose File and select the definition.json file generated in 2. Convert to code
   5. Click on Upload
3. Create runner and assign definition
   1. Click on Runners in main navigation
   2. Click on + Add Runner
   3. Choose a name and click on Add
   4. In form section Assigned Definitions click on + Add definition
   5. Select the previously created definition
   6. Choose your desired schedule frequency
   7. Click on Save

Set up Runner

DataConformance is now ready to run your assertions against your database, but has no way of connecting to your database. For improved security and to avoid having to expose your database to the internet, the connection is not created directly. Instead a small program called runner is used. You run it on the same server as your database or on one with access to it. Then the program receives instructions to run your assertions as desired and repots back the execution results.

Go to runner docs

Conclusion

If you have followed all steps you have defined your expectations, created a definition from those and set up DataConformance and your runner to execute them, you are ready to learn how to interpret the assertion execution results in the next step.