# Views and their description Available in... * Big Data Platform * Data Fabric * Data Management Platform * Data Services Platform * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform Views are built on top of the PDM of Talend Data Quality. ## Views on dimensions Available in... * Big Data Platform * Data Fabric * Data Management Platform * Data Services Platform * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform * TDQ\_V\_LAST\_ANALYSIS: contains the analysis and the report identifiers with the last version number of the analysis dimension (because TDQ\_ANALYSIS is a Slowly Changing Dimension, each analysis can have several versions). * TDQ\_V\_ANALYSIS: view on the last version of the analysis data. This view uses TDQ\_V\_LAST\_ANALYSIS * TDQ\_V\_LAST\_ANALYZED\_ELEMENT: contains the analyzed element identifier alongside with the last version number of the analyzed element dimension * TDQ\_V\_ANALYZED\_ELEMENT: view on the last version of the analyzed element. This view uses TDQ\_V\_LAST\_ANALYZED\_ELEMENT * TDQ\_V\_LAST\_INDICATOR\_DEF: contains the indicator definition identifier alongside with the last version number of the indicator definition dimension * TDQ\_V\_INDICATOR\_DEFINITION: view on the last version of the indicator definition. This view uses TDQ\_V\_LAST\_INDICATOR\_DEF * TDQ\_V\_SIMPLE\_INDICS: This view filters the Simple indicators. It uses TDQ\_V\_INDICATOR\_DEFINITION Detailed description of views: TDQ\_V\_ANALYSIS, TDQ\_V\_ANALYZED\_ELEMENT and TDQ\_V\_INDICATOR\_DEFINITION have the same attributes (columns) as TDQ\_ANALYSIS, TDQ\_ANALYZED\_ELEMENT and TDQ\_INDICATOR\_DEFINITION respectively. For further information, see [Detailed description of tables](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/detailed-description-of-tables) TDQ\_V\_LAST\_ANALYSIS * AN\_UUID: analysis identifier * REP\_UUID: report identifier * LAST\_VERSION: last version of the analysis TDQ\_V\_LAST\_ANALYZED\_ELEMENT * ELT\_UUID: identifier of the analyzed element * LAST\_VERSION: last version of the analyzed element * ELT\_CTX\_GROUP\_ID: the context group id of the analyzed element * ELT\_CTX\_NAME: the context name of the analyzed element TDQ\_V\_LAST\_INDICATOR\_DEF * IND\_UUID: indicator identifier * LAST\_VERSION: last version of the identifier TDQ\_V\_SIMPLE\_INDICS * IND\_PK: primary key * IND\_UUID: indicator identifier * IND\_LABEL: indicator label * IND\_CATEGORY: indicator category. Simple indicators such as count indicators belong to the Simple category, Count subcategory. Text indicators belong to the Text category. Mean, Median, Lower quartile, upper quartile, min value, max value belong to the Summary category. Mode belong to the Advanced category and Mode subcategory. Frequency table belong to the Advanced category and Frequencies subcategory. * IND\_CATEG\_UUID: category identifier And the three historization columns: * IND\_BEGIN\_DATE * IND\_END\_DATE * IND\_VERSION ## Views on column analysis results Available in... * Big Data Platform * Data Fabric * Data Management Platform * Data Services Platform * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform * 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 ## Views on comparison analysis results Available in... * Big Data Platform * Data Fabric * Data Management Platform * Data Services Platform * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform * TDQ\_V\_ALL\_RUN\_MATCH\_ANALYSIS: contains all analysis primary keys with the calendar time * TDQ\_V\_LAST\_MATCH\_ANALYSIS\_EXEC: contains the primary key of the last execution of each comparison analysis. This view uses TDQ\_V\_ALL\_RUN\_MATCH\_ANALYSIS * TDQ\_V\_LAST\_RUN\_MATCH\_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. This view uses TDQ\_V\_ALL\_RUN\_MATCH\_ANALYSIS and TDQ\_V\_LAST\_MATCH\_ANALYSIS\_EXEC Detailed description of views: TDQ\_V\_ALL\_RUN\_MATCH\_ANALYSIS and TDQ\_V\_LAST\_RUN\_MATCH\_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\_LAST\_MATCH\_ANALYSIS\_EXEC * ANALYSIS\_PK: foreign keys to the analysis dimension tables * LAST\_RUNTIME: count of last version of the analyzed element ## Views on overview analysis results Available in... * Big Data Platform * Data Fabric * Data Management Platform * Data Services Platform * Qlik Talend Cloud Enterprise Edition * Qlik Talend Cloud Premium Edition * Real-Time Big Data Platform * TDQ\_V\_ALL\_RUN\_OVERVIEW\_ANALY: contains all analysis primary keys with the calendar time * TDQ\_V\_LAST\_OVERVIEW\_ANALY\_EXEC: contains the primary key of the last execution of each overview analysis. This views uses TDQ\_V\_ALL\_RUN\_OVERVIEW\_ANALY * TDQ\_V\_LAST\_RUN\_OVERVIEW\_ANALY: 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. This view uses TDQ\_V\_ALL\_RUN\_OVERVIEW\_ANALY and TDQ\_V\_LAST\_OVERVIEW\_ANALY\_EXEC Detailed description of views: TDQ\_V\_LAST\_RUN\_OVERVIEW\_ANALY and TDQ\_V\_ALL\_RUN\_OVERVIEW\_ANALY * 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\_LAST\_OVERVIEW\_ANALY\_EXEC * ANALYSIS\_PK: foreign keys to the analysis dimension table * Last\_RUNTIME: count of last version of the analyzed element