Skip to main content

MindsDB setup

Vendor-supported plugin

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

Overview of dbt-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: ?

Installation

Installing dbt-mindsdb

pip is the easiest way to install the adapter:

pip install dbt-mindsdb

Installing dbt-mindsdb will also install dbt-core and any other dependencies.

Configuring dbt-mindsdb

For MindsDB-specifc configuration please refer to MindsDB Configuration

For further info, refer to the GitHub repository: mindsdb/dbt-mindsdb

s

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