model-requirements

Structured requirements gathering for BigQuery models captures grain, source tables, business logic, and dependencies through stakeholder interviews. This Skill guides you through those interviews, validates dependencies against local schema, Glean Dictionary, and DataHub, then produces a formal requirements document and working notes for SQL development.

Modifying existing bqetl queries can affect downstream consumers and dependent models. This Skill analyzes existing queries to identify downstream impact, flags affected tables and dependencies, and produces impact analysis so you can plan required changes and communicate with stakeholders.

Dependency validation follows a sequence: check local schema and metadata first, then consult Glean Dictionary, and use DataHub as a last resort. This Skill automates that validation workflow to confirm all source tables and dependencies exist and are correctly specified before SQL development begins.

Yes. This Skill applies to new model planning, edits to existing bqetl queries, stakeholder interviews, and architecture design. It handles structured requirements gathering for new models and impact analysis for modifications to existing tables, producing appropriate outputs for each scenario.

This Skill produces two outputs: a stakeholder-facing requirements document that captures business logic and decisions, and condensed working notes for SQL developers that guide implementation details like grain, source tables, and dependencies.

Use this Skill when you need systematic dependency validation, downstream impact analysis, or when coordinating with multiple stakeholders. It reduces planning overhead by automating schema checks, flagging risks early, and producing dual outputs for both stakeholders and developers.