Previewing data in the SQL editor - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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.

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.
    Overview of the SQL editor.
  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.