Attention
This document is no longer being updated. For the most recent documentation, including the latest release notes for version 6, please refer to Documentation Version 7
Log Tables
The Datavault Builder consequently logs metadata about modelling and loading actions into different logs.
dvb_log.datavault_load_log
The log lists the historized load info of all datavault loads which were initiated at least once.
Column |
Meaning |
---|---|
load_entry_id |
Sequence ID of the log entry. |
load_entry_time |
Initiation time, when the load was sent into the loading queue. |
object_id |
Technical ID of the datavault object (hub, link or satellite). Without Schema. |
staging_table_id |
Technical ID of the staging table to load from. Including Schema. |
load_start_time |
Initiation time of the actual loading process. |
load_end_time |
End time of the load. |
load_state |
Current state of the load. |
load_result |
Result of the last load. |
load_progress |
Number of rows which have been processed within the load. |
load_total_rows |
Number of rows to process within the load. Does not have to be equal to the actual number of rows which are inserted (i.e. for hubs only new entries are added) |
login_username |
Displayed name of the initiating user. |
pg_username |
Technical user group of the initiating user. |
job_id |
Technical ID of the job within the load was initiated if applicable. |
pid |
Process ID in the core, which initiated the load. |
dvb_log.ddl_log
The log lists the historized load info of all staging loads which were initiated at least once.
Column |
Meaning |
---|---|
log_entry_id |
Sequence ID of the log entry. |
log_timestamp |
Timestamp of the log entry. |
source |
Internal category of the trigger (e.g. event_trigger, refresh). |
type |
DDL Type of the executed query (e.g. CREATE TABLE, COMMENT). |
object_id |
Technical ID of the modified object. |
login_username |
Displayed name of the initiating user. |
pg_username |
Technical user group of the initiating user. |
dvb_log.dvbuilder_creation_log
The log lists all modelling function calls executed through the datavault builder core.
Column |
Meaning |
---|---|
log_entry_id |
Sequence ID of the log entry. |
log_timestamp |
Timestamp of the log entry. |
function_call |
SQL based function call with all parameters to re-execute the modification. |
function_name |
Name of the function called in the core. |
object_id |
Technical ID of the modified object. Without Schema. |
staging_table_id |
Technical ID of the staging table if applicable. Including Schema. |
login_username |
Displayed name of the initiating user. |
pg_username |
Technical user group of the initiating user. |
dvb_log.dvbuilder_log
The log lists all SQL actions executed through the datavault builder core.
Column |
Meaning |
---|---|
log_entry_id |
Sequence ID of the log entry. |
log_timestamp |
Timestamp of the log entry. |
login_username |
Displayed name of the initiating user. |
pg_username |
Technical user group of the initiating user. |
function_name |
Name of the function called in the core. |
action |
Name of the performed action on the client database. |
action_status |
Resulting status of the execution. |
attribute_list |
List of attributes passed into the function call of the core. |
error_message |
Message of the occured error if applicable. |
query |
Actual query executed on the client database. |
explain |
Further error details if applicable. |
explain_analyze |
Further error details if applicable. |
dvb_log.job_load_log
The log lists the historized load info of all jobs which were initiated at least once.
Column |
Meaning |
---|---|
load_entry_id |
Sequence ID of the log entry. |
load_entry_time |
Initiation time, when the job was initiated. |
job_id |
Technical ID of the job. |
load_start_time |
Time, when the job started to initiate loads. |
load_end_time |
Time, when the job run finished. |
load_state |
State of the job. |
load_result |
Result of the job run. |
login_username |
Displayed name of the initiating user. |
pg_username |
Technical user group of the initiating user. |
pid |
Process ID in the core, which initiated the job. |
where_clause_parameters |
Key-Value pairs of parameters which are filled into the where clause for delta loading into staging. Stored as JSON. |
is_delta_load |
Flag, if the run was executed as delta load. |
unique_job_run_id |
Unique identifier of a specific job execution/run. |
dvb_log.login_log
The log lists the historized login info of all login attempts in the GUI.
Column |
Meaning |
---|---|
log_entry_id |
Sequence ID of the log entry. |
log_timestamp |
Timestamp of the log entry. |
login_username |
Displayed name of the user. |
pg_username |
Technical user group of the user if applicable. |
login_status |
Result of the login attempt. |
dvb_log.staging_load_log
The log lists the historized load info of all staging loads which were initiated at least once.
Column |
Meaning |
---|---|
load_entry_id |
Sequence ID of the log entry. |
load_entry_time |
Initiation time, when the load was initiated. |
staging_table_id |
Technical ID of the staging table. Including Schema. |
source_table_id |
Technical ID of the table / view in the source system. |
system_id |
Technical ID of the source system. |
load_start_time |
Time, when the load was started. |
load_end_time |
Time, when the load ended. |
load_state |
Current state of the load. |
load_result |
Last result of the load. |
load_progress |
Number of loaded rows. |
load_total_rows |
Number of rows to load. |
load_progress_percent |
Percentage processed rows in relation to total rows. |
login_username |
Displayed name of the initiating user. |
from_system_load |
Flag, if the staging load was initiated as part of a total system load in staging. |
pg_username |
Technical user group of the initiating user. |
pid |
Process ID in the core, which initiated the load. |
job_id |
Technical ID of the initiating job if applicable. |