Firebolt
Set up the Firebolt destination connector using this guide.
Prerequisites
- Firebolt Account: You need an active Firebolt account. If you don’t have one, sign up here.
- Firebolt Database and Engine created: Follow guide to create an engine in your Firebolt workspace if needed.
- Service Account credentials: All programmatic access to Firebolt requires a service account for database interactions. Follow guide to create one, then note its ID and secret.
Replication strategies
You can use two replication strategies with this Firebolt destination connector:
-
SQL: Replicates data through SQL INSERT queries. It uses Firebolt SDK to run queries directly on Firebolt Engines. Not recommended for production workloads as this does not scale well.
-
S3: Replicates data by uploading it to an S3 bucket, creating an External Table and writing it to a final Fact Table. This is the recommended loading approach. You’ll need an S3 bucket and credentials alongside your Firebolt credentials.
Connection parameters
- Client ID
- Your service account id.
- Client Secret
- Your service account secret.
- Account
- Your Firebolt account.
- Database
- The database name where you want to store the data.
- Engine
- The engine name that will run the queries.
- Host (optional)
- Firebolt backend URL. You can leave this blank for most use cases.
For the S3 strategy, you’ll also need:
- S3 Bucket Name
- See this to create an S3 bucket.
- S3 Bucket Region
- Create the S3 bucket in the same region as the Firebolt database.
- Access Key Id
- See this for instructions on generating an access key.
- An Airbyte-specific user is recommended. This user requires read, write and delete permissions to objects in the staging bucket.
- Secret Access Key
- The corresponding key for the key id above.
Setup guide
- Sign up to Firebolt by following the guide
- Follow the getting started tutorial to set up a database.
- Create a service account.
- Create an engine as described in here
- (Optional) Create a staging S3 bucket (for the S3 strategy).
- (Optional) Create an IAM with programmatic access to read, write and delete objects from an S3 bucket.
Supported sync modes
| Sync mode | Supported? |
|---|---|
| Full Refresh - Overwrite | Yes |
| Full Refresh - Append | Yes |
| Full Refresh - Overwrite + Deduped | No |
| Incremental Sync - Append | Yes |
| Incremental Sync - Append + Deduped | No |
Connector features
Output schema
Each stream outputs to its own raw Fact table in Firebolt. Each table contains three columns:
_airbyte_ab_id: a uuid that Airbyte assigns to each processed event. The column type in Firebolt isVARCHAR._airbyte_emitted_at: a timestamp showing when the event was pulled from the data source. The column type in Firebolt isTIMESTAMP._airbyte_data: a json blob containing the event data. The column type in Firebolt isVARCHAR, but you can parse it with JSON functions.
Namespace support
This destination doesn’t support namespaces.
Changelog
Expand to review
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.2.41 | 2026-10-07 | 88246 | Add missing destination_firebolt.run entrypoint module so the connector image starts with the shared python-connector Dockerfile |
| 0.2.40 | 2025-05-24 | 59866 | Update dependencies |
| 0.2.39 | 2025-05-03 | 59316 | Update dependencies |
| 0.2.38 | 2025-04-26 | 58725 | Update dependencies |
| 0.2.37 | 2025-04-19 | 57623 | Update dependencies |
| 0.2.36 | 2025-04-05 | 57115 | Update dependencies |
| 0.2.35 | 2025-03-29 | 56607 | Update dependencies |
| 0.2.34 | 2025-03-22 | 56156 | Update dependencies |
| 0.2.33 | 2025-03-08 | 55391 | Update dependencies |
| 0.2.32 | 2025-03-01 | 54853 | Update dependencies |
| 0.2.31 | 2025-02-22 | 54217 | Update dependencies |
| 0.2.30 | 2025-02-15 | 53940 | Update dependencies |
| 0.2.29 | 2025-02-08 | 53427 | Update dependencies |
| 0.2.28 | 2025-02-01 | 52946 | Update dependencies |
| 0.2.27 | 2025-01-25 | 49292 | Update dependencies |
| 0.2.26 | 2025-01-17 | 51560 | Fix connection issues |
| 0.2.25 | 2024-11-25 | 48672 | Update dependencies |
| 0.2.24 | 2024-10-29 | 47780 | Update dependencies |
| 0.2.23 | 2024-10-28 | 47100 | Update dependencies |
| 0.2.22 | 2024-10-12 | 46841 | Update dependencies |
| 0.2.21 | 2024-10-05 | 46420 | Update dependencies |
| 0.2.20 | 2024-09-28 | 46144 | Update dependencies |
| 0.2.19 | 2024-09-21 | 45744 | Update dependencies |
| 0.2.18 | 2024-09-14 | 45562 | Update dependencies |
| 0.2.17 | 2024-09-07 | 45245 | Update dependencies |
| 0.2.16 | 2024-08-31 | 44991 | Update dependencies |
| 0.2.15 | 2024-08-24 | 44698 | Update dependencies |
| 0.2.14 | 2024-08-22 | 44530 | Update test dependencies |
| 0.2.13 | 2024-08-17 | 44239 | Update dependencies |
| 0.2.12 | 2024-08-10 | 43682 | Update dependencies |
| 0.2.11 | 2024-08-03 | 43143 | Update dependencies |
| 0.2.10 | 2024-07-27 | 42703 | Update dependencies |
| 0.2.9 | 2024-07-20 | 42211 | Update dependencies |
| 0.2.8 | 2024-07-13 | 41789 | Update dependencies |
| 0.2.7 | 2024-07-10 | 41602 | Update dependencies |
| 0.2.6 | 2024-07-09 | 41118 | Update dependencies |
| 0.2.5 | 2024-07-06 | 40854 | Update dependencies |
| 0.2.4 | 2024-06-27 | 40578 | Replaced deprecated AirbyteLogger with logging.Logger |
| 0.2.3 | 2024-06-25 | 40494 | Update dependencies |
| 0.2.2 | 2024-06-22 | 40078 | Update dependencies |
| 0.2.1 | 2024-06-06 | 39157 | [autopull] Upgrade base image to v1.2.2 |
| 0.2.0 | 2024-05-08 | 36443 | Service account authentication support |
| 0.1.1 | 2024-03-05 | 35838 | Un-archive connector |
| 0.1.0 | 2022-05-18 | 13118 | New Destination: Firebolt |