Testing a DSQL map

Test your mapping with a sample input file.

Before you begin

You have a sample input file in your Sample Data folder. If you created your input structure from a sample file, it should already be there. Otherwise, you can follow the steps in Adding sample data to add a sample file.

Procedure

In the DSQL Test Run view, click the button to add the input file to use for testing.
Enter the name or part of the name of the file and look for it in the Sample Data folder.
In this example, the file to use is the first result.
Select the file to use and click OK.
Click the button to run the test.

Results

In this example, the test run should return the following result:

{
   "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"
      }
   ]
}

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here