The augmented medallion architecture - Parametrization layer

The Parametrization layer - The configuration in the hands of the business (and technical teams)

The main purpose of this layer is to have an independent layer dedicated to parametrization at the hands of business or technical users

Characteristics of the layer

• Configuration
  • The configuration
• Versioning & Auditability
  • This layer should maintain the full history of the data to enable auditability and root cause analysis.
• At the hands of business and technical owners
  • This separate layer has a dedicated governance strategy and is managed by business and technical owners
• Allowed Data Structures
  • Structured
• Granularity of data
  • The data should be detailed at the level requiring the parametrization
• Useful metadata information
  • The user responsible for the last modification on the record
  • The last modification timestamp on the record

Good practices

The parametrization layer should be versioned, to keep track of all the changes, including the people who applied the changes. Using a SCM tool like Git can facilitate the tracking, as well as tracking deployment of parametrization changes across environments.

Examples

Example of a parameter table for referential transposition (for Silver layer)

Here is an example of a parameter table to transpose the source manufacturers provided into the standard manufacturer referential.

Parameter Table - Manufacturer Transposition

In this example, many different manufacturer names can be provided in the source for HP.

This table can be used in the Silver layer to clean any manufacturer name field.

Example of a parameter table with business logic (for Gold layer) - 1

Here is an example of a parameter table to indicate when data is available in the ERP per domain on all the subsidiaries and thus when data is pertinent.

Parameter Table - Subsidiaries

In this example, we can see that the External Company has been configured with sales data available since January 1st, 2023 but with finance data only available a year later on January 1st, 2024.

This table can be used in the Gold layer to prevent any load of finance data for the external company as it might not be relevant.

Example of a parameter table with business logic (for Gold layer) - 2

Here is an example of a parameter table to convert currencies.

Parameter Table - Currency conversion

This table can be used in the Gold layer to convert currency amounts.

This article is part of a series of article describing the augmented medallion architecture.