Firebolt

Availability:

Airbyte Cloud Airbyte OSS PyAirbyte

Support Level:

community

Connector Version:

2.0.4(Last updated a day ago)

CDK Version:

0.90.0

Sync Success Rate:

Usage Rate:

Overview

The Firebolt source allows you to sync your data from Firebolt. Only Full refresh is supported at the moment.

The connector is built on top of a pure Python firebolt-sdk and does not require additonal dependencies.

Resulting schema

The Firebolt source does not alter schema present in your database. Depending on the destination connected to this source, however, the result schema may be altered. See the destination's documentation for more details.

Features

Feature	Supported?(Yes/No)	Notes
Full Refresh Sync	Yes
Incremental - Append Sync	No

Getting started

Requirements

1. An existing AWS account

Setup guide

1. Sign up to Firebolt following the guide

2. Follow the getting started tutorial to setup a database.

3. Create a service account.

4. Load data.

You should now have the following

1. An existing Firebolt account
2. Connection parameters handy
   1. Service account id
   2. Service account password
   3. Account name
   4. Host (Optional)
   5. Engine (Optional)
3. A running engine (if an engine is stopped or booting up you won't be able to connect to it)
4. Your data in either Fact or Dimension tables.

You can now use the Airbyte Firebolt source.

Reference

Config fields reference

Field

Type

Property name

string

client_id

string

client_secret

string

account

string

database

string

engine

string

host

Changelog

Expand to review

Version	Date	Pull Request	Subject
2.0.4	2024-06-22	40199	Update dependencies
2.0.3	2024-06-06	39183	[autopull] Upgrade base image to v1.2.2
2.0.2	2024-06-03	38892	Replace AirbyteLogger with logging.Logger
2.0.1	2024-06-03	38892	Replace AirbyteLogger with logging.Logger
2.0.0	2024-06-01	36349	Service account authentication support
1.0.0	2023-07-20	21842	PGDate, TimestampTZ, TimestampNTZ and Boolean column support
0.2.1	2022-05-10	25965	Fix DATETIME conversion to Airbyte date-time type
0.2.0	2022-09-09	16583	Reading from views
0.1.0	2022-04-28	13874	Create Firebolt source