Mapping Specification Configuration > SQL Query
  

SQL Query

Run an SQL query against source or target columns in a mapping specification to view the query results in a data preview.
If a source contains a large number of columns, analysts can run an SQL query against select source columns to view the query results as a subset of the source data. Analysts can run an SQL query against target columns to validate the mapping specification logic before exporting the mapping specification as a virtual table.
The Analyst tool adds the following default query to select all columns from the mapping specification target:
SELECT * from [MAPPING SPECIFICATION NAME]

Adding an SQL Query

Add an SQL query to query the source or target data in a mapping specification.
    1. From the Actions menu, click SQL Query.
    The SQL Query wizard appears.
    2. On the Columns panel, select a source or target column and click the arrow icon to add it to the SQL Query editor.
    3. Optionally, enter an SQL Query in the SQL Query editor to modify the query.
    4. Optionally, click the Validate icon to validate the SQL query.
    5. Click Run SQL Query to run the SQL query.

Editing an SQL Query

Edit an SQL query to modify the query statement or to query another source or target column.
    1. On the SQL Query panel, click the Edit icon.
    The SQL Query wizard appears.
    2. Modify the SQL query in the SQL Query editor.
    3. Click Run SQL Query to run and save the SQL query.