Wren AI Launches Native dbt Integration for Governed, AI-Driven Insights

We are thrilled to announce a major enhancement to the Wren AI platform: native support for dbt™ (data build tool)!

This new integration is a game-changer for data teams, enabling you to seamlessly bridge the gap between your trusted, governed data models and the power of generative AI.

The Power of dbt + AI: The Single Source of Truth for GenBI

Your dbt project is the cornerstone of your modern data stack—it’s where your most reliable, standardized, and analytically-ready data models are defined. Until now, leveraging this critical context within an AI platform often required manual, error-prone steps.

With Wren AI's dbt integration, your AI-powered business intelligence (GenBI) is now built directly on your dbt assets, guaranteeing:

1. Truth and Governance: The models, and relationships defined in your dbt project become the single source of truth for all Wren AI GenBI features.
2. Rich Context, Zero Effort: Wren AI automatically imports the invaluable documentation (model and column descriptions) you’ve already written in dbt, providing the context needed for the AI Assistant to generate highly accurate queries and insights.
3. Speed to Insight: Data consumers can query complex business concepts in natural language immediately, without waiting for manual modeling or metadata transfer.

Key Features of the dbt Integration

Our new dbt integration uses the Wren CLI to sync your local dbt project artifacts with Wren AI Cloud, transforming your data assets into AI-ready models.

What gets synced:

• Analytics-Ready Models: We focus on syncing your downstream models, ignoring staging and intermediate layers to keep your AI experience focused on final business concepts.
• Model and Column Descriptions: All descriptions from your dbt manifest.json are imported as rich metadata, improving NLQ accuracy.
• Relationships: Relationships derived from your manifest.json and model tests are used to build the Wren MDL (Model Definition Language), giving the AI a comprehensive understanding of how your data tables connect.
• Schema Details: The integration reads your catalog.json to extract essential column types.

How to Get Started

Setting up the integration is fast and simple using the Wren CLI:

1. Install the Wren CLI.
2. Prepare your dbt project: Run dbt build and dbt docs generate to create the required manifest.json and catalog.json artifacts.
3. Sync your project: Use the wren dbt create command to import your dbt models into a new Wren AI project.
4. Keep it Current: Use wren dbt update to quickly synchronize any changes you make to your dbt project (like adding a new model or updating a description).

Current & Future Data Source Support

The Wren AI dbt integration is available today for data teams using:

• PostgreSQL
• MySQL
• BigQuery

Coming Soon! We are actively working to expand support and will be launching integrations for Snowflake and Redshift in the near future.

Ready to turn your governed dbt project into a powerful AI engine for the business?

Learn more and get started with the dbt Quick Start guide: https://docs.getwren.ai/cp/guide/dbt