Skip to content
  • There are no suggestions because the search field is empty.

BG_ErrorDescription

Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Data Store · Data Vault · Dimensional

BG_ErrorDescription holds the text of the data quality rule that a row hit. Each Error table entry names one rule, so a row that hits two rules has two entries.

Objects that carry it

The Error table of Store Entity, Entity, Fact and the Hub, Link and satellite types of Data Vault, which exists when data quality rules apply to the object. You do not map it; the generator fills it.

Value

The text is fixed per rule. Placeholders in angle brackets stand for the names of the model:

  • Duplicated business keys
  • Nulled non-nullable business key "<term name>"
  • Newer version already loaded
  • Missing foreign key value for relation to "<model object name>"

Rows of the Error table are linked to the DataQuality table through BG_DataQuality_ID and BG_LoadTimestamp. Whether a rule excludes the row is shown by BG_ErrorCount.

Data type

  • Microsoft SQL Server: nvarchar(4000)
  • Fabric Warehouse: varchar(4000)
  • Oracle: VARCHAR2(4000)
  • Snowflake, Snowflake dbt: VARCHAR(4000)
  • Databricks, Databricks dbt, Fabric Lakehouse: string

Example

An Entity on Microsoft SQL Server checks the foreign key to the Entity common_loyaltycard_scd1. Row 4 of a load references the card 999, which does not exist:

BG_DataQuality_ID  BG_ErrorCount  BG_ErrorDescription
4                  0              Missing foreign key value for
                                  relation to "common_loyaltycard_scd1"

The rule only records the row, so the row is still loaded and references the unknown member.

Related articles