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.