Unify and manage your data

Expanded column datasets for Databricks Delta Lake

Learn about the Expanded column datasets for Databricks Delta Lake.

Expanded column

This table lists the fields in this Delta Lake storage raw table.

FieldData TypeDescription
attributesSTRUCTAll the attributes of the entity
analyticsAttributesSTRUCTAll the analytical attributes of the entity

RDM lookup attribute type normalization

Attributes that have a lookupCode defined (pointing to an RDM lookup type) are always represented as String in schema.json and in Databricks datasets, regardless of the attribute's original type in the L3 model.

For example:

  • AgeRDM (original type: Integer, with lookupCode) → exported as value:string
  • AgeNonRDM (original type: Integer, no lookupCode) → exported as value:long

In addition to the resolved value, materialized views also include:

  • lookupCode — the standardized code from the RDM lookup
  • lookupRawValue — the raw incoming value before resolution