MindsDB setup

Vendor-supported plugin

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

import SetUpPages from '/snippets/_setup-pages-intro.md';

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

Configurations​

Configurations