snowflake-dbt-query

Orchestrate dbt models, SQL queries, and external tables against Snowflake production.

Updated Aug 27, 2026
Ready to run
npx skills add https://github.com/mporenta/airflow --skill snowflake-dbt-query
💬 Prompt for ChatGPT / Claude Chat▼
Please help me install this Agent Skill.
Skill: snowflake-dbt-query
Source: https://github.com/mporenta/airflow/tree/main/.claude/skills/snowflake-dbt-query
Command: npx skills add https://github.com/mporenta/airflow --skill snowflake-dbt-query

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a unified workflow to run dbt models, execute SQL queries, compile/test, and manage external tables against Snowflake production, enabling secure, repeatable production operations.

Core Features & Use Cases

  • dbt operations: Run models, compile, and test against production environments.
  • SQL queries: Execute queries via the Snowflake CLI or Python connections with production safeguards.
  • External table management: Create, refresh, and validate external table metadata within prod pipelines.
  • Use Case: Validate a production data pipeline by running a model and querying a sample of data with limits.

Quick Start

Connect to Snowflake production using your preferred tool and run a small test query or dbt model to verify connectivity.

Frequently Asked Questions about snowflake-dbt-query

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run dbt models against Snowflake production safely?▼

To run dbt models against Snowflake production safely, this Skill orchestrates dbt operations while enforcing a dedicated Snowflake profile and coordinating dbt targets. It provides a unified workflow to execute and compile production models securely.

How do I execute SQL queries on Snowflake production without risking full table scans?▼

To execute SQL queries on Snowflake production safely, this Skill enforces a strict LIMIT policy for SELECT statements. It coordinates Snowflake CLI usage and Python connections to ensure queries are constrained and do not trigger uncontrolled full table scans.

Can I manage external tables in Snowflake using dbt workflows?▼

Yes, you can manage external tables within Snowflake pipelines using this Skill. It orchestrates external table workflows by enabling you to create, refresh, and validate external table metadata directly against your production environment during dbt operations.

What is the best way to validate a production data pipeline in Snowflake?▼

The best way to validate a Snowflake production data pipeline is to use this Skill to run a dbt model and query a limited data sample. It orchestrates dbt testing and SQL queries with mandatory limits to verify pipeline integrity.

Do I need a dedicated Snowflake profile to run dbt and SQL commands in production?▼

Yes, a dedicated Snowflake profile is mandatory to run dbt and SQL commands in production using this Skill. It enforces the use of a specific profile to coordinate dbt targets, CLI usage, and Python connections securely.