Getting a report identifier from the data mart - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
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-13
Available in...

Big Data Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

Procedure

  1. Open the Data Explorer perspective in the Studio.
  2. In the Connections view, right-click a database connection and select New SQL Editor.

    • If you want the identifier of one report, enter the following SQL query in the editor:
      use <datamart database name>;
      /* get report UUID */ 
      select  REP_UUID, REP_LABEL  from tdq_analysis where REP_LABEL = '<report name>';
      Important: Use the exact data mart and report names in the query.
    • If you want the identifier of several reports, enter the following SQL query in the editor:
      use talend_dq61;
      /* get report UUID */ 
      select  REP_UUID, REP_LABEL  from tdq_analysis where REP_LABEL like 'c%' 

      In this example, you want to access the talend_dq61 data mart and get the identifiers of all the reports which start with the letter c .

  3. Execute the SQL query.

Results

The data explorer outputs the report names and their identifiers, three in this example.

What to do next

Use the identifiers in another SQL query to delete the reports.