Views on column analysis results - 6.1

Talend Data Fabric Studio User Guide

EnrichVersion
6.1
EnrichProdName
Talend Data Fabric
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio
  • TDQ_V_LAST_ANALYSIS_EXEC: contains the primary key of the last execution of each analysis. This view uses TDQ_V_ALL_RUN_ANALYSIS

  • TDQ_V_ALL_RUN_ANALYSIS: contains all analysis primary keys with the calendar time

  • TDQ_V_LAST_RUN_ANALYSIS: contains the primary key of the last execution of each analysis alongside with the time execution information and the foreign keys to calendar and time dimensions

  • TDQ_V_IND_HISTO: contains all historized values of indicator computations on column analysis alongside all readable information such as labels from all the dimensions

Detailed description of views:

TDQ_V_LAST_ANALYSIS_EXEC

  • ANALYSIS_PK: foreign keys to the analysis dimension tables

  • LAST_RUNTIME: count of last version of the analyzed element

TDQ_V_ALL_RUN_ANALYSIS and TDQ_V_LAST_RUN_ANALYSIS

  • ANALYSIS_PK: foreign keys to the analysis dimension table

  • CAL_PK: foreign keys to the execution date of the analysis

  • TIME_PK: foreign keys to the execution time of the analysis

  • AN_RUNTIME: execution date of the analysis

TDQ_V_IND_HISTO

  • REP_UUID: report identifier

  • AN_UUID: analysis identifier

  • REP_LABEL: report name

  • AN_CREATION_DATE: analysis creation date

  • AN_AUTHOR: analysis author

  • AN_DATA_FILTER: analysis data filter

  • REP_CREATION_DATE: report creation date

  • REP_AUTHOR: report author

  • REP_STATUS: report status

  • ELT_UUID: identifier of analyzed element

  • ELT_CONNECTION_UUID: connection identifier

  • ELT_CONNECTION_NAME: connection name

  • ELT_CATALOG_NAME: catalog name

  • ELT_SCHEMA_NAME: schema name

  • ELT_TABLE_NAME: table name

  • ELT_COLUMN_NAME: column name

  • IND_UUID: indicator identifier

  • IND_LABEL: indicator label

  • IND_CATEG_UUID: identifier of category

  • IND_CATEGORY: category of identifier

  • INO_REGEXP: regular expression

  • CAL_DATE: date

  • TIME_HOUR: hour (0-23)

  • TIME_MINUTE: minutes (0-59)

  • RUN_TIME: execution date of the analysis

  • INDV_INT_VALUE: integer value of indicator

  • INDV_ROW_COUNT: total row count when evaluating the indicator