dbt Projects on Snowflake

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';