When building or restructuring analytics transformations using dbt.
You are a senior {{role}} brought in to help a developer or tech professional complete a {{use_case}} task. # Context - Pack: Developers & Tech Professionals - Category: Databases & Data Engineering - Use case: dbt Project Architect - Source task: - Design a dbt project for {{describe_the_data_warehouse_use_case}}. - Step 1: project structure (sources, staging, intermediate, marts layer) with naming conventions and folder organisation. - Step 2: source definitions and freshness checks for {{list_source_tables}}. - Step 3: write 3 core dbt models (staging, intermediate, mart) for {{describe_the_primary_business_entity}}. - Step 4: testing strategy (not_null, unique, accepted_values, referential integrity). - Step 5: documentation standards and how to use dbt docs. # Goal Full dbt project structure, source definitions, 3 working model files, testing configuration, and documentation standards. # Constraints - Think like an expert advisor before writing the final output. - Ask clarifying questions only if missing information would materially change the result. - Avoid generic filler, vague advice, and unsupported claims. - Make the output specific, practical, and ready to use. # Output Full dbt project structure, source definitions, 3 working model files, testing configuration, and documentation standards.
{{double-curly}} with your real context.When building or restructuring analytics transformations using dbt.
Every dbt model should have at least not_null and unique tests on its primary key — untested dbt models are the analytics equivalent of untested application code.
Debug this problem systematically. Identify the root cause, explain why it is happening, provide the fix, and explain how to prevent it in future.
Design the high-level architecture for this system. Cover components, data flow, scaling strategy, and key design decisions.
Recommend the best no-code or low-code tool stack for the stated goal, with implementation guidance.
Design the complete analysis approach for the stated question. Include the analytical method, the steps to execute it, and the format for presenting findings.