Template: Slowly Changing Dimension Modeling
Architecture, foundation and governance
Decide how to handle attribute changes over time. Structured prompt with steps, output format, and quality criteria.
The library has been reorganized around practical application: less empty browsing, more shortcuts to sell, build and automate with AI.
Architecture, foundation and governance
Decide how to handle attribute changes over time. Structured prompt with steps, output format, and quality criteria.
Architecture, foundation and governance
Find scheduled queries that cost more than they should. A structured prompt with steps, output format, and quality crite…
Architecture, foundation and governance
Test data transformation before it goes to production. Structured prompt with steps, output format, and quality criteria…
Architecture, foundation and governance
Split documents while preserving context for retrieval. Structured prompt with steps, output format, and quality criteri…
Architecture, foundation and governance
Reprocess history without affecting current consumption. Structured prompt with steps, output format, and quality criter…
Architecture, foundation and governance
Find an expensive query and cut costs without losing analysis. Structured prompt with steps, output format, and quality …
Architecture, foundation and governance
Spot poorly designed partitioning that makes queries more expensive. Structured prompt with steps, output format, and qu…
Architecture, foundation and governance
API ingestion that fails, with retry and backoff. Structured prompt with steps, output format, and quality criteria.
Architecture, foundation and governance
Reprocess only the piece of data that changed, not everything. Structured prompt with steps, output format, and quality …
Architecture, foundation and governance
Decide how to handle attribute changes over time. Structured prompt with steps, output format, and quality criteria.
Architecture, foundation and governance
Define job order and dependencies in a complex pipeline. Structured prompt with steps, output format, and quality criter…
Architecture, foundation and governance
Choose the right format and compression for the use case. Structured prompt with steps, output format, and quality crite…
Architecture, foundation and governance
A pipeline that can run twice without duplicating data. Structured prompt with steps, output format, and quality criteri…
Architecture, foundation and governance
Automated tests that run with every data load. Structured prompt with steps, output format, and quality criteria.
Architecture, foundation and governance
Automated tests that run with every data load. Structured prompt with steps, output format, and quality criteria.
Architecture, foundation and governance
Define schema, SLA, and contract breakage. Structured prompt with steps, output format, and quality criteria.
Architecture, foundation and governance
Define schema, SLA, and contract breach handling. Structured prompt with steps, output format, and quality criteria.
Architecture, foundation and governance
Partition a large table for query performance and cost. Structured prompt with steps, output format, and quality criteri…
Architecture, foundation and governance
Find an expensive query and cut spend without losing analysis. Structured prompt with steps, output format, and quality …
Automated routine and clear handoff
A prompt to create intelligent DevOps pipelines with GitHub Actions, AI code analysis, and automatic deployment.