Advanced Analytica Advanced Analytica: IBOM
← All connectors
Firebolt logo

Destination connector

Firebolt

Send governed data into Firebolt with a clear, practical setup guide.

Version 0.2.41 community alpha

Firebolt

Set up the Firebolt destination connector using this guide.

Prerequisites

  1. Firebolt Account: You need an active Firebolt account. If you don’t have one, sign up here.
  2. Firebolt Database and Engine created: Follow guide to create an engine in your Firebolt workspace if needed.
  3. 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:

  1. 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.

  2. 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
  • 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
  • Secret Access Key
    • The corresponding key for the key id above.

Setup guide

  1. Sign up to Firebolt by following the guide
  2. Follow the getting started tutorial to set up a database.
  3. Create a service account.
  4. Create an engine as described in here
  5. (Optional) Create a staging S3 bucket (for the S3 strategy).
  6. (Optional) Create an IAM with programmatic access to read, write and delete objects from an S3 bucket.

Supported sync modes

Sync modeSupported?
Full Refresh - OverwriteYes
Full Refresh - AppendYes
Full Refresh - Overwrite + DedupedNo
Incremental Sync - AppendYes
Incremental Sync - Append + DedupedNo

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 is VARCHAR.
  • _airbyte_emitted_at: a timestamp showing when the event was pulled from the data source. The column type in Firebolt is TIMESTAMP.
  • _airbyte_data: a json blob containing the event data. The column type in Firebolt is VARCHAR, but you can parse it with JSON functions.

Namespace support

This destination doesn’t support namespaces.

Changelog

Expand to review
VersionDatePull RequestSubject
0.2.412026-10-0788246Add missing destination_firebolt.run entrypoint module so the connector image starts with the shared python-connector Dockerfile
0.2.402025-05-2459866Update dependencies
0.2.392025-05-0359316Update dependencies
0.2.382025-04-2658725Update dependencies
0.2.372025-04-1957623Update dependencies
0.2.362025-04-0557115Update dependencies
0.2.352025-03-2956607Update dependencies
0.2.342025-03-2256156Update dependencies
0.2.332025-03-0855391Update dependencies
0.2.322025-03-0154853Update dependencies
0.2.312025-02-2254217Update dependencies
0.2.302025-02-1553940Update dependencies
0.2.292025-02-0853427Update dependencies
0.2.282025-02-0152946Update dependencies
0.2.272025-01-2549292Update dependencies
0.2.262025-01-1751560Fix connection issues
0.2.252024-11-2548672Update dependencies
0.2.242024-10-2947780Update dependencies
0.2.232024-10-2847100Update dependencies
0.2.222024-10-1246841Update dependencies
0.2.212024-10-0546420Update dependencies
0.2.202024-09-2846144Update dependencies
0.2.192024-09-2145744Update dependencies
0.2.182024-09-1445562Update dependencies
0.2.172024-09-0745245Update dependencies
0.2.162024-08-3144991Update dependencies
0.2.152024-08-2444698Update dependencies
0.2.142024-08-2244530Update test dependencies
0.2.132024-08-1744239Update dependencies
0.2.122024-08-1043682Update dependencies
0.2.112024-08-0343143Update dependencies
0.2.102024-07-2742703Update dependencies
0.2.92024-07-2042211Update dependencies
0.2.82024-07-1341789Update dependencies
0.2.72024-07-1041602Update dependencies
0.2.62024-07-0941118Update dependencies
0.2.52024-07-0640854Update dependencies
0.2.42024-06-2740578Replaced deprecated AirbyteLogger with logging.Logger
0.2.32024-06-2540494Update dependencies
0.2.22024-06-2240078Update dependencies
0.2.12024-06-0639157[autopull] Upgrade base image to v1.2.2
0.2.02024-05-0836443Service account authentication support
0.1.12024-03-0535838Un-archive connector
0.1.02022-05-1813118New Destination: Firebolt
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.