The dbt Snowflake Native App is now available on the Snowflake Marketplace, integrating dbt Cloud’s capabilities with Snowflake's architecture. This app allows users to access and interact with their dbt projects directly from the Snowflake UI, simplifying the process of gaining insights and reducing costs.
Key Features
Orchestration Observability
- Provides visibility into job runs.
- Helps analysts identify and address issues promptly.
- Sample code available for setting up Snowflake Triggered Jobs.
dbt Explorer
- Integrates data catalog capabilities into Snowflake.
- Allows users to see the lineage and status of dbt assets.
- Features include:
- Column level lineage
- dbt Mesh cross-project lineage
- Rich metadata on sources and models
- Project recommendations and model performance
Ask dbt (Beta)
- A chatbot that answers data-related questions in natural language.
- Converts natural language requests into dbt Semantic Layer queries.
- Uses Snowflake Cortex AI and dbt Semantic Layer for query generation.
- Enhances accuracy by 3X compared to traditional AI chatbots.
- Supports other BI tools like Tableau and Google Sheets.
Getting Started
- The app can be purchased via the Snowflake Marketplace.
- Installation and setup are done within the Snowflake environment.
- Payment can be made using Snowflake committed spend, with no additional vendor approvals required.
This integration aims to streamline data analysis and decision-making processes by bringing dbt Cloud’s powerful tools directly into the Snowflake ecosystem.
