Testing a DSQL map
The Test Run feature in DSQL maps allows you to preview
and validate the results of your mapping.
Before you begin
Testing a DSQL map with a single input and output
Test your mapping with a single sample input file.
Procedure
Results
{
"items":[
{
"make":"MBIKE",
"description":"27.5 inch electric mountain bike",
"price":"899.99 USD"
},
{
"make":"EBIKE",
"description":"Electric hybrid bike",
"price":"999.99 USD"
},
{
"make":"WBIKE",
"description":"Women's road bike",
"price":"299.99 USD"
}
]
}
Testing an element in a DSQL map
Test a specific element of your mapping with a single sample input file. You
can either select a specific main element, an unrolled element or a split
element.
Procedure
Results
{
"items":[
{
"description":"27.5 inch electric mountain bike",
},
{
"description":"Electric hybrid bike",
},
{
"description":"Women's road bike",
}
]
}
Viewing a DSQL map with multiple outputs
When your mapping uses multiple outputs, the Test Run view displays multiple output tabs when you execute a test run. For example, if you have a mapping with two JSON files used as outputs as follows:

Results
- When you click
Execute Test Run to run the test, the test run returns multiple output tabs as follows:
Information noteNote: You can also store the results on the file system by clicking
Execute Test Run to File. You need to select the
directory in which you want to store the results. Each output is then stored
separately with a name automatically given from the path of the output
elements.
Viewing a DSQL map with multiple inputs
When your mapping uses multiple inputs, the Test Run view displays multiple input tabs. For example, if you have a mapping with two JSON files used a inputs, as follows:

Results
- In the Test Run view, you can find multiple input
tabs which each corresponds to the input structure. For example, if your
structure contains two inputs, there are two tabs, as follows:
Information noteTip: When you right-click the structure, you can click Show
sample file to open a preview of the input data.