Standard Satellite

Standard Satellite (aka standard_satellite)

This table is all about defining the standard satellites linked to a parent hub or link within your Data Vault. Here you configure the names of the satellites, the names of the columns and where to find them within the source.

Columns

The following columns are required in the table/worksheet called "standard_satellite" inside your metadata:

Name	Explanation
Satellite_Identifier	A globally unique identifier of a satellite.
Target_Satellite_Table_Physical_Name	The name of this satellite object. Will be used for naming the generated satellite model.
Source_Table_Identifier	The global identifier of the source. Used to create a relation between satellite and source.
Source_Column_Physical_Name	The physical name of the column in the source data.
Parent_Identifier	The unique identifier of the Hub or Link entity defined in the metadata
Parent_Primary_Key_Physical_Name	The physical name of the primary key/hash key from the parent hub or link.
Target_Column_Physical_Name	The physical name of the column in the satellite.
Target_Column_Sort_Order	The position of the column in the sort order for hashdiff generation.
Group_Name(optional)	Defines to which business object group this entry belongs, used for the folder structure of the dbt models as well as the visualization of the entities.

Example Satellite Hub

See the following example values for each column. In total, they describe the satellite "solution_data_sfdc_lrn_s" from the parent hub "solution_h".

Satellite_Identifier	Target_Satellite_Table_Physical_Name	Source_Table_Identifier	Source_Column_Physical_Name	Parent_Identifier	Parent_Primary_Key_Physical_Name	Target_Column_Physical_Name	Target_Column_Sort_Order	Group_Name
S0001	solution_data_sfdc_lrn_s	SRC0001	IsDeleted	H001	hk_solution_h	IsDeleted	1	Solution
S0001	solution_data_sfdc_lrn_s	SRC0001	SolutionName	H001	hk_solution_h	SolutionName	2	Solution
...	...	...	...	...	...	...	...	...
S0001	solution_data_sfdc_lrn_s	SRC0001	Encryption_Key__c	H001	hk_solution_h	Encryption_Key__c	17	Solution

Example Satellite Link

See the following example values for each column. In total, they describe the satellite "solution_data_sfdc_lrn_ls" from the parent link "solution_data_sfdc_lrn_l".

Satellite_Identifier	Target_Satellite_Table_Physical_Name	Source_Table_Identifier	Source_Column_Physical_Name	Parent_Identifier	Link_Primary_Key_Physical_Name	Target_Column_Physical_Name	Target_Column_Sort_Order	Group_Name
S0002	solution_data_sfdc_lrn_ls	SRC0001	IsDeleted	L001	hk_solution_data_sfdc_l	IsDeleted	1	Group_Name
S0002	solution_data_sfdc_lrn_ls	SRC0001	SolutionName	L001	hk_solution_data_sfdc_l	SolutionName	2	Group_Name
...	...	...	...	...	...	...	...	...
S0002	solution_data_sfdc_lrn_ls	SRC0001	Encryption_Key__c	L001	hk_solution_data_sfdc_l	Encryption_Key__c	17	Group_Name