Displaying keys and indexes of database tables - 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 analyzing the content of a database, you can display the details of the key and user-defined index of a given table. This information can be very interesting for the database administrator.

Before you begin

At least one database content analysis has been created and executed in the Profiling perspective of Talend Studio.

Procedure

  1. In the Analysis Results view of the analysis editor, click a catalog or a schema under Statistical Information.
    All the tables included in the selected catalog or schema are listed along with a summary of their content: number of rows, keys, and user-defined indexes.
    Overview of the Statistical Information section.
  2. In the table list, right-click the table and select View keys.
    You cannot display the key details of tables in a Hive connection.
    Contextual menu of a table from the Statistical Information section.
    The Database Structure and the Database Detail views display the structure of the analyzed database and information about the primary key of the selected table.
    Database Detail and Database Structure views with information about the primary key.
  3. Optional: If one or both views do not show, select Window > Show View > Database Structure or Window > Show View > Database Detail.
  4. In the table list, right-click the table and select View indexes.
    You cannot display the index details of tables in a Hive connection.
    The Database Structure and the Database Detail views display the structure of the analyzed database and information about the user-defined index of the selected table.
    Database Detail and Database Structure views with information about the user-defined index.
  5. To display the relevant metadata about the selected table, click any of the tabs in the Database Detail view.