<img width="1113" alt="Screen Shot 2021-12-10 at 1 09 09 PM" src="https://user-images.githubusercontent.com/7674553/145641621-a7dabe78-da92-4f0a-bbd2-54ccf7f34b57.png">
# dbt-firebolt
The [dbt](https://www.getdbt.com) adapter for [Firebolt](https://www.firebolt.io/). 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](https://docs.getdbt.com/reference/warehouse-profiles/firebolt-profile#connecting-to-firebolt) to set it up.
#### Setup Recommendations
For the best experience we recommend that you make the following changes to your dbt project:
* [Set an explicit value for `quote_columns`](https://docs.getdbt.com/reference/resource-configs/firebolt-configs#setting-quote_columns)
* [Add the `generate_alias_name` macro to your project](https://docs.getdbt.com/reference/warehouse-profiles/firebolt-profile#supporting-concurrent-development)
## 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 | :white_check_mark: |
| Ephemeral materializations | :white_check_mark: |
| View materializations | :white_check_mark: |
| Incremental materializations - append | :white_check_mark: |
| Incremental materializations - insert_overwrite | :white_check_mark: |
| Incremental materializations - delete+insert | :white_check_mark: |
| Incremental materializations - merge | :x: |
| Snapshots | :white_check_mark: |
| Seeds | :white_check_mark: |
| Tests | :white_check_mark: |
| Documentation | :white_check_mark: |
| Custom schemas | :x: (see [workaround](https://docs.getdbt.com/reference/warehouse-profiles/firebolt-profile#supporting-concurrent-development)) |
| Custom databases | :x: |
| Source freshness | :white_check_mark: |
| External tables | :white_check_mark: |
| Primary indexes | :white_check_mark: |
| Aggregating indexes | :white_check_mark: |
| Join indexes | :x: (syntax supported, but not effective) |
## Constraints support
More on constraints in [Platform constraint support](https://docs.getdbt.com/docs/collaborate/govern/model-contracts#platform-constraint-support)
| Constraint type | Support | Platform enforcement |
|-----------------|---------|----------------------|
| not_null | :white_check_mark: Supported | :white_check_mark: Enforced |
| primary_key | :x: Not Supported | :x: Not enforced |
| foreign_key | :x: Not Supported | :x: Not enforced |
| unique | :white_check_mark: Supported | :x: Not enforced |
| check | :x: Not supported | :x: Not enforced |
## Using dbt-firebolt
For information on configuring dbt models and external tables for Firebolt, see the [dbt documentation for Firebolt configurations](https://docs.getdbt.com/reference/resource-configs/firebolt-configs).
## Contributing
See: [CONTRIBUTING.MD](https://github.com/firebolt-db/dbt-firebolt/tree/main/CONTRIBUTING.MD)
## Changelog
See our [changelog](CHANGELOG.md) or our release history for more information.
Raw data
{
"_id": null,
"home_page": "https://github.com/firebolt-db/dbt-firebolt",
"name": "dbt-firebolt",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": null,
"keywords": null,
"author": "Firebolt",
"author_email": "support@firebolt.io",
"download_url": "https://files.pythonhosted.org/packages/d2/6d/cd33329c589327df971a57f2a0d7335fd9488eb623a4e1843e2760818e2e/dbt_firebolt-1.10.0.tar.gz",
"platform": null,
"description": "<img width=\"1113\" alt=\"Screen Shot 2021-12-10 at 1 09 09 PM\" src=\"https://user-images.githubusercontent.com/7674553/145641621-a7dabe78-da92-4f0a-bbd2-54ccf7f34b57.png\">\n\n\n# dbt-firebolt\n\nThe [dbt](https://www.getdbt.com) adapter for [Firebolt](https://www.firebolt.io/). dbt-firebolt offers the following benefits to Firebolt customers:\n* SQL-based data transformation\n* Life cycle management for native Firebolt objects (fact tables, dimension tables, primary indexes, aggregating indexes, join indexes, etc.)\n* Declarative, version-controlled data modeling\n* Auto-generated data lineage and documentation\n\ndbt-firebolt supports dbt 1.0+.\n\n\n## Installation\n\nInstall the dbt-firebolt package from PyPI:\n ```\n pip install dbt-firebolt\n ```\n\n\n## Setup\n\n#### Connecting to Firebolt\n\nTo 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](https://docs.getdbt.com/reference/warehouse-profiles/firebolt-profile#connecting-to-firebolt) to set it up.\n\n#### Setup Recommendations\n\nFor the best experience we recommend that you make the following changes to your dbt project:\n* [Set an explicit value for `quote_columns`](https://docs.getdbt.com/reference/resource-configs/firebolt-configs#setting-quote_columns)\n* [Add the `generate_alias_name` macro to your project](https://docs.getdbt.com/reference/warehouse-profiles/firebolt-profile#supporting-concurrent-development)\n\n\n## Feature Support\n\nThe 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.\n\n| Feature | Supported |\n|------------------------------|--------------------|\n| Table materializations | :white_check_mark: |\n| Ephemeral materializations | :white_check_mark: |\n| View materializations | :white_check_mark: |\n| Incremental materializations - append | :white_check_mark: |\n| Incremental materializations - insert_overwrite | :white_check_mark: |\n| Incremental materializations - delete+insert | :white_check_mark: |\n| Incremental materializations - merge | :x: |\n| Snapshots | :white_check_mark: |\n| Seeds | :white_check_mark: |\n| Tests | :white_check_mark: |\n| Documentation | :white_check_mark: |\n| Custom schemas | :x: (see [workaround](https://docs.getdbt.com/reference/warehouse-profiles/firebolt-profile#supporting-concurrent-development)) |\n| Custom databases | :x: |\n| Source freshness | :white_check_mark: |\n| External tables | :white_check_mark: |\n| Primary indexes | :white_check_mark: |\n| Aggregating indexes | :white_check_mark: |\n| Join indexes | :x: (syntax supported, but not effective) |\n\n\n## Constraints support\n\nMore on constraints in [Platform constraint support](https://docs.getdbt.com/docs/collaborate/govern/model-contracts#platform-constraint-support)\n\n\n| Constraint type | Support | Platform enforcement |\n|-----------------|---------|----------------------|\n| not_null | :white_check_mark: Supported | :white_check_mark: Enforced |\n| primary_key | :x: Not Supported | :x: Not enforced |\n| foreign_key | :x: Not Supported | :x: Not enforced |\n| unique | :white_check_mark: Supported | :x: Not enforced |\n| check | :x: Not supported | :x: Not enforced |\n\n\n## Using dbt-firebolt\n\nFor information on configuring dbt models and external tables for Firebolt, see the [dbt documentation for Firebolt configurations](https://docs.getdbt.com/reference/resource-configs/firebolt-configs).\n\n## Contributing\n\nSee: [CONTRIBUTING.MD](https://github.com/firebolt-db/dbt-firebolt/tree/main/CONTRIBUTING.MD)\n\n## Changelog\n\nSee our [changelog](CHANGELOG.md) or our release history for more information.\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "The Firebolt adapter plugin for dbt (data build tool)",
"version": "1.10.0",
"project_urls": {
"Bug Tracker": "https://github.com/firebolt-db/dbt-firebolt/issues",
"Homepage": "https://github.com/firebolt-db/dbt-firebolt"
},
"split_keywords": [],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "62f75ae840e8ba329ceee65adeaf24899288f246aff4c65afcfad14bc7e5804a",
"md5": "e2b3c9d1bc0eda8c6908953b93e69a04",
"sha256": "a02621a78e03c54fedfc4353d5e841c187c6293a39bf8752eb91492c29f5d84c"
},
"downloads": -1,
"filename": "dbt_firebolt-1.10.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "e2b3c9d1bc0eda8c6908953b93e69a04",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 47056,
"upload_time": "2025-08-04T08:50:48",
"upload_time_iso_8601": "2025-08-04T08:50:48.358636Z",
"url": "https://files.pythonhosted.org/packages/62/f7/5ae840e8ba329ceee65adeaf24899288f246aff4c65afcfad14bc7e5804a/dbt_firebolt-1.10.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "d26dcd33329c589327df971a57f2a0d7335fd9488eb623a4e1843e2760818e2e",
"md5": "4b4fa87bbdfa33eac86a6c2a129105b2",
"sha256": "d6869f88cc32b15c4fa7cd863708e02eccc9d9fdb52f0700c17c1be1015f63f6"
},
"downloads": -1,
"filename": "dbt_firebolt-1.10.0.tar.gz",
"has_sig": false,
"md5_digest": "4b4fa87bbdfa33eac86a6c2a129105b2",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 32938,
"upload_time": "2025-08-04T08:50:49",
"upload_time_iso_8601": "2025-08-04T08:50:49.293557Z",
"url": "https://files.pythonhosted.org/packages/d2/6d/cd33329c589327df971a57f2a0d7335fd9488eb623a4e1843e2760818e2e/dbt_firebolt-1.10.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-04 08:50:49",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "firebolt-db",
"github_project": "dbt-firebolt",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "dbt-firebolt"
}
JSON
