skills.rest
sfc-gh-dflippo
sfc-gh-dflippoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dbt Projects on Snowflake

Deploy and manage dbt projects on Snowflake with monitoring.

34|13|Updated Feb 1, 2022
Search Tags:#automation#monitoring#deployment#Snowflake#observability#dbt#data engineering
One-click install
npx skills add https://github.com/sfc-gh-dflippo/snowflake-dbt-demo --skill dbt-projects-on-snowflake
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt Projects on Snowflake
Source: https://github.com/sfc-gh-dflippo/snowflake-dbt-demo/tree/main/.claude/skills/dbt-projects-snowflake
Command: npx skills add https://github.com/sfc-gh-dflippo/snowflake-dbt-demo --skill dbt-projects-on-snowflake

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Manually deploying, managing, and monitoring dbt projects on Snowflake can be complex and time-consuming, requiring separate tools and manual checks. This skill automates these processes, providing native Snowflake integration and comprehensive observability.

Core Features & Use Cases

  • Native Deployment: Deploy dbt projects directly as Snowflake DBT PROJECT objects.
  • Automated Monitoring: Leverage OpenTelemetry event tables for real-time execution logs, traces, and metrics.
  • Use Case: Set up a CI/CD pipeline to automatically deploy your dbt project to Snowflake, schedule daily runs, and monitor for errors and performance regressions directly within Snowflake's environment.

Quick Start

Deploy project using Snowflake CLI

snow dbt deploy my_project --source .

Execute a dbt build command

snow dbt execute my_project build

Or execute directly in SQL

EXECUTE DBT PROJECT <db>.<schema>.<project> args='build';

Frequently Asked Questions about dbt Projects on Snowflake

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

FAQPage Schema
How do I deploy a dbt project to Snowflake automatically?▼

Deploy dbt projects to Snowflake using native DBT PROJECT objects via Snowflake CLI (`snow dbt deploy`), Snowsight, or SQL execution commands. This automates deployment across development and production environments without manual steps.

Can I monitor dbt execution and performance on Snowflake in real time?▼

Yes. Monitor dbt runs using OpenTelemetry event tables for execution logs, traces, and metrics directly within Snowflake. Predefined queries and alerting workflows track errors and performance regressions automatically.

What setup is required to run dbt projects on Snowflake with automation?▼

Configure Git and API integration for CI/CD pipelines, set up OpenTelemetry event tables for telemetry, and prepare parameterized SQL execution commands. These prerequisites enable scheduled runs and observability.

Does dbt work natively with Snowflake for scheduling and CI/CD?▼

Yes. dbt integrates natively with Snowflake through DBT PROJECT objects, supporting scheduled daily runs, CI/CD pipeline deployment via Snowflake CLI, and event-driven monitoring within Snowflake's environment.

Can I execute dbt commands directly in Snowflake SQL?▼

Yes. Execute dbt builds and other commands using SQL syntax (`EXECUTE DBT PROJECT`) directly in Snowflake without external tools, supporting development and production workflows.

What are the limitations of deploying dbt on Snowflake this way?▼

Deployment requires Git and API prerequisites for full CI/CD integration. Monitoring depends on OpenTelemetry event table configuration; without it, observability is limited to standard Snowflake logs.

Related Skills

Explore More Data & Analytics Skills→
sfc-gh-dflipposfc-gh-dflippo
34

dbt-projects-snowflake-setup

Automate initial dbt Projects setup on Snowflake with integrations and monitoring.

Community
Intermediate
ro9er117911ro9er117911
1

via-export

Export filtered MATSim simulation results into Via-ready visualization files.

Community
Advanced
sfc-gh-miwhitakersfc-gh-miwhitaker
3

cowork-only-users

Provision CoWork-only Snowflake users without Snowsight or SQL access.

Community
Intermediate
anton-abyzovanton-abyzov
156

mlops-dag-builder

Design DAG-based MLOps pipelines for Airflow, Dagster, Kubeflow, or Prefect.

Community
Advanced