This project will help you export an existing Dremio environment to a dbt project quickly
Setup your config.ini file uisng the following for Dremio Cloud
[Dremio Cloud]
host = api.dremio.cloud
port = 443
ssl = true
type = cloud
username =
password =
project_id =
output = project
project_name = semantic
view_query = select * from sys.project."views"
table_query = select * from sys.project."tables"
Setup your config.ini file uisng the following for Dremio Software
[Dremio Software]
host = localhost
port = 9047
ssl = false
type = software
username = dremio
password = dremio123
output = project
project_name = semantic
view_query = select * from sys."views"
table_query = select * from sys."tables"
- Install dbt dremio
pip install dbt-dremio
- Initiate your dbt project
dbt init <project_name>
- Select
dremio
as the database to use.
python main.py -config "config.ini" -target "Dremio Cloud"
- arguments
- config path
- target in the config to use
- export tables and views in Dremio to a models directory
- update dbt_project.yml with Dremio schema