Previewing data in the SQL editor - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio
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. For further information, see Connecting to a database.

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.