cubes
cubes copied to clipboard
DataBrewery
Add SchemaInspector
Add an object SchemaInspector that would inspect a database schema and would infer metadata objects:
- fact tables based on prefix/suffix/pattern:
discover_fact_tables() → List[str] - dimension tables based on prefix/suffix/pattern:
discover_dimension_tables() → List[str] - dimension keys based on pattern or other convention
- relationships based on foreign key constraints or based on naming conventions
- guess measures
Output should be used by automated model builder (the model has to go through humans anyway if is meant to be used seriously)
