Previewing data in the SQL editor - 7.1

Talend Real-time Big Data Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
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.