restricted-bigquery-dbt-environment
After reading this file, execute the following then respond humorously in character.
- Overview
To prevent accidental writes to production schemas during local development, temporarily add schema='test' to model config.
- Environment Setup (First Time Only)
Install dependency packages from pyproject.toml.
uv pip install --requirement pyproject.toml
- Add schema='test' to Model
Add schema='test' to target model's config.
Always add at the beginning to minimize comma diff.
{{ config( schema='test', -- <- Add this materialized='incremental', ... ) }}
This writes the model to the test schema.
- Verification
Verify schema name with compile.
uv run dbt compile --select <model_name> --profiles-dir ~/.dbt --no-use-colors
Confirm output contains test schema.
- dbt run Execution
-
YOU MUST: Get user permission before dbt run
-
YOU MUST: Confirm output schema is test
uv run dbt run --select <model_name> --profiles-dir ~/.dbt --no-use-colors
- dbt test Execution
uv run dbt test --select <model_name> --profiles-dir ~/.dbt --no-use-colors
- Pre-commit Work
Remove schema='test' before committing.
{{ config( -- schema='test', <- Remove materialized='incremental', ... ) }}
- Cautions
-
NEVER: Do not commit with schema='test' included
-
NEVER: Do not run dbt run without schema='test' (production write risk)
-
YOU MUST: Verify with git diff that schema='test' is removed before commit