dbt-firebolt

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:

• Set an explicit value for quote_columns
• Add the generate_alias_name macro to your 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	: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)
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

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.

Contributing

See: CONTRIBUTING.MD

Changelog

See our changelog or our release history for more information.