Skip to main content

The Firebolt adapter plugin for dbt (data build tool)

Reason this release was yanked:

dbt is unable to find adapter after installation.

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 0.21+.

Installation

  1. Download the Firebolt JDBC driver and place it wherever you'd prefer.
  2. If you've never installed a Java Runtime Environment you will need to download and install one from either OpenJDK or Oracle.
  3. 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 :x:
Seeds :white_check_mark:
Tests :white_check_mark:
Documentation :white_check_mark:
Snapshots :x:
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 :white_check_mark:
Partitioned tables :x:

Using dbt-firebolt

For information on configuring dbt models and external tables for Firebolt, see the dbt documentation for Firebolt configurations.

Changelog

See our changelog or our release history for more information.

Project details


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