dbt-firebolt supports dbt 1.0+.
Install the dbt-firebolt package from PyPI:
pip install dbt-firebolt
To connect to Firebolt from dbt, you'll need to add a new Firebolt profile to your
profiles.yml file. Please see the dbt documentation on Firebolt profiles to set it up.
For the best experience we recommend that you make the following changes to your dbt project:
The table below shows which dbt and Firebolt features are supported by the adapter. dbt-firebolt is under active development and will be gradually unlocking more features over time.
|Incremental materializations - append||✅|
|Incremental materializations - insert_overwrite||✅|
|Incremental materializations - merge||❌|
|Custom schemas||❌ (see workaround)|
|Join indexes||❌ (syntax supported, but not effective)|
For information on configuring dbt models and external tables for Firebolt, see the dbt documentation for Firebolt configurations.
See our changelog or our release history for more information.