Skip to content

Step 2: Configure a Bronze Layer entity

The Bronze Layer allows you to create multiple entities from a single Landing Zone entity. This is useful for denormalized sources or nested data structures. For more information about the Bronze layer, see Bronze Layer entities.

Example

A JSON file with invoices may contain an array of invoice lines. You can split this into "Invoice Header" and "Invoice Line" Bronze entities.

Note

To add multiple Bronze Layer entities based on the same Landing Zone entity, follow the Entity Wizard for one Bronze and Silver entity, then add additional Bronze and Silver entities through the Bronze Entity page and Silver entity page.

To configure a Bronze Layer entity, provide the following details:

Source configuration

  • Pipeline: Obsolete, can be ignored.
  • File path: Automatically filled from the configured Landing Zone entity and cannot be altered in this stage.
  • File name: Automatically filled from the configured Landing Zone entity and cannot be altered in this stage.
  • Entity value: Similar to the Landing Zone entity, entity values differ per type of source. If any values are required, these will be shown in the portal. For more information about the entity values, see Entity values reference.
  • Column mappings: Use column mappings to identify columns to parse, rename if needed, and cast to the desired data type. Read more about column mappings

Target configuration

  • Lakehouse: Select the lakehouse where your data will be stored.
  • Schema: Name of the schema where the Bronze table will be stored in the lakehouse.
  • Name: Name of the table where the data will be stored.
  • Primary keys: Add the primary keys of the table. A primary key is a column (or a combination of columns) that uniquely identifies each row in a table.

Note

When column mapping is applied, use the TargetColumn instead of the SourceColumn.

Next steps