--- title: "Exercise 8: Converting a Standard Test" slug: "exercise-8-convert-a-standard-test-to-a-template" description: "Training exercise to learn how to convert standard tests into templates to ramp up automation." updated: 2024-07-08T14:01:34Z published: 2024-07-08T14:01:34Z canonical: "docs.validatar.com/exercise-8-convert-a-standard-test-to-a-template" --- > ## 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 8: Convert a Standard Test to a Template Learning Goals - How do I apply a test at scale? - What is a Validatar Template test? - What does metadata driven mean? - How do I make child tests differ from each other? - How do I use the Template Builder? #### Step 1 - Copy and Convert a Standard Test to a Template - Open the Row Count Test from Exercise 5 - Copy the test - Convert to Template Test ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2870%29.png) #### Step 2 - Review and Update Template Test Structure - Review what parts of the Standard Test have been replaced by {{schema.name}} and {{table.name}} placeholders. - Update the Compare to Table from STAGING.S_DIM_PAYER_10 to STAGING.S_DIM_{{table.name}}_10 - Update the metadata link to STAGING.S_DIM_{{table.name}}_10 ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2871%29.png) #### Step 3 - Add other RAW tables to the Metadata Selection - Go to the Metadata Selection tab - Add additional Tables that follow the same pattern and should have their row counts check similarly - Save your test ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2872%29.png) #### Step 4 - Materialize Child Tests and then Run - Click Materialize Child Tests - Confirm the counts make sense - Run Child Tests and see all your individual tables get tested using the same pattern ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2873%29.png) ![image.png](https://cdn.document360.io/a80bc2a3-87d3-4dc2-9244-a16f33ed193c/Images/Documentation/image%2874%29.png) #### Tips About Validatar - Converting a Standard Test to a Template Test helps the user understand the template framework. - Metadata selection is how to choose which objects this template applies to. - Materializing Child Tests is simply creating or updating tests created from a Template.