Previewing data in the SQL editor - Cloud

Talend Cloud Data Management Platform Studio User Guide

EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Management Console
Talend Studio
task
Design and Development
After you create a connection to a database, you can open a view in Talend Studio to see actual data in the database.

Before you begin

A database connection is created in the Profiling perspective of Talend Studio.

Procedure

  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 Talend Studio listing the data in the selected table.
  3. Optional: If required, do any modifications in the query and save it.

Results

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