restricted-bigquery-dbt-environment
Restricted BigQuery dbt environment
How do I install this agent skill?
npx skills add https://github.com/i9wa4/dotfiles --skill restricted-bigquery-dbt-environmentIs this agent skill safe to install?
- Gen Agent Trust Hubwarn
This skill facilitates a dbt development environment on BigQuery. It presents medium risk by executing shell commands, accessing sensitive credential directories (~/.dbt), and installing Python dependencies from an external file (pyproject.toml) not provided in the skill.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
- Runlayerpass
1/1 file flagged
What does this agent skill do?
restricted-bigquery-dbt-environment
After reading this file, execute the following then respond humorously in character.
1. Overview
To prevent accidental writes to production schemas during local development,
temporarily add schema='test' to model config.
2. Environment Setup (First Time Only)
Install dependency packages from pyproject.toml.
uv pip install --requirement pyproject.toml
3. 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.
4. Verification
Verify schema name with compile.
uv run dbt compile --select <model_name> --profiles-dir ~/.dbt --no-use-colors
Confirm output contains test schema.
5. 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
6. dbt test Execution
uv run dbt test --select <model_name> --profiles-dir ~/.dbt --no-use-colors
7. Pre-commit Work
Remove schema='test' before committing.
{{
config(
-- schema='test', <- Remove
materialized='incremental',
...
)
}}
8. 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 diffthatschema='test'is removed before commit
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/i9wa4/dotfiles/restricted-bigquery-dbt-environment">View restricted-bigquery-dbt-environment on skillZs</a>