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

dab: regenerate bundle/sql/ to match current pipeline code #221

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

Problem

208 SQL files in bundle/sql/ may be stale — generated at an unknown point in time, may not match current narwhals expression code.

Tasks

  • Run uv run python dev/scripts/gen_config.py --dab-sql to regenerate all SQL
  • Diff against existing files — identify what changed
  • Commit fresh SQL files
  • Verify transpilation tests still pass
## Problem 208 SQL files in bundle/sql/ may be stale — generated at an unknown point in time, may not match current narwhals expression code. ## Tasks - [ ] Run `uv run python dev/scripts/gen_config.py --dab-sql` to regenerate all SQL - [ ] Diff against existing files — identify what changed - [ ] Commit fresh SQL files - [ ] Verify transpilation tests still pass
kert added this to the P28: DAB Modernization — Python wheel tasks, databricks-bundles, schema cleanup milestone 2026-03-25 03:23:18 +00:00
kert commented 2026-03-25 03:28:56 +00:00
Author
Owner
Copy Link

Starting SQL regeneration. This takes ~4 minutes (transpiles all 228 expressions).

Starting SQL regeneration. This takes ~4 minutes (transpiles all 228 expressions).
kert commented 2026-03-25 03:34:43 +00:00
Author
Owner
Copy Link

Complete.

Regenerated all 208 SQL files via --dab-sql. Result: zero diff — SQL was already in sync with current pipeline code.

Note: cms_quality_measures/_error.txt is a known transpile failure (complex measure logic exceeds sqlglot capabilities). This is fine — Phase 2 eliminates SQL tasks in favor of Python wheel tasks.

✅ Verified fresh.

Complete. Regenerated all 208 SQL files via `--dab-sql`. Result: zero diff — SQL was already in sync with current pipeline code. Note: `cms_quality_measures/_error.txt` is a known transpile failure (complex measure logic exceeds sqlglot capabilities). This is fine — Phase 2 eliminates SQL tasks in favor of Python wheel tasks. ✅ Verified fresh.
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
kert renovate-bot
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: homelab/stack#221
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?