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.

dvb_log.deployment_log

The log lists all runs of deployment packages which were initiated at least once.

Column	Meaning
deployment_entry_time	Initiation time, when the deployment was initiated.
deployment_package_id	Unique identifier for the generated deployment package.
deployment_start_time	Time, when the deployment was started.
deployment_end_time	Time, when the deployment ended.
deployment_state	Current state of the deployment.
deployment_result	Last result of the deployment.
login_username	Displayed name of the initiating user (if available).
pg_username	Technical user group of the initiating user.
pid	Process ID in the core, which initiated the deployment.
unique_deployment_run_id	Unique identifier of a specific deployment execution/run.
modified_timestamp	Timestamp of the log entry.

dvb_log.deployment_step_log

The log lists all deployment steps executed as part of a deployment.

Column	Meaning
deployment_step_entry_time	Initiation time, when the deployment was initiated.
deployment_package_id	Unique identifier for the generated deployment package the step was derived from.
deployment_step_id	Unique identifier for the step within the deployment package.
deployment_step_start_time	Time, when the deployment step was started.
deployment_step_end_time	Time, when the deployment step ended.
deployment_step_state	Current state of the deployment step.
deployment_step_result	Last result of the deployment step.
pid	Process ID in the core, which initiated the deployment step.
unique_deployment_run_id	Unique identifier of a specific deployment execution/run.
modified_timestamp	Timestamp of the log entry.

dvb_config._dvb_runtime_deployment_package

Not exactly a log table as the content can change over time. Contains the current definition of deployment packages referenced in dvb_log.deployment_log and dvb_log.deployment_step_log.

Column	Meaning
created_timestamp	Time, when the deployment package was created.
deployment_package_id	Unique identifier for the generated deployment package.
deployment_package_creator	User which originally created the package.
deployment_content	Packed deployment package content. (check API doc on api_change_json returned from deploymentGenerateDeploymentPackage)
modified_timestamp	Timestamp of the latest package modification.