Claude Prompts for Analytics Engineering in Data & Analytics

5 copy-ready prompts for Analytics Engineering professionals.

Plan data quality tests for a new pipeline

Produce a tiered data quality test plan for a new ingest or pipeline — covering source freshness, schema, volume, and business-logic checks without over-testing.

data-qualitytestingdbt

Generate dbt model documentation from SQL

intermediate

Take a dbt model's SQL and generate the schema.yml description, column docs, and recommended tests an analytics engineer would actually approve.

dbtdocumentationschema-yml

Write a rigorous metric definition spec

advanced

Produce a metric definition spec for a metrics layer (LookML, Cube, dbt Semantic Layer, MetricFlow) that closes the ambiguity that causes downstream disagreement.

metrics-layersemantic-layerdata-modeling

Propose naming conventions for a semantic layer

intermediate

Produce a naming convention spec for tables, columns, metrics, and dimensions in a semantic layer or dbt project — covering prefixes, casing, and the awkward edge cases.

naming-conventionssemantic-layerdbt

Review and propose refactors for a SQL query

intermediate

Produce a structured review of a SQL query — correctness, readability, performance, and dbt-fitness — with concrete refactor suggestions.

sqlcode-reviewrefactor

Need help building these into your workflow?

Book a call