Big Data Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
-
TDQ_V_LAST_ANALYSIS_EXEC
: contains the primary key of the last execution of each analysis. This view usesTDQ_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