validate-and-build

Name: validate-and-build
Author: Reguram

Compile and build the current dbt model, report results and fix any errors

by Reguram(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Prompt file imported from Reguram/snowflake-dbt-starter-kit (.github/prompts/validate-and-build.prompt.md). Copyright stays with the author.

Validate and Build

Compile and build the currently open dbt model (or the model I specify).

What to do:

Run dbt compile --select <model> to check for compilation errors
If compilation fails, diagnose and fix the issue
Run dbt build --select <model> --quiet to materialize + run tests
If build fails:
- Read the error message
- Check target/run_results.json for details
- Diagnose the root cause (SQL error, test failure, permission issue)
- Suggest a fix
If build succeeds:
- Report pass/fail counts for tests
- Show execution time for slowest steps
- Run dbt show --select <model> --limit 5 to preview results

Use the run_dbt_command MCP tool if available, otherwise run CLI commands directly.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

# Validate and Build

Compile and build the currently open dbt model (or the model I specify).

## What to do:
1. Run `dbt compile --select <model>` to check for compilation errors
2. If compilation fails, diagnose and fix the issue
3. Run `dbt build --select <model> --quiet` to materialize + run tests
4. If build fails:
   - Read the error message
   - Check `target/run_results.json` for details
   - Diagnose the root cause (SQL error, test failure, permission issue)
   - Suggest a fix
5. If build succeeds:
   - Report pass/fail counts for tests
   - Show execution time for slowest steps
   - Run `dbt show --select <model> --limit 5` to preview results

Use the `run_dbt_command` MCP tool if available, otherwise run CLI commands directly.

Manifest

The prompt text and its fill-in variables. Copy it or fetch it by URL from your own code.

reguram-snowflake-dbt-starter-kit-validate-and-build-prompt.prompt.jsonjson

{
  "prompt": "# Validate and Build\n\nCompile and build the currently open dbt model (or the model I specify).\n\n## What to do:\n1. Run `dbt compile --select <model>` to check for compilation errors\n2. If compilation fails, diagnose and fix the issue\n3. Run `dbt build --select <model> --quiet` to materialize + run tests\n4. If build fails:\n   - Read the error message\n   - Check `target/run_results.json` for details\n   - Diagnose the root cause (SQL error, test failure, permission issue)\n   - Suggest a fix\n5. If build succeeds:\n   - Report pass/fail counts for tests\n   - Show execution time for slowest steps\n   - Run `dbt show --select <model> --limit 5` to preview results\n\nUse the `run_dbt_command` MCP tool if available, otherwise run CLI commands directly.",
  "variables": [],
  "notes": "Compile and build the current dbt model, report results and fix any errors",
  "metadata": {
    "source": {
      "provider": "github-prompts",
      "repository": "https://github.com/Reguram/snowflake-dbt-starter-kit",
      "path": ".github/prompts/validate-and-build.prompt.md",
      "ref": "549a5edc67c7d995a2dcf2ec11ad2f00546c64a5",
      "url": "https://github.com/Reguram/snowflake-dbt-starter-kit/blob/549a5edc67c7d995a2dcf2ec11ad2f00546c64a5/.github/prompts/validate-and-build.prompt.md",
      "key": "Reguram/snowflake-dbt-starter-kit/.github/prompts/validate-and-build.prompt.md"
    }
  }
}

Fetch it by URL: GET /api/v1/registry/reguram-snowflake-dbt-starter-kit-validate-and-build-prompt/manifest?version=1.0.0

About

Validate and Build

What to do:

Use it

Manifest

Reviews