PromptsVault AI is thinking...
Searching the best prompts from our community
ChatGPTMidjourneyClaude
Searching the best prompts from our community
Click to view expert tips
Specify framework versions
e.g., 'Next.js 14', 'Python 3.11' for accurate, up-to-date code
Request error handling & types
Ask for TypeScript definitions and try-catch blocks
Get step-by-step breakdowns
Request explanations before code for complex logic
Design a dbt (data build tool) project for analytics engineering. Structure: 1. Staging models (raw data cleaning). 2. Intermediate models (business logic transformations). 3. Mart models (final aggregated tables). 4. Tests for data quality (unique, not_null, relationships). 5. Documentation with schema.yml and descriptions. Implement incremental models for large tables and use Jinja macros for reusable logic. Include CI/CD integration.