--- title: "Validatar Training Exercise 7: Monitor Data Over Time" slug: "exercise-7-create-a-comparison-against-previous-results" description: "Training Exercise 7 teaches you how to create a test that monitors data over time by comparing against previous test executions or profile results stored in Validatar." updated: 2024-07-08T12:44:09Z published: 2024-07-08T12:44:09Z canonical: "docs.validatar.com/exercise-7-create-a-comparison-against-previous-results" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.validatar.com/llms.txt > Use this file to discover all available pages before exploring further. # Exercise 7: Create a Comparison Against Previous Results Learning Goals - How do I monitor a table's metadata? - How does Validatar compare today vs yesterday? - How do I configure keys and values in a table result set? #### Step 1 - Create a Standard Test - Click New to create a New Standard Test - Name the Test "Column Datatype Monitoring" - Set the Quality Dimension to "Standards" - Set the Severity Level to "Low" - Give the test a nice description like "This test compares the data types of all the columns in {{table_name}} today vs the last time we ran this test." ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2868%29.png) #### Step 2 - Configure "What do you want to test?" - Set Data Source = Sample Data Source - Snowflake Data Warehouse - Set How to get the data = Column Metadata for a Table - Set the table to your assigned RAW table. - Click the Preview and Refresh Options button - Review the Previewed results - Switch to the Data Set Options tab - Update all columns to be ignored. - Then set the COLUMN_NAME to Key and the DATA_TYPE to Value ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2867%29.png) #### Step 3 - Configure "What do you want to compare to?" - Select "Previous Runs" - Set Data Source = Sample Data Source - Snowflake Data Warehouse - Set How to define the control data = Previous Test Results - Change to the Maximum of results for last 1 Run ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2866%29.png) #### Tips About Validatar - Using Test descriptions keeps your team on the same page about the contents and purpose of the test. - Changing how to get the data for a test also changes the configuration area. - You can choose to make a column a key or value or choose to ignore it in the test. - Using Previous Runs help maximize the value of tests and profiles already run in Validatar.