homelab/stack
1
0
Fork 0
Code Issues 127 Pull Requests 1 Actions Packages Projects 1 Releases Wiki Activity

dab: filter Unity Catalog schemas to pipeline-produced only #219

New Issue
Closed
opened 2026-03-25 03:23:17 +00:00 by kert · 2 comments
kert commented 2026-03-25 03:23:17 +00:00
Owner
Copy Link

Problem

_get_catalog_schemas() returns 34 schemas from aco.table Pydantic models including 21 legacy dbt/Tuva schemas (alr, asr, ccsr, ccw, reach, ssp, etc.) not produced by any current pipeline. These get deployed as empty Unity Catalog schemas.

Tasks

  • Add pipeline_schemas() to src/aco/lake/catalog.py — derive schemas from pipeline registry output names
  • Use pipeline_schemas() in DAB generator instead of Catalog().schemas()
  • Verify: 13 schemas (one per pipeline) vs 34
  • Tests: schema list matches pipeline registry
## Problem `_get_catalog_schemas()` returns 34 schemas from `aco.table` Pydantic models including 21 legacy dbt/Tuva schemas (alr, asr, ccsr, ccw, reach, ssp, etc.) not produced by any current pipeline. These get deployed as empty Unity Catalog schemas. ## Tasks - [ ] Add `pipeline_schemas()` to `src/aco/lake/catalog.py` — derive schemas from pipeline registry output names - [ ] Use `pipeline_schemas()` in DAB generator instead of `Catalog().schemas()` - [ ] Verify: 13 schemas (one per pipeline) vs 34 - [ ] Tests: schema list matches pipeline registry
kert added this to the P28: DAB Modernization — Python wheel tasks, databricks-bundles, schema cleanup milestone 2026-03-25 03:23:17 +00:00
kert commented 2026-03-25 03:23:55 +00:00
Author
Owner
Copy Link

Starting. Will add pipeline_schemas() to catalog.py and use it in the DAB generator.

Starting. Will add `pipeline_schemas()` to catalog.py and use it in the DAB generator.
kert commented 2026-03-25 03:34:43 +00:00
Author
Owner
Copy Link

Complete.

  • Added Catalog.pipeline_schemas() — derives schemas from pipeline registry output names
  • Updated _get_catalog_schemas() in DAB generator to use pipeline_schemas()
  • Result: 13 schemas (was 34) — 21 legacy dbt/Tuva schemas dropped

✅ 112 DAB tests passed, 12,061 total.

Complete. - Added `Catalog.pipeline_schemas()` — derives schemas from pipeline registry output names - Updated `_get_catalog_schemas()` in DAB generator to use `pipeline_schemas()` - Result: 13 schemas (was 34) — 21 legacy dbt/Tuva schemas dropped ✅ 112 DAB tests passed, 12,061 total.
kert closed this issue 2026-03-25 03:34:43 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
api
REST API (FastAPI)
 auth
Authentication and authorization
 bib
Bibliography, Zotero, citations
 ci
CI/CD pipelines and Woodpecker plugins
 cli
CLI commands and UX
 cloud
Cloud provider abstraction (AWS, GCP, Azure, self-hosted)
 config
Configuration and wiring
 data
Data loading, CCLF, BCDA, seeds
 databricks
Databricks jobs and deployment
 docs
Documentation and generated references
 image:api
image:docs
image:mc
image:notebooks
image:zotero
infra
lakehouse
Nessie, Polaris, Trino, Iceberg
 llm
llm module — local RAG over comments + Zotero corpus
 notebooks
marimo notebook errors (auto-filed by nb-watcher/nb-integration)
 packaging
Python packaging, optional deps, build system
 pfs
pipeline
Pipeline execution and validation
 pipeline:ci
pipeline:deploy
pipeline:harden
pipeline:infra-ci
pipeline:rebuild-all
pipeline:release
qpp
quality
Testing, coverage, error handling
 step:build
step:deploy
step:hadolint
step:lint
step:publish
step:scan
step:test
step:validate
styles
Charts, figures, visual theming
 tree
Project directory structure and file organization
No Label
Milestone
No items
No Milestone P28: DAB Modernization — Python wheel tasks, databricks-bundles, schema cleanup
Projects
Clear projects
No project
Assignees
Clear assignees
dom kert renovate-bot
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: homelab/stack#219
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?