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

BG_Appearance

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

BG_Appearance records whether a business key or relationship was present in a load of a record tracking satellite. Each load adds one row per key in the source, with the load timestamp as BG_ValidFromTimestamp.

Objects that carry it

Record Tracking Satellite, Record Tracking Link Satellite and Record Tracking Business Link Satellite. Every object of these types gets the term when it is created. The generator fills the value.

Value

  • A key that is in the source of the load: the Source view sets 1, or true on Databricks, Databricks dbt, Fabric Lakehouse and Snowflake dbt.
  • A key that is missing from the load, Microsoft SQL Server: with Delete Detection Method FullSet it gets a row with 0 in every load until it is delivered again. With None it gets no row.

Data type

  • Microsoft SQL Server, Fabric Warehouse: bit
  • Oracle: NUMBER(1)
  • Snowflake, Snowflake dbt: BOOLEAN
  • Databricks, Databricks dbt, Fabric Lakehouse: boolean

Example

A Record Tracking Satellite on Microsoft SQL Server tracks customer 940, with Delete Detection Method FullSet. The customer is delivered at 10:00, missing at 11:00 and 12:00, and delivered again at 13:00:

Hub_HK (shortened)  BG_ValidFromTimestamp    BG_Appearance
0xE50BE2BB...       2026-10-27 10:00 +00:00  1
0xE50BE2BB...       2026-10-27 11:00 +00:00  0
0xE50BE2BB...       2026-10-27 12:00 +00:00  0
0xE50BE2BB...       2026-10-27 13:00 +00:00  1

With Delete Detection Method None, the same loads give only the rows of 10:00 and 13:00.

Related articles