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]