dbt Quick Start
Create a new Wren AI project from your local dbt project and learn how to keep it in sync.
dbt Integration is only available in Essential Cloud plan and above
Supported data sources:
- PostgreSQL
- MySQL
- BigQuery
- Redshift
- Snowflake
Use the Wren CLI to import your dbt project into Wren AI Cloud. We sync your analytics-ready dbt models (e.g., marts) — including model and column descriptions and relationships — as Models, ready for natural-language querying.
In this quick start, you'll:
- Install the CLI
- Log in to Wren AI Cloud
- Prepare your dbt project (
dbt build+dbt docs generate) - Sync your dbt models to Wren AI
- Optionally push updates later with
wren dbt update
1. Install the CLI
Follow the same installation steps as in the Installation and Login guide.
If you already have the CLI installed, verify your version:
wren version
2. Log in to Wren AI
Follow the same login steps as in the Installation and Login guide. If you are already logged in, verify your status:
wren auth status
If you are using the self-hosted version of Wren AI, enter your <self-host URL>/api/ as the API endpoint. For example:
https://myhost.com/api/
3. Prepare your dbt project
From your dbt project directory:
cd /path/to/your-dbt-project