verify_table: Verify the data adheres to the DB schema.

In vimc/dettl: Data Extract, Transform, Test and Load

Verify the data adheres to the DB schema.

Description

Verifies that * A table with name 'table_name' exists in the DB * All the columns in 'table' exist in the DB table with name 'table_name' * Any 'additional_columns' exist in the DB table with name 'table_name'

Usage

verify_table(
  con,
  table_name,
  table,
  additional_columns = NULL,
  context_info = "",
  solution_text = ""
)

Arguments

con	The active DB connection to check the schema for.
table_name	The name of the table to check.
table	The table to check.
additional_columns	Vector of additional column names to check exist in DB table.
context_info	Info to be logged should a check fail.
solution_text	Text describing possible solution should error occur.

vimc/dettl documentation built on Oct. 6, 2022, 2:13 p.m.