Skip to main content

The Firebolt adapter plugin for dbt (data build tool)

Project description

Screen Shot 2021-12-10 at 1 09 09 PM

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 :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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt_firebolt-1.9.0.tar.gz (30.5 kB view hashes)

Uploaded Source

Built Distribution

dbt_firebolt-1.9.0-py3-none-any.whl (46.7 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page