Filtering tables/views in a database connection - 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

You can filter the tables/views to list under any database connection.

This option is very helpful when the number of tables in the database to which Talend Studio is connecting is very big. If so, a message is displayed prompting you to set a table filter on the database connection in order to list only defined tables in the DQ Repository tree view.

Before you begin

A database connection is created in the Profiling perspective.

Procedure

  1. In the DQ Repository tree view, expand Metadata.
  2. Expand the database connection in which you want to filter tables/views and right-click the desired catalog/schema.
  3. Select Table/View Filter to display the corresponding dialog box.
    Example of values in the Table Filter and View Filter fields.
  4. Set a table and a view filter in the corresponding fields and click Finish to close the dialog box.

Results

Only tables/views that match the filter you set are listed in the DQ Repository tree view.