Connect Firebolt data with any data source.

Write data from any Airbyte source to Firebolt on your schedule.

Load data into Firebolt Read the docs

Sources: 590+
Standard support: 0.2.41

Overview

What is the Airbyte Firebolt connector?

The Airbyte Firebolt connector loads data from 590+ Airbyte sources into Firebolt, with full refresh and incremental sync on a schedule you control.

01
Load from any source
Move data into Firebolt from 590+ Airbyte sources on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
Cloud or self-hosted
Run the Firebolt connector on Cloud, OSS, Hybrid.

Setup

Live in ten steps

First, navigate to the Firebolt destination connector on Airbyte.
Click on the "Create a new connection" button.
Enter a name for your connection.
Enter your Firebolt API key and secret.
Enter the name of the Firebolt database you want to connect to.
Enter the name of the schema you want to use.
Choose the tables you want to replicate.
Configure any additional settings, such as the replication frequency and the maximum number of rows to replicate.
Test the connection to ensure that it is working properly.
Save the connection and start the replication process. Note: It is important to have a basic understanding of Firebolt and its API before attempting to connect it to Airbyte. Additionally, it is recommended to consult the Airbyte documentation for more detailed instructions and troubleshooting tips.

Configuration fields

Firebolt configuration fields
Field	Type	Description
account*	string	Firebolt account to login.
client_id*	string	Firebolt service account ID.
client_secret*	string	Firebolt secret, corresponding to the service account ID.
database*	string	The database to connect to.
engine*	string	Engine name to connect to.
host	string	The host name of your Firebolt database.
loading_method	object	Loading method used to select the way data will be uploaded to Firebolt

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Firebolt connector questions

What data can I load into Firebolt with Airbyte?

Airbyte moves data from any supported source into Firebolt on a schedule you control, with full refresh and incremental sync where the destination supports it.

Does the Firebolt connector support incremental sync?

Yes. The Firebolt destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.

Where can I run the Firebolt connector?

Run the Firebolt connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales