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

Key	Required	Description	Example
type	✔️	The specific adapter to use	mindsdb
host	✔️	The MindsDB (hostname) to connect to	cloud.mindsdb.com
port	✔️	The port to use	3306 or 47335
schema	✔️	Specify the schema (database) to build models into	The MindsDB datasource
username	✔️	The username to use to connect to the server	mindsdb or mindsdb cloud user
password	✔️	The password to use for authenticating to the server	`pass