Getting Started

drive-snowflake runs three independent dbt projects — stock, Redbook, and Marketplace & Ads Analytics — against Snowflake, backed by Terraform-managed infrastructure and schemachange-managed migrations. There's no single root install: each dbt project has its own Python virtual environment, and there's no root package.json for the docs site or the serverless ingestion Lambdas either.

This section's setup steps and Makefile targets cover the stock and Redbook projects. Marketplace & Ads Analytics has no Makefile targets and isn't covered here yet.

Everything here assumes you already have Snowflake and AWS access provisioned — this section covers configuring your local machine, not requesting access.

At a glance


dbt projects	`src/stock/dbt`, `src/redbook/dbt`, `src/marketplace/drive_ads_analytics` (independent venvs)
Snowflake targets	`staging`, `prod` (per project `profiles.yml`)
Schema changes	`schemachange`, never a direct `ALTER TABLE`
Task runner	Root `Makefile`

Start here

First time on this machine? Prerequisites & setup — Snow CLI, AWS profile, venv, service account key.
Ready to run models? Running dbt locally — compile/run/seed/test, --select flags, project vars.
Changing a schema? Deploying migrations locally — the deploy-migrations.sh workflow.
Just need a command? Makefile command reference — every make target in one table.
Deploying a full refresh, or wondering what a scripts/ folder does? Common developer workflows — deployment scenarios and the operational scripts.