Firebolt
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
- An existing AWS account
Setup guide
-
Sign up to Firebolt following the guide
-
Follow the getting started tutorial to setup a database.
-
Create a service account.
You should now have the following
- An existing Firebolt account
- Connection parameters handy
- Service account id
- Service account password
- Account name
- Host (Optional)
- Engine (Optional)
- A running engine (if an engine is stopped or booting up you won't be able to connect to it)
- 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
Version | Date | Pull Request | Subject |
---|---|---|---|
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 |