Skip to main content

MindsDB setup

Vendor-supported plugin

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

  • Maintained by: MindsDB
  • Authors: MindsDB team
  • GitHub repo: mindsdb/dbt-mindsdb
  • PyPI package: dbt-mindsdb
  • Slack channel: n/a
  • Supported dbt Core version: v1.0.1 and newer
  • dbt Cloud support: Not Supported
  • Minimum data platform version: ?

Installing dbt-mindsdb

Use pip to install the adapter. Before 1.8, installing the adapter would automatically install dbt-core and any additional dependencies. Beginning in 1.8, installing an adapter does not automatically install dbt-core. This is because adapters and dbt Core versions have been decoupled from each other so we no longer want to overwrite existing dbt-core installations. Use the following command for installation:

Configuring dbt-mindsdb

For MindsDB-specific configuration, please refer to MindsDB configs.

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
0