Previewing data in the SQL editor - 6.3

Talend MDM Platform Studio User Guide

EnrichVersion
6.3
EnrichProdName
Talend MDM Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

After you create a connection to a database, you can open a view in the studio to see actual data in the database.

Prerequisite(s): At least one database connection has been created in the Profiling perspective of the studio. For further information, see Connecting to a database.

To display a preview of actual data of a given database table, do the following:

  1. In the DQ Repository tree view, expand Metadata > DB Connections.

  2. Browse to a table in a given database connection, right-click it and select Preview.

    The SQL editor opens in the studio listing the data in the selected table.

  3. If required, do any modifications in the query and save it.

    The query is listed under the Libraries > Source Files folder in the DQ Repository tree view.