Skip to main content
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 ✅
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.

Metadata

Release files for dbt-firebolt 1.8.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for dbt-firebolt 1.8.1
File Size Uploaded Provenance Actions
dbt_firebolt-1.8.1.tar.gz 29.9 kB Without provenance Details for dbt_firebolt-1.8.1.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for dbt-firebolt 1.8.1
File Interpreter ABI Platform Actions
dbt_firebolt-1.8.1-py3-none-any.whl Python 3 none any Details for dbt_firebolt-1.8.1-py3-none-any.whl

Total release size: 75.8 kB

Release files / dbt_firebolt-1.8.1.tar.gz

Download URL dbt_firebolt-1.8.1.tar.gz
Size 29.9 kB
Tags Source
SHA-256 checksum
How to use checksums
8b9f8d354bbfcb428b5b90a491d0ab18858382ed96366b72bbcbf3bcaea5f31f
BLAKE2b-256 checksum
How to use checksums
faccf79d960c052edcfb2824a21830ec183f33ed8a8c53c7756ac556fbbe6f64
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.7.17

Release files / dbt_firebolt-1.8.1-py3-none-any.whl

Download URL dbt_firebolt-1.8.1-py3-none-any.whl
Size 45.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
5fdfded059a94e908590c693553d291f5b950f659fb8c3130d657ca8372fc56b
BLAKE2b-256 checksum
How to use checksums
4b96e4e2cf00c3393c4cc4bedf6366c69f3205dd797f8ce4aff9e443ab43de09
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.7.17

Security for dbt-firebolt 1.8.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

1.8.1 This release

2 release files No provenance

0.21.8

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page