Create dbt Transformations

Use this skill to generate SQL models, declare sources, update schema.yml, and validate models with dbt run / dbt test.

For BigQuery exploration (listing datasets, inspecting raw tables, previewing rows, null rates), load the explore-lakehouse skill. If that skill is not installed, fall back to:

bq show --format=prettyjson $REVOS_BQ_DATASET.<table>

Warn the user: "The explore-lakehouse skill is not installed — using bq show as a fallback. Install it for richer schema exploration."

Part 1: Knowledge Base

Layer Conventions