dbt_show
Preview data transformation results from a specific dbt model without materializing it. Use this tool to inspect, debug, or demonstrate processed data in JSON or other formats. Ideal for AI-driven analysis and verification.
Instructions
Preview the results of a model. An AI agent should use this tool when it needs to preview data from a specific model without materializing it. This helps inspect transformation results, debug issues, or demonstrate how data looks after processing without modifying the target database.
    Returns:
        Output from the dbt show command, defaulting to JSON format if not specified
    
Input Schema
| Name | Required | Description | Default | 
|---|---|---|---|
| limit | No | Limit the number of rows returned | |
| models | Yes | Specific model to show. For model references, use standard dbt syntax like 'model_name'. For inline SQL, use the format 'select * from {{ ref("model_name") }}' to reference other models. | |
| output | No | Output format (json, table, etc.) | json | 
| profiles_dir | No | Directory containing the profiles.yml file (defaults to project_dir if not specified) | |
| project_dir | No | ABSOLUTE PATH to the directory containing the dbt project (e.g. '/Users/username/projects/dbt_project' not '.') | . | 
Input Schema (JSON Schema)
{
  "properties": {
    "limit": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Limit the number of rows returned",
      "title": "Limit"
    },
    "models": {
      "description": "Specific model to show. For model references, use standard dbt syntax like 'model_name'. For inline SQL, use the format 'select * from {{ ref(\"model_name\") }}' to reference other models.",
      "title": "Models",
      "type": "string"
    },
    "output": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": "json",
      "description": "Output format (json, table, etc.)",
      "title": "Output"
    },
    "profiles_dir": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Directory containing the profiles.yml file (defaults to project_dir if not specified)",
      "title": "Profiles Dir"
    },
    "project_dir": {
      "default": ".",
      "description": "ABSOLUTE PATH to the directory containing the dbt project (e.g. '/Users/username/projects/dbt_project' not '.')",
      "title": "Project Dir",
      "type": "string"
    }
  },
  "required": [
    "models"
  ],
  "title": "dbt_showArguments",
  "type": "object"
}