dbt-firebolt
The dbt adapter for Firebolt. dbt-firebolt offers the following benefits to Firebolt customers:
- SQL-based data transformation
- Life cycle management for native Firebolt objects (fact tables, dimension tables, primary indexes, aggregating indexes, join indexes, etc.)
- Declarative, version-controlled data modeling
- Auto-generated data lineage and documentation
dbt-firebolt supports dbt 1.0+.
Installation
Install the dbt-firebolt package from PyPI:
pip install dbt-firebolt
Setup
Connecting to 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.
Setup Recommendations
For the best experience we recommend that you make the following changes to your dbt project:
Feature Support
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.
| Feature | Supported |
|---|---|
| Table materializations | ✅ |
| Ephemeral materializations | ✅ |
| View materializations | ✅ |
| Incremental materializations - append | ✅ |
| Incremental materializations - insert_overwrite | ✅ |
| Incremental materializations - delete+insert | ✅ |
| Incremental materializations - merge | ❌ |
| Snapshots | ✅ |
| Seeds | ✅ |
| Tests | ✅ |
| Documentation | ✅ |
| Custom schemas | ❌ (see workaround) |
| Custom databases | ❌ |
| Source freshness | ✅ |
| External tables | ✅ |
| Primary indexes | ✅ |
| Aggregating indexes | ✅ |
| Join indexes | ❌ (syntax supported, but not effective) |
Constraints support
More on constraints in Platform constraint support
| Constraint type | Support | Platform enforcement |
|---|---|---|
| not_null | ✅ Supported | ✅ Enforced |
| primary_key | ❌ Not Supported | ❌ Not enforced |
| foreign_key | ❌ Not Supported | ❌ Not enforced |
| unique | ✅ Supported | ❌ Not enforced |
| check | ❌ Not supported | ❌ Not enforced |
Using dbt-firebolt
For information on configuring dbt models and external tables for Firebolt, see the dbt documentation for Firebolt configurations.
Contributing
See: CONTRIBUTING.MD
Changelog
See our changelog or our release history for more information.
3 maintainers
Metadata
3 maintainers
Release files for dbt-firebolt 1.9.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| dbt_firebolt-1.9.3.tar.gz | 32.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| dbt_firebolt-1.9.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 52.4 kB
Release files / dbt_firebolt-1.9.3.tar.gz
| Download URL | dbt_firebolt-1.9.3.tar.gz |
|---|---|
| Size | 32.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e06325a3e2052898a391525f34484ec2cac643b8ec5c149a79967c8691616f21
|
|
BLAKE2b-256 checksum How to use checksums |
435011673e230e0d2ff1a6dfbdeba12195c1fb97f1766e3e352878bc44777e70
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.8.18
|
Release files / dbt_firebolt-1.9.3-py3-none-any.whl
| Download URL | dbt_firebolt-1.9.3-py3-none-any.whl |
|---|---|
| Size | 19.9 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
83af36091bf93f938a9d31642100a8ff6bf31192b61f6e687add7fdacd9f5e08
|
|
BLAKE2b-256 checksum How to use checksums |
72aacf10d60785eb3d5f5faa53a9e877617e0e1b8fd0563001f0ad5f9a8fb08c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.8.18
|
