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
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 |
0