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 and business rules materialization 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.

unique_job_run_id

Unique identifier of a specific job execution/run.

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 at transaction begin.

log_current_timestamp

Current 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.

is_initial_load

Flag, if the run was an initial load.

unique_job_run_id

Unique identifier of a specific job execution/run.

triggered_by_job_id

For chained jobs, the job_id that triggered the job.

triggered_by_unique_job_run_id

For chained jobs, the unique_job_run_id that triggered the job.

advanced_properties

The advanced properties of the job if applicable.

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.

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.

unique_job_run_id

Unique identifier of a specific job execution/run.

is_delta_load

Flag, if the staging load was executed as delta load.

is_cdc_load

Flag, if the staging load was a CDC load.

is_initial_load

Flag, if the staging load was an initial load.

executed_source_query

The SQL query that was executed against the source.

query_parameters

The parameters used for this staging load.

custom_source_query_template

For custom source queries, the defined template at load time.

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.

Hint

For your convenience, there are several views in the dvb_core schema that filter and enhance these log tables. For details see Metadata Views.