# Getting started with DSQL maps

Create a simple DSQL map and test it with sample data.

## Before you begin

* You have created an input and an output structure. You can use the JSON samples below to create your structures.
* You have set the Map Lines preference in Window > Preferences > Mapping to All Elements.

## About this task

In this example, you will create a simple DSQL map to extract and filter data about bicycles for sale in a shop. The input data looks like this:

```
{
   "store":"Bikes and Scoots",
   "address":{
      "street":"47 High St",
      "city":"Linlithgow",
      "zip":"75858",
      "phone":"713 844445"
   },
   "categories":[
      {
         "category":"bicycles",
         "items":[
            {
               "make":"MBIKE",
               "description":"27.5 inch electric mountain bike",
               "color":"blue",
               "price":899.99
            },
            {
               "make":"EBIKE",
               "description":"Electric hybrid bike",
               "color":"grey/green",
               "price":999.99
            },
            {
               "make":"WBIKE",
               "description":"Women's road bike",
               "color":"white",
               "price":299.99
            }
         ]
      },
      {
         "category":"scooters",
         "items":[
            {
               "make":"ESCOOT",
               "description":"Camou electric scooter",
               "color":"black",
               "price":749
            },
            {
               "make":"EVSCOOT",
               "description":"Folding electric velocity+ scooter",
               "color":"black",
               "price":599.99
            },
            {
               "make":"KSCOOT",
               "description":"24 volt kid scooter",
               "color":"white",
               "price":299.99
            }
         ]
      }
   ]
}
```

The output structure looks like this:

```
{
   "items":[
      {
         "make":"",
         "description":"",
         "price":""
      }
   ]
}
```

### In this section

* [Creating a DSQL map](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-09/creating-dsql-map)
* [Testing a DSQL map](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-09/testing-dsql-map)
* [Using a DSQL map in a Data Integration Job](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0-R2026-09/using-dsql-map-in-data-integration-job)