dbt Model Index

When to Use

• Before writing any BigQuery SQL against production data
• When the task has not already explicitly stated which models/tables to query
• When resolving a vague or ambiguous data question into the right BigQuery tables

How to Set Up This Skill

This skill is a curated index of your dbt models. Each entry describes a model (a BigQuery table), what it contains, and what types of questions it is best suited to answer.

To customize this index for your project:

• Organize models into logical domain sections (e.g., Users, Activity, Revenue, Events)
• For each model, include: the table name, a 1–2 sentence description of its grain and content, and "Useful for:" bullets covering common query patterns
• Note key join keys, standard filters, and partition fields where relevant