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, ortrueon Databricks, Databricks dbt, Fabric Lakehouse and Snowflake dbt. - A key that is missing from the load, Microsoft SQL Server: with Delete Detection Method
FullSetit gets a row with0in every load until it is delivered again. WithNoneit 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
- Reference: Delete Detection Method (Model Object), Hub_HK, BG_LoadTimestamp
- See also: Record Tracking Satellite