borghei/Claude-Skills / data-analytics/analytics-engineer
analytics-engineer
VerifiedAnalytics engineering across data modeling, dbt, transformation, and semantic layers. Use when building dbt models, designing star schemas, writing staging or mart SQL, configuring data tests, or optimizing warehouse queries.
| File | Kind | Size |
|---|---|---|
| REFERENCE.md | markdown | 4.2 KB |
| SKILL.md | skill md | 13.4 KB |
| assets/dbt_project.yml | config | 1.1 KB |
| assets/macros.sql | other | 1.5 KB |
| assets/schema.yml | config | 1.4 KB |
| assets/source.yml | config | 1.0 KB |
| references/dbt_style_guide.md | markdown | 2.7 KB |
| references/modeling_patterns.md | markdown | 3.2 KB |
| references/optimization.md | markdown | 3.0 KB |
| references/testing_guide.md | markdown | 2.4 KB |
| scripts/doc_generator.pyexecutable | script | 3.2 KB |
| scripts/impact_analyzer.pyexecutable | script | 3.5 KB |
| scripts/quality_scorer.pyexecutable | script | 3.9 KB |
| scripts/schema_diff.pyexecutable | script | 4.0 KB |
scripts/doc_generator.py
View on GitHub#!/usr/bin/env python3
import argparse
import json
import os
import sys
def parse_args():
parser = argparse.ArgumentParser(description="Generate markdown documentation from dbt manifest/catalog.")
parser.add_argument("--model", required=True, help="Model name to generate documentation for")
parser.add_argument("--manifest", default="target/manifest.json", help="Path to manifest.json")
parser.add_argument("--catalog", default="target/catalog.json", help="Path to catalog.json (optional)")
return parser.parse_args()
def load_json(path):
if not os.path.exists(path):
return {}
with open(path, 'r') as f:
return json.load(f)
def generate_markdown(manifest, catalog, model_name):
# Find model in manifest
model_node = None
for node_id, data in manifest.get("nodes", {}).items():
if data.get("name") == model_name and data.get("resource_type") == "model":
model_node = data
break
if not model_node:
print(f"Error: Model {model_name} not found.", file=sys.stderr)
sys.exit(1)
description = model_node.get("description", "No description provided.")
columns = model_node.get("columns", {})
depends_on = model_node.get("depends_on", {}).get("nodes", [])
# Try to overlay types from catalog
cat_node = None
for cat_id, data in catalog.get("nodes", {}).items():
if data.get("metadata", {}).get("name") == model_name:
cat_node = data
break
md = [f"# Model: `{model_name}`\n"]
md.append(f"**Description:** {description}\n")
md.append("## Dependencies")
if depends_on:
for dep in depends_on:
dep_name = dep.split('.')[-1]
md.append(f"- `{dep_name}`")
else:
md.append("*No dependencies*")
md.append("\n")
md.append("## Column Dictionary")
md.append("| Column Name | Type | Description | Tests |")
md.append("|---|---|---|---|")
for c_name, c_data in columns.items():
desc = c_data.get("description", "")
# Get tests
tests = []
for child_id in manifest.get("child_map", {}).get(model_node["unique_id"], []):
if child_id.startswith("test."):
child_data = manifest.get("nodes", {}).get(child_id, {})
if child_data.get("column_name") == c_name:
test_type = child_data.get("test_metadata", {}).get("name", child_id.split(".")[-1])
tests.append(test_type)
test_str = ", ".join(tests) if tests else "none"
c_type = "UNKNOWN"
if cat_node and c_name in cat_node.get("columns", {}):
c_type = cat_node["columns"][c_name].get("type", "UNKNOWN")
md.append(f"| `{c_name}` | `{c_type}` | {desc} | {test_str} |")
return "\n".join(md)
def main():
args = parse_args()
manifest = load_json(args.manifest)
catalog = load_json(args.catalog)
if not manifest:
print(f"Error: Manifest not found at {args.manifest}", file=sys.stderr)
sys.exit(1)
md = generate_markdown(manifest, catalog, args.model)
print(md)
if __name__ == "__main__":
main()
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the work | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation code | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy. | Stars: 197k | Updated | Claude CodeCodex | Verified | Install |