star_schema

sqllocks_spindle.transform.star_schema

Star schema transform — convert 3NF GenerationResult to fact/dim layout.

Classes

DimSpec dataclass

Specification for building one dimension table.

FactSpec dataclass

Specification for building one fact table.

StarSchemaMap

Describes how to transform a domain result into a star schema.

StarSchemaResult dataclass

Result of a star schema transform.

Methods:

all_tables()

Return all tables (dimensions + date_dim + facts) as a flat dict.

StarSchemaTransform

Transform a 3NF GenerationResult into a star schema using a StarSchemaMap.

Methods:

transform(tables, schema_map)

Apply the star schema transform.

Parameters:

Name	Type	Description	Default
tables	dict[str, DataFrame]	Dict of table_name → DataFrame (from GenerationResult.tables).	required
schema_map	StarSchemaMap	Mapping spec defining dims and facts.	required

Returns:

Type	Description
StarSchemaResult	StarSchemaResult with dimensions, facts, and date_dim.