Skip to main content

MindsDB Profile

Vendor-supported plugin

The dbt-mindsdb package allows dbt to connect to MindsDB.

Overview of dbt-mindsdb​

Maintained by: MindsDB
Author: MindsDB team Source: https://github.com/mindsdb/dbt-mindsdb
Core version: v1.0.1 and newer
dbt Cloud: Not Supported

Installation​

pip install dbt-mindsdb

Configurations​

Basic profile.yml for connecting to MindsDB:

mindsdb:
outputs:
dev:
database: 'mindsdb'
host: '127.0.0.1'
password: ''
port: 47335
schema: 'mindsdb'
type: mindsdb
username: 'mindsdb'
target: dev

KeyRequiredDescriptionExample
type✔️The specific adapter to usemindsdb
host✔️The MindsDB (hostname) to connect tocloud.mindsdb.com
port✔️The port to use3306 or 47335
schema✔️Specify the schema (database) to build models intoThe MindsDB datasource
username✔️The username to use to connect to the servermindsdb or mindsdb cloud user
password✔️The password to use for authenticating to the server`pass